Comments by RKparmar - CodeProject

RKparmar 14-Nov-17 0:12am View

Thanks for solution.
But in winform Application there is not contentType Property.
so how can i manage this ?

DataRowView drv = dgvDocument.Rows[e.RowIndex].DataBoundItem as DataRowView;
string sql_string = "SELECT DOC_FILE FROM DOC_DET where SEQ_NO = " + drv["SEQ_NO"];
using (SqlCommand cmd = new SqlCommand(sql_string, con))
{
con.Open();

SqlDataReader dr = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(dr);
Byte[] bytes = (Byte[])dt.Rows[0]["DOC_FILE"];
con.Close();

if (drv["DOC_TYPE"].ToString() == ".pdf")
{
MemoryStream stream = new MemoryStream(bytes);
webBrowser1.DocumentStream = stream;
webBrowser1.Show();
}
}

RKparmar 28-Dec-14 23:24pm View

I AM USING MORE THEN ONE TABLE , AND I ALREADY MENTION WHAT I AM GETTING RESULT.

RKparmar 28-Dec-14 0:22am View

SELECT TITAL,PCS,RGH_CTS,VALUE
FROM (
SELECT COUNT(VPACKET_NO) PCS, SUM(CTS) RGH_CTS , SUM(TTL_NET_VALUE) VALUE , 'SEND' TITAL
FROM (
SELECT SEQ_NO,VPACKET_NO,CTS,MAX(TOTAL_NET_VALUE) TTL_NET_VALUE FROM (
SELECT ID.SEQ_NO, ID.VPACKET_NO,ID.CTS,
SUM((DBO.DISC_RATE(ISNULL(psd.RATE, ISNULL(tp.RATE,tp.RATE)), ISNULL(psd.DISC_PER, ISNULL(tp.DISC_PER,0))) * ROUND(ISNULL(psd.EXP_CTS, tp.EXP_CTS),3,1))) OVER (PARTITION BY tp.TRANS_ID, tp.PLAN_SEQ) TOTAL_NET_VALUE
FROM INV_DET ID
INNER JOIN TRANS_PLAN TP ON TP.INV_DET_SEQ = ID.SEQ_NO
LEFT JOIN PLAN_SEND_DET PSD ON PSD.SEQ_NO = TP.SEQ_NO
INNER JOIN PLAN_SEND_MAS PSM ON PSM.SEQ_NO = PSD.PLAN_SEND_SEQ
WHERE CAST(PSM.TRANS_DATE AS DATE) = CAST(GETDATE()-3 AS DATE) and
PSD.CANCEL_DATE IS NULL
)X
GROUP BY SEQ_NO,VPACKET_NO,CTS
)SND
UNION ALL
SELECT COUNT(VPACKET_NO) PCS , SUM(CTS) CTS , SUM(TTL_NET_VALUE) VALUE , 'BID' TITAL
FROM (
SELECT SEQ_NO,VPACKET_NO,CTS,MAX(TOTAL_NET_VALUE) TTL_NET_VALUE FROM (
SELECT ID.SEQ_NO, ID.VPACKET_NO,ID.CTS,
SUM((DBO.DISC_RATE(ISNULL(psd.RATE,TP.RATE), ISNULL(pb.DISC_PER,ISNULL(psd.DISC_PER,TP.DISC_PER))) * ROUND(ISNULL(psd.EXP_CTS, tp.EXP_CTS),3,1))) OVER (PARTITION BY tp.TRANS_ID, tp.PLAN_SEQ) TOTAL_NET_VALUE
FROM INV_DET ID
INNER JOIN TRANS_PLAN TP ON TP.INV_DET_SEQ = ID.SEQ_NO
INNER JOIN PLAN_SEND_DET PSD ON PSD.SEQ_NO = TP.SEQ_NO AND TP.IS_REJECT = 0
INNER JOIN PLAN_BID_DET PBD ON TP.SEQ_NO = PBD.TRANS_PLAN_SEQ
INNER JOIN PLAN_BID_MAS PBM ON PBD.PLAN_BID_SEQ = PBM.SEQ_NO
LEFT JOIN ( SELECT pbdX.*, pbmX.TRANS_DATE BID_DATE
FROM PLAN_BID_DET pbdX
INNER JOIN PLAN_BID_MAS pbmX on pbdX.PLAN_BID_SEQ = pbmX.SEQ_NO
INNER JOIN PLAN_SEND_DET psdX on pbdX.TRANS_PLAN_SEQ = psdX.SEQ_NO AND psdX.CANCEL_DATE IS NULL
WHERE pbmX.BIDDER_SEQ = ISNULL(23, pbmX.BIDDER_SEQ)
) pb ON pb.TRANS_PLAN_SEQ = psd.SEQ_NO
LEFT JOIN NAME_MAS NM ON NM.SEQ_NO = TP.EMP_SEQ
WHERE CAST(pbm.TRANS_DATE AS DATE) = CAST(GETDATE()-3 AS DATE)
AND PBD.CANCEL_DATE IS NULL AND PSD.BID_DET_SEQ IS NOT NULL
AND tp.TRANS_TYPE_SEQ IN (1162)
AND NM.CODE_NO <> 'TRY'
AND TP.IS_REJECT = 0
)X
GROUP BY SEQ_NO,VPACKET_NO,CTS
)BID
UNION ALL
SELECT COUNT(VPACKET_NO) PCS , SUM(CTS) CTS , SUM(TTL_NET_VALUE) VALUE , 'FINAL' TITAL
FROM (
SELECT SEQ_NO,VPACKET_NO,CTS,MAX(TOTAL_NET_VALUE) TTL_NET_VALUE FROM (
SELECT ID.SEQ_NO, ID.VPACKET_NO,ID.CTS,
SUM((DBO.DISC_RATE(ISNULL(psd.RATE,TP.RATE), ISNULL(pb.DISC_PER,ISNULL(psd.DISC_PER,TP.DISC_PER))) * ROUND(ISNULL(psd.EXP_CTS, tp.EXP_CTS),3,1))) OVER (PARTITION BY tp.TRANS_ID, tp.PLAN_SEQ) TOTAL_NET_VALUE
FROM INV_DET ID
INNER JOIN TRANS_PLAN TP ON TP.INV_DET_SEQ = ID.SEQ_NO
INNER JOIN PLAN_SEND_DET PSD ON PSD.SEQ_NO = TP.SEQ_NO
LEFT JOIN ( SELECT pbdX.*, pbmX.TRANS_DATE BID_DATE
FROM PLAN_BID_DET pbdX
INNER JOIN PLAN_BID_MAS pbmX on pbdX.PLAN_BID_SEQ = pbmX.SEQ_NO
INNER JOIN PLAN_SEND_DET psdX on pbdX.TRANS_PLAN_SEQ = psdX.SEQ_NO AND psdX.CANCEL_DATE IS NULL
WHERE pbmX.BIDDER_SEQ = ISNULL(23, pbmX.BIDDER_SEQ)
) pb ON pb.TRANS_PLAN_SEQ = psd.SEQ_NO
WHERE CAST(PSD.FINAL_DATE AS DATE) = CAST(GETDATE()-3 AS DATE) AND PSD.FINAL_TYPE= 1 AND PSD.CANCEL_DATE IS NULL
)X
GROUP BY SEQ_NO,VPACKET_NO,CTS
)BID
) MAIN

RKparmar 21-Jan-14 4:20am View

yes

RKparmar 9-Jan-14 2:28am View

HI ,

I use this but in this i m not calculate sum of time

select right('0' + cast(datediff(hh, '2014-01-02 08:30:00.000','2014-01-04 18:20:00.000') as varchar),2) +':' + right('0' + cast(datediff(mi, '2014-01-02 08:30:00.000','2014-01-04 18:20:00.000') % 60 as varchar),2) as HoursMin

i got more then one record from database . how to sum this all HoursMin column sum ?

RKparmar 8-Jan-14 6:46am View

from : at 8:00 AM to 7:00 PM and Sunday is holidays.

RKparmar 7-Jan-14 6:20am View

Hi use this :
SELECT select CONVERT(varchar(10),NW_NewsDate,110) FROM news_master WHERE NW_NewsDate between '2014-01-07 00:00:00' AND '2014-01-07 23:59:00' ORDER BY NW_SerialNo ASC

RKparmar 3-Jan-14 8:18am View

Thank You .

RKparmar 30-Dec-13 0:06am View

Hi ,
thank you for your reply .
i read and implement that but i want to replicate two server between on was in surat location and another in mumbai . on network and web base any solution ? to create any IIS configuration require ?

thank you. :)

Comments by RKparmar (Top 9 by date)