private void GenerateReport(string code)
{
DL_DBAccess = new DatabaseAccessLayer();
string Query = "";
try
{
string BatchType = DL_DBAccess.GetColumn("select isnull(BT_TYPE,0) as BT_TYPE from BATCH_MASTER,FILL_OFF_SHEET where FOS_BT_CODE=BT_CODE and BATCH_MASTER.ES_DELETE=0 and FOS_CODE='" + code + "'");
if (BatchType == "1")
{
Query = "select BT_NO,SHM_FORMULA_CODE as SHM_FORMULA_NAME,P_NAME,FOS_FINAL_YIELD,FOS_NOTES,FOS_FILTER_USED,FOSD_TYPE,FOSD_QTY,FOSD_WGT,I_UOM_NAME as UOM_NAME,FOS_DATE,FOS_FILL_DATE,sum(isnull(BTD_QTY,0)) as QTY_IN_LTR,sum(isnull(BTD_WGT,0)) as WEIGHT_IN_KG,(CASE FOSD_TYPE WHEN 1 THEN 'Package' WHEN 2 THEN 'Extra' WHEN 3 THEN 'Sample' END) AS Type_Name from BATCH_MASTER,BATCH_DETAIL,SHADE_MASTER,WORK_ORDER_MASTER,PARTY_MASTER,FILL_OFF_SHEET,FILL_OFF_SHEET_DETAIL,ITEM_UNIT_MASTER where BT_CODE=BTD_BT_CODE and BT_SHM_CODE=SHM_CODE and FOS_BT_CODE=BT_CODE and FOS_CODE=FOSD_FOS_CODE and SHADE_MASTER.ES_DELETE=0 and BT_WO_CODE=WO_CODE and WORK_ORDER_MASTER.ES_DELETE=0 and WO_P_CODE=P_CODE and PARTY_MASTER.ES_DELETE=0 and FOSD_UOM_CODE=I_UOM_CODE and ITEM_UNIT_MASTER.ES_DELETE=0 and FOS_CODE='" + code + "' group by BT_NO,SHM_FORMULA_CODE,P_NAME,FOS_APPROVED_BY,FOS_SPECIAL_INSTR,FOS_FILL_BY,FOS_FINAL_YIELD,FOS_NOTES,FOS_FILTER_USED,FOSD_TYPE,FOSD_QTY,FOSD_WGT,I_UOM_NAME,FOS_DATE,FOS_FILL_DATE order by FOSD_TYPE";
}
else
{
Query = "select BT_NO,SHM_FORMULA_CODE as SHM_FORMULA_NAME,'' as P_NAME,FOS_FINAL_YIELD,FOS_NOTES,FOS_FILTER_USED,FOSD_TYPE,FOSD_QTY,FOSD_WGT,I_UOM_NAME as UOM_NAME,FOS_DATE,FOS_FILL_DATE,sum(isnull(BTD_QTY,0)) as QTY_IN_LTR,sum(isnull(BTD_WGT,0)) as WEIGHT_IN_KG,(CASE FOSD_TYPE WHEN 1 THEN 'Package' WHEN 2 THEN 'Extra' WHEN 3 THEN 'Sample' END) AS Type_Name from BATCH_MASTER,BATCH_DETAIL,SHADE_MASTER,FILL_OFF_SHEET,FILL_OFF_SHEET_DETAIL,ITEM_UNIT_MASTER where BT_CODE=BTD_BT_CODE and BT_SHM_CODE=SHM_CODE and FOS_BT_CODE=BT_CODE and FOS_CODE=FOSD_FOS_CODE and SHADE_MASTER.ES_DELETE=0 and FOSD_UOM_CODE=I_UOM_CODE and ITEM_UNIT_MASTER.ES_DELETE=0 and FOS_CODE='" + code + "' group by BT_NO,SHM_FORMULA_CODE,FOS_APPROVED_BY,FOS_SPECIAL_INSTR,FOS_FILL_BY,FOS_FINAL_YIELD,FOS_NOTES,FOS_FILTER_USED,FOSD_TYPE,FOSD_QTY,FOSD_WGT,I_UOM_NAME,FOS_DATE,FOS_FILL_DATE order by FOSD_TYPE";
}
DataTable dtfinal = CommonClasses.Execute(Query);
if (dtfinal.Rows.Count > 0)
{
ReportDocument rptname = null;
rptname = new ReportDocument();
rptname.Load(Server.MapPath("~/Reports/rptFillOffSheetPrint.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptFillOffSheetPrint.rpt");
rptname.Refresh();
rptname.SetDataSource(dtfinal);
CrystalReportViewer1.ReportSource = rptname;
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Fill Off Sheet Print", "GenerateReport", Ex.Message);
}
}
protected void ddlWorkOrderNo_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (ddlWorkOrderNo.SelectedIndex != 0)
{
if (ddlBatchType.SelectedValue == "1")
{
DataTable dtItem = CommonClasses.FillCombo("ITEM_MASTER,WORK_ORDER_MASTER,WORK_ORDER_DETAIL", "I_CODENO", "I_CODE", "ITEM_MASTER.ES_DELETE=0 and WORK_ORDER_MASTER.ES_DELETE=0 and WO_CODE=WOD_WO_CODE and WOD_I_CODE=I_CODE and WO_CODE='" + ddlWorkOrderNo.SelectedValue + "' AND I_CM_COMP_ID='" + Convert.ToInt32(Session["CompanyId"]) + "'", ddlItemCode);
ddlItemCode.Items.Insert(0, new ListItem("Please Select Item Code", "0"));
if (dtItem.Rows.Count > 0)
{
ddlItemCode.SelectedIndex = 1;
DatabaseAccessLayer dbaccess = new DatabaseAccessLayer();
txtWorkOrdQty.Text = dbaccess.GetColumn("select WOD_WORK_ORDER_QTY from WORK_ORDER_MASTER,WORK_ORDER_DETAIL where WO_CODE='" + ddlWorkOrderNo.SelectedValue + "' and WOD_WO_CODE=WO_CODE and WOD_I_CODE='" + ddlItemCode.SelectedValue + "' ");
}
}
else
{
LoadICode();
}
}
else
{
LoadICode();
}
}
catch (Exception Ex)
{
CommonClasses.SendError(" Batch Ticket", "ddlWorkOrderNo_SelectedIndexChanged", Ex.Message);
}
}
private void GenerateReport(string code)
{
DL_DBAccess = new DatabaseAccessLayer();
try
{
DataTable dtfinal = CommonClasses.Execute("select INQ_CODE,INQ_CM_COMP_ID,INQ_NO,INQ_TYPE,INQ_GLOSS,INQ_SHADE_NAME,P_NAME as INQ_CUST_NAME,INQ_SHADE_CODE,INQ_SHADE_NO,INQ_REQ_DATE,INQ_REQ_BY,INQ_DES_DUE_DATE,INQ_END_USE,INQ_SUBRTATE,INQ_PRIMER_DFT,INQ_VOL_SOLID,INQ_DFT,INQ_PMT,INQ_CUST_SPEC,INQ_NOTE,INQ_COMP_DATE from ENQUIRY_MASTER,PARTY_MASTER where INQ_CUST_NAME=P_CODE and INQ_CODE='" + code + "' and ENQUIRY_MASTER.ES_DELETE=0");
if (dtfinal.Rows.Count > 0)
{
ReportDocument rptname = null;
rptname = new ReportDocument();
rptname.Load(Server.MapPath("~/Reports/rptCustomerEnquiryPrint.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptCustomerEnquiryPrint.rpt");
rptname.Refresh();
rptname.SetDataSource(dtfinal);
rptname.SetParameterValue("txtCompIso", Session["CompanyIso"].ToString());
string IsoNo = DL_DBAccess.GetColumn("select ISO_NO from ISONO_MASTER,ENQUIRY_MASTER where INQ_CODE='" + code + "' and ISO_SCREEN_NO=95 and ISO_WEF_DATE<=INQ_REQ_DATE order by ISO_WEF_DATE DESC");
if (IsoNo == "")
{
rptname.SetParameterValue("txtIsoNo", "1");
}
else
{
rptname.SetParameterValue("txtIsoNo", IsoNo.ToString());
}
CrystalReportViewer1.ReportSource = rptname;
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Customer Enquiry Print", "GenerateReport", Ex.Message);
}
}
private void GenerateReport(string code)
{
DL_DBAccess = new DatabaseAccessLayer();
DataTable dtfinal = CommonClasses.Execute("select WO_AMC_CODE,WO_AMC_NO,CONVERT(varchar,WO_PO_DATE,103) as WO_PO_DATE,WO_P_CODE,P_NAME,P_ADD1,WO_TYPE,WO_REF,WO_CONTACT_PER,WO_PHONE_NO,WO_DELIVERY_SCHD,WO_PAY_TERM,WO_DELIVER_TO,WO_FRIEGHT_TERM,WO_GARUNTEE_TERM,WO_TRANSPORTOR,WO_NOTE,cast(isnull(WO_SER_TAX_PER,0) as numeric(20,2)) as WO_SER_TAX_PER,WO_TAX_APPLICABLE,cast(WO_GRAND_TOT as numeric(20,2)) as WO_GRAND_TOT,WOD_PROD_NAME,WOD_PROD_DESC,WOD_PREV_MAINTAIN_DEC,cast(WOD_QTY as numeric(20,3)) as WOD_QTY,cast(WOD_RATE as numeric(20,2)) as WOD_RATE,cast(WOD_TOT_AMT as numeric(20,2)) as WOD_TOT_AMT,CM_EXCISE_RANGE,CM_EXCISE_DIVISION,CM_COMMISONERATE,CM_PAN_NO,CM_CST_NO,CM_VAT_TIN_NO,CM_VAT_WEF,CM_CST_WEF,CM_BANK_NAME,CM_BANK_ACC_NO,CM_OWNER,UM_NAME,I_UOM_NAME from WORK_AMC_ORDER_MASTER,WORK_AMC_ORDER_DETAIL,PARTY_MASTER,USER_MASTER,COMPANY_MASTER,ITEM_UNIT_MASTER where WOD_WO_AMC_CODE=WO_AMC_CODE and I_UOM_CODE=WOD_UOM_CODE and WO_P_CODE=P_CODE and WO_CM_CODE=CM_CODE and WO_UM_CODE=UM_CODE and WORK_AMC_ORDER_MASTER.ES_DELETE=0 and WO_AMC_CODE='" + Code + "' and WO_TYPE='AMC' ");
if (dtfinal.Rows.Count > 0)
{
}
try
{
ReportDocument rptname = null;
rptname = new ReportDocument();
rptname.Load(Server.MapPath("~/Reports/rptAMCPrint.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptAMCPrint.rpt");
rptname.Refresh();
rptname.SetDataSource(dtfinal);
string IsoNo = DL_DBAccess.GetColumn("select ISO_NO from ISONO_MASTER,WORK_AMC_ORDER_MASTER where WO_AMC_CODE='" + code + "' and ISO_SCREEN_NO=85 and ISO_WEF_DATE<=WO_PO_DATE order by ISO_WEF_DATE DESC");
rptname.SetParameterValue("txtIsoNo", IsoNo);
if (IsoNo == "")
{
rptname.SetParameterValue("txtIsoNo", "1");
}
else
{
rptname.SetParameterValue("txtIsoNo", IsoNo.ToString());
}
CrystalReportViewer1.ReportSource = rptname;
}
catch (Exception Ex)
{
CommonClasses.SendError("AMC Print", "GenerateReport", Ex.Message);
}
}
private void GenerateReport(string code)
{
DL_DBAccess = new DatabaseAccessLayer();
string Query = "";
try
{
string BatchType = DL_DBAccess.GetColumn("select isnull(BT_TYPE,0) as BT_TYPE from BATCH_MASTER where BT_CODE='" + code + "'");
if (BatchType == "1")
{
Query = "select BT_NO,BT_DATE,SHM_FORMULA_CODE,SHM_FORMULA_NAME,P_NAME,BTD_PROCESS_CODE as PROCESS_CODE,PROCESS_NAME, I_CODENO,I_CODE,BTD_STEP_NO as STEP_NO,BTD_QTY as QTY_IN_LTR,BTD_WGT as WEIGHT_IN_KG,BTD_QTY_IN as QtyinKG from BATCH_MASTER,BATCH_DETAIL,PROCESS_MASTER,ITEM_MASTER ,SHADE_MASTER,WORK_ORDER_MASTER,PARTY_MASTER where BT_CODE=BTD_BT_CODE and BTD_PROCESS_CODE=PROCESS_CODE and PROCESS_MASTER.ES_DELETE=0 and ITEM_MASTER.ES_DELETE=0 and BTD_I_CODE=I_CODE and BT_SHM_CODE=SHM_CODE and SHADE_MASTER.ES_DELETE=0 and BT_WO_CODE=WO_CODE and WORK_ORDER_MASTER.ES_DELETE=0 and WO_P_CODE=P_CODE and PARTY_MASTER.ES_DELETE=0 and BT_CODE='" + code + "' order by BTD_STEP_NO,I_CODENO";
}
else
{
Query = "select BT_NO,BT_DATE,SHM_FORMULA_CODE,SHM_FORMULA_NAME,'' as P_NAME,BTD_PROCESS_CODE as PROCESS_CODE,PROCESS_NAME, I_CODENO,I_CODE,BTD_STEP_NO as STEP_NO,BTD_QTY as QTY_IN_LTR,BTD_WGT as WEIGHT_IN_KG,BTD_QTY_IN as QtyinKG from BATCH_MASTER,BATCH_DETAIL,PROCESS_MASTER,ITEM_MASTER ,SHADE_MASTER where BT_CODE=BTD_BT_CODE and BTD_PROCESS_CODE=PROCESS_CODE and PROCESS_MASTER.ES_DELETE=0 and ITEM_MASTER.ES_DELETE=0 and BTD_I_CODE=I_CODE and BT_SHM_CODE=SHM_CODE and SHADE_MASTER.ES_DELETE=0 and BT_CODE='" + code + "' order by BTD_STEP_NO,I_CODENO";
}
DataTable dtfinal = CommonClasses.Execute(Query);
if (dtfinal.Rows.Count > 0)
{
ReportDocument rptname = null;
rptname = new ReportDocument();
rptname.Load(Server.MapPath("~/Reports/rptBatchTicketPrint.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptBatchTicketPrint.rpt");
rptname.Refresh();
rptname.SetDataSource(dtfinal);
//rptname.SetParameterValue("txtCompIso", Session["CompanyIso"].ToString());
//string IsoNo = DL_DBAccess.GetColumn("select ISO_NO from ISONO_MASTER,ENQUIRY_MASTER where INQ_CODE='" + code + "' and ISO_SCREEN_NO=94 and ISO_WEF_DATE<=INQ_REQ_DATE order by ISO_WEF_DATE DESC");
//if (IsoNo == "")
//{
// rptname.SetParameterValue("txtIsoNo", "1");
//}
//else
//{
// rptname.SetParameterValue("txtIsoNo", IsoNo.ToString());
//}
CrystalReportViewer1.ReportSource = rptname;
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Batch Ticket Print", "GenerateReport", Ex.Message);
}
}
private void GenerateReport(string code)
{
DL_DBAccess = new DatabaseAccessLayer();
//DataTable dtfinal = CommonClasses.Execute("select EM_CODE ,EM_NAME ,BM_NAME,CONVERT(VARCHAR(11),EM_JOINDATE,113) as EM_JOINDATE,CONVERT(VARCHAR(11),FS_LEAVE_DATE,113) as FS_LEAVE_DATE,CONVERT(VARCHAR(11),FS_RESIGN_DATE,113) as FS_RESIGN_DATE,DS_NAME,FS_LAST_SAL,FS_BONUS_AMT,FS_LEAVE_AMT,FS_LTA_AMT,FS_ADV_AMT,FS_LOAN_AMT,FS_NOTICE_AMT,FS_FINAL_AMT,FS_PAYABLE_LEAVES as LeaveDay,FS_NOTICE_DAYS as NoticeDay from HR_FINAL_SETTLEMENT,HR_EMPLOYEE_MASTER,HR_DESINGNATION_MASTER,CM_BRANCH_MASTER where EM_CODE=FS_EM_CODE and BM_CODE=EM_BM_CODE and EM_DM_CODE=DS_CODE and FS_CODE=" + fsCode + " and FS_DELETE_FLAG=0 and FS_CM_COMP_ID=" + Session["CompanyId"].ToString() + "");
try
{
// DataTable dtfinal = CommonClasses.Execute("SELECT DISTINCT(I_CODE),P_CODE,P_NAME,P_ADD1,P_VEND_CODE,P_CST,P_VAT,P_ECC_NO,INM_NO,INM_DATE,INM_TRANSPORT,INM_VEH_NO,INM_LR_NO,INM_LR_DATE,I_NAME,CPOD_CUST_I_CODE,CPOD_CUST_I_NAME,CPOM_PONO,CONVERT(VARCHAR(11),CPOM_DATE,113) as CPOM_DATE,IND_SUBHEADING,IND_BACHNO,IND_NO_PACK,IND_PAK_QTY,IND_INQTY,IND_RATE,E_BASIC,E_SPECIAL,E_EDU_CESS,E_H_EDU,ST_TAX_NAME,ST_SALES_TAX FROM EXCISE_TARIFF_MASTER,CUSTPO_DETAIL,CUSTPO_MASTER,INVOICE_MASTER,INVOICE_DETAIL,ITEM_MASTER,SALES_TAX_MASTER,PARTY_MASTER WHERE INM_CODE = IND_INM_CODE and CPOD_CPOM_CODE = CPOM_CODE and INM_P_CODE = P_CODE AND INM_P_CODE = CPOM_P_CODE and CPOM_CODE = IND_CPOM_CODE AND IND_I_CODE=CPOD_I_CODE and IND_I_CODE = I_CODE and I_E_CODE=E_CODE and IND_I_CODE=CPOD_I_CODE AND CPOD_ST_CODE=ST_CODE and INM_CODE='" + code + "' group by I_CODE,INM_NO,P_CODE,P_NAME,P_ADD1,P_VEND_CODE,P_CST,P_VAT,P_ECC_NO,INM_DATE,INM_TRANSPORT,INM_LR_NO,INM_LR_DATE,I_NAME,CPOD_CUST_I_CODE,CPOD_CUST_I_NAME,CPOM_PONO,CPOM_DATE,IND_SUBHEADING,IND_BACHNO,IND_NO_PACK,IND_PAK_QTY,IND_INQTY,IND_RATE,E_BASIC,E_SPECIAL,E_EDU_CESS,E_H_EDU,INM_VEH_NO,ST_TAX_NAME,ST_SALES_TAX");
//DataTable dtfinal = CommonClasses.Execute("SELECT DISTINCT(I_CODE),P_CODE,E_TARIFF_NO,P_NAME,P_ADD1,P_VEND_CODE,P_CST,P_VAT,P_ECC_NO,INM_NO,INM_DATE,INM_TRANSPORT,INM_VEH_NO,INM_LR_NO,INM_LR_DATE,I_NAME,CPOD_CUST_I_CODE,CPOD_CUST_I_NAME,CPOM_PONO,ST_TAX_NAME,CONVERT(VARCHAR(11),CPOM_DATE,113) as CPOM_DATE,IND_SUBHEADING,IND_BACHNO,IND_NO_PACK,cast(isnull(IND_PAK_QTY,0) as numeric(20,3)) as IND_PAK_QTY,cast(isnull(IND_INQTY,0) as numeric(20,3)) as IND_INQTY,cast(isnull(IND_RATE,0) as numeric(20,2)) as IND_RATE,cast(isnull(IND_AMT,0) as numeric(20,2)) as IND_AMT,cast(isnull(INM_NET_AMT,0) as numeric(20,2)) as INM_NET_AMT,cast(isnull(INM_DISC,0) as numeric(20,2)) as INM_DISC,cast(isnull(INM_DISC_AMT,0) as numeric(20,2)) as INM_DISC_AMT,cast(isnull(INM_PACK_AMT,0) as numeric(20,2)) as INM_PACK_AMT,cast(isnull(INM_ACCESSIBLE_AMT,0) as numeric(20,2)) as INM_ACCESSIBLE_AMT,cast(isnull(INM_BEXCISE,0) as numeric(20,2)) as INM_BEXCISE,cast(isnull(INM_BE_AMT,0) as numeric(20,2)) as INM_BE_AMT,cast(isnull(INM_EDUC_CESS,0) as numeric(20,2)) as INM_EDUC_CESS,cast(isnull(INM_EDUC_AMT,0) as numeric(20,2)) as INM_EDUC_AMT,cast(isnull(INM_H_EDUC_CESS,0) as numeric(20,2)) as INM_H_EDUC_CESS,cast(isnull(INM_H_EDUC_AMT,0) as numeric(20,2)) as INM_H_EDUC_AMT,cast(isnull(INM_TAXABLE_AMT,0) as numeric(20,2)) as INM_TAXABLE_AMT,cast(isnull(INM_S_TAX,0) as numeric(20,2)) as INM_S_TAX,cast(isnull(INM_S_TAX_AMT,0) as numeric(20,2)) as INM_S_TAX_AMT,cast(isnull(INM_OTHER_AMT,0) as numeric(20,2)) as INM_OTHER_AMT,cast(isnull(INM_FREIGHT,0) as numeric(20,2)) as INM_FREIGHT,cast(isnull(INM_INSURANCE,0) as numeric(20,2)) as INM_INSURANCE,cast(isnull(INM_TRANS_AMT,0) as numeric(20,2)) as INM_TRANS_AMT,cast(isnull(INM_OCTRI_AMT,0) as numeric(20,2)) as INM_OCTRI_AMT,cast(isnull(INM_ROUNDING_AMT,0) as numeric(20,2)) as INM_ROUNDING_AMT,cast(isnull(INM_G_AMT,0) as numeric(20,2)) as INM_G_AMT,cast(isnull(INM_TAX_TCS_AMT,0) as numeric(20,2)) as INM_TAX_TCS_AMT FROM EXCISE_TARIFF_MASTER,CUSTPO_DETAIL,CUSTPO_MASTER,INVOICE_MASTER,INVOICE_DETAIL,ITEM_MASTER,SALES_TAX_MASTER,PARTY_MASTER WHERE INM_CODE = IND_INM_CODE and CPOD_CPOM_CODE = CPOM_CODE and INM_P_CODE = P_CODE AND INM_P_CODE = CPOM_P_CODE and CPOM_CODE = IND_CPOM_CODE AND IND_I_CODE=CPOD_I_CODE and IND_I_CODE = I_CODE and I_E_CODE=E_CODE and IND_I_CODE=CPOD_I_CODE AND CPOD_ST_CODE=ST_CODE and INM_CODE='" + code + "' group by I_CODE,INM_NO,P_CODE,P_NAME,P_ADD1,P_VEND_CODE,P_CST,P_VAT,P_ECC_NO ,INM_DATE,INM_TRANSPORT,INM_LR_NO,INM_LR_DATE,I_NAME,CPOD_CUST_I_CODE,CPOD_CUST_I_NAME ,CPOM_PONO,CPOM_DATE,IND_SUBHEADING,IND_BACHNO,IND_NO_PACK,IND_PAK_QTY,IND_INQTY,IND_RATE ,E_BASIC,E_SPECIAL,E_EDU_CESS,E_H_EDU,INM_VEH_NO,ST_TAX_NAME,ST_SALES_TAX ,E_TARIFF_NO,IND_AMT,INM_NET_AMT,INM_DISC,INM_DISC_AMT,INM_PACK_AMT,INM_ACCESSIBLE_AMT,INM_BEXCISE,INM_BE_AMT,INM_EDUC_CESS,INM_EDUC_AMT,INM_H_EDUC_CESS,INM_H_EDUC_AMT,INM_TAXABLE_AMT,INM_S_TAX,INM_S_TAX_AMT,INM_OTHER_AMT,INM_FREIGHT,INM_INSURANCE,INM_TRANS_AMT,INM_OCTRI_AMT,INM_ROUNDING_AMT,INM_G_AMT,ST_TAX_NAME,INM_TAX_TCS_AMT");
//DataTable dtfinal = CommonClasses.Execute("SELECT DISTINCT(I_CODE),P_CODE,E_TARIFF_NO,P_NAME,P_ADD1,P_VEND_CODE,P_CST,P_VAT,P_ECC_NO,INM_NO,INM_DATE,INM_TRANSPORT,INM_VEH_NO,INM_LR_NO,INM_LR_DATE,I_NAME,CPOD_CUST_I_CODE,IND_PACK_DESC as CPOD_CUST_I_NAME,CPOM_PONO,ST_TAX_NAME,CONVERT(VARCHAR(11),CPOM_DATE,113) as CPOM_DATE,IND_SUBHEADING,IND_BACHNO,IND_NO_PACK,cast(isnull(IND_PAK_QTY,0) as numeric(20,3)) as IND_PAK_QTY,cast(isnull(IND_INQTY,0) as numeric(20,3)) as IND_INQTY,cast(isnull(IND_RATE,0) as numeric(20,2)) as IND_RATE,cast(isnull(IND_AMT,0) as numeric(20,2)) as IND_AMT,cast(isnull(INM_NET_AMT,0) as numeric(20,2)) as INM_NET_AMT,cast(isnull(INM_DISC,0) as numeric(20,2)) as INM_DISC,cast(isnull(INM_DISC_AMT,0) as numeric(20,2)) as INM_DISC_AMT,cast(isnull(INM_PACK_AMT,0) as numeric(20,2)) as INM_PACK_AMT,cast(isnull(INM_ACCESSIBLE_AMT,0) as numeric(20,2)) as INM_ACCESSIBLE_AMT,cast(isnull(INM_BEXCISE,0) as numeric(20,2)) as INM_BEXCISE,cast(isnull(INM_BE_AMT,0) as numeric(20,2)) as INM_BE_AMT,cast(isnull(INM_EDUC_CESS,0) as numeric(20,2)) as INM_EDUC_CESS,cast(isnull(INM_EDUC_AMT,0) as numeric(20,2)) as INM_EDUC_AMT,cast(isnull(INM_H_EDUC_CESS,0) as numeric(20,2)) as INM_H_EDUC_CESS,cast(isnull(INM_H_EDUC_AMT,0) as numeric(20,2)) as INM_H_EDUC_AMT,cast(isnull(INM_TAXABLE_AMT,0) as numeric(20,2)) as INM_TAXABLE_AMT,cast(isnull(INM_S_TAX,0) as numeric(20,2)) as INM_S_TAX,cast(isnull(INM_S_TAX_AMT,0) as numeric(20,2)) as INM_S_TAX_AMT,cast(isnull(INM_OTHER_AMT,0) as numeric(20,2)) as INM_OTHER_AMT,cast(isnull(INM_FREIGHT,0) as numeric(20,2)) as INM_FREIGHT,cast(isnull(INM_INSURANCE,0) as numeric(20,2)) as INM_INSURANCE,cast(isnull(INM_TRANS_AMT,0) as numeric(20,2)) as INM_TRANS_AMT,cast(isnull(INM_OCTRI_AMT,0) as numeric(20,2)) as INM_OCTRI_AMT,cast(isnull(INM_ROUNDING_AMT,0) as numeric(20,2)) as INM_ROUNDING_AMT,cast(isnull(INM_G_AMT,0) as numeric(20,2)) as INM_G_AMT,cast(isnull(INM_TAX_TCS_AMT,0) as numeric(20,2)) as INM_TAX_TCS_AMT,INM_ISSUE_DATE,INM_REMOVAL_DATE,INM_ISSU_TIME,INM_REMOVEL_TIME FROM EXCISE_TARIFF_MASTER,CUSTPO_DETAIL,CUSTPO_MASTER,INVOICE_MASTER,INVOICE_DETAIL,ITEM_MASTER,SALES_TAX_MASTER,PARTY_MASTER WHERE INM_CODE = IND_INM_CODE and CPOD_CPOM_CODE = CPOM_CODE and INM_P_CODE = P_CODE AND INM_P_CODE = CPOM_P_CODE and CPOM_CODE = IND_CPOM_CODE AND IND_I_CODE=CPOD_I_CODE and IND_I_CODE = I_CODE and I_E_CODE=E_CODE and IND_I_CODE=CPOD_I_CODE AND CPOD_ST_CODE=ST_CODE and INM_CODE='" + code + "' ");
DataTable dtfinal = CommonClasses.Execute("SELECT DISTINCT(I_CODE),P_CODE,E_TARIFF_NO,P_NAME,P_ADD1,P_VEND_CODE,P_CST,P_VAT,P_ECC_NO,INM_NO,INM_DATE,INM_TRANSPORT,INM_VEH_NO,INM_LR_NO,INM_LR_DATE,I_NAME,'' AS CPOD_CUST_I_CODE,IND_PACK_DESC as CPOD_CUST_I_NAME,cast(SPOM_PO_NO as numeric(20,0)) AS CPOM_PONO,ST_TAX_NAME,CONVERT(VARCHAR(11),PR_DATE,113) as CPOM_DATE,IND_SUBHEADING,IND_BACHNO,IND_NO_PACK,cast(isnull(IND_PAK_QTY,0) as numeric(20,3)) as IND_PAK_QTY,cast(isnull(IND_INQTY,0) as numeric(20,3)) as IND_INQTY,cast(isnull(IND_RATE,0) as numeric(20,2)) as IND_RATE,cast(isnull(IND_AMT,0) as numeric(20,2)) as IND_AMT,cast(isnull(INM_NET_AMT,0) as numeric(20,2)) as INM_NET_AMT,cast(isnull(INM_DISC,0) as numeric(20,2)) as INM_DISC,cast(isnull(INM_DISC_AMT,0) as numeric(20,2)) as INM_DISC_AMT,cast(isnull(INM_PACK_AMT,0) as numeric(20,2)) as INM_PACK_AMT,cast(isnull(INM_ACCESSIBLE_AMT,0) as numeric(20,2)) as INM_ACCESSIBLE_AMT,cast(isnull(INM_BEXCISE,0) as numeric(20,2)) as INM_BEXCISE,cast(isnull(INM_BE_AMT,0) as numeric(20,2)) as INM_BE_AMT,cast(isnull(INM_EDUC_CESS,0) as numeric(20,2)) as INM_EDUC_CESS,cast(isnull(INM_EDUC_AMT,0) as numeric(20,2)) as INM_EDUC_AMT,cast(isnull(INM_H_EDUC_CESS,0) as numeric(20,2)) as INM_H_EDUC_CESS,cast(isnull(INM_H_EDUC_AMT,0) as numeric(20,2)) as INM_H_EDUC_AMT,cast(isnull(INM_TAXABLE_AMT,0) as numeric(20,2)) as INM_TAXABLE_AMT,cast(isnull(INM_S_TAX,0) as numeric(20,2)) as INM_S_TAX,cast(isnull(INM_S_TAX_AMT,0) as numeric(20,2)) as INM_S_TAX_AMT,cast(isnull(INM_OTHER_AMT,0) as numeric(20,2)) as INM_OTHER_AMT,cast(isnull(INM_FREIGHT,0) as numeric(20,2)) as INM_FREIGHT,cast(isnull(INM_INSURANCE,0) as numeric(20,2)) as INM_INSURANCE,cast(isnull(INM_TRANS_AMT,0) as numeric(20,2)) as INM_TRANS_AMT,cast(isnull(INM_OCTRI_AMT,0) as numeric(20,2)) as INM_OCTRI_AMT,cast(isnull(INM_ROUNDING_AMT,0) as numeric(20,2)) as INM_ROUNDING_AMT,cast(isnull(INM_G_AMT,0) as numeric(20,2)) as INM_G_AMT,cast(isnull(INM_TAX_TCS_AMT,0) as numeric(20,2)) as INM_TAX_TCS_AMT,INM_ISSUE_DATE,INM_REMOVAL_DATE,INM_ISSU_TIME,INM_REMOVEL_TIME FROM EXCISE_TARIFF_MASTER,PURCHASE_REJECTION_DETAIL,PURCHASE_REJECTION_MASTER,INVOICE_MASTER,INVOICE_DETAIL,ITEM_MASTER,SALES_TAX_MASTER,PARTY_MASTER,SUPP_PO_MASTER WHERE INM_CODE = IND_INM_CODE and PR_CODE = PRD_PR_CODE and INM_P_CODE = P_CODE AND INM_P_CODE =PR_P_CODE and SPOM_CODE = IND_CPOM_CODE AND IND_I_CODE=PRD_I_CODE and IND_I_CODE = I_CODE and I_E_CODE=E_CODE and IND_I_CODE=PRD_I_CODE AND INM_T_CODE=ST_CODE and INM_CODE='" + code + "' ");
if (dtfinal.Rows.Count > 0)
{
ReportDocument rptname = null;
rptname = new ReportDocument();
rptname.Load(Server.MapPath("~/Reports/rptPurchaseRejeTaxInvoice.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptPurchaseRejeTaxInvoice.rpt");
rptname.Refresh();
rptname.SetDataSource(dtfinal);
rptname.SetParameterValue("txtCompPhone", Session["CompanyPhone"].ToString());
rptname.SetParameterValue("txtCompFaxNo", Session["Companyfax"].ToString());
rptname.SetParameterValue("txtCompVatTin", Session["CompanyVatTin"].ToString());
rptname.SetParameterValue("txtCompCstTin", Session["CompanyCstTin"].ToString());
rptname.SetParameterValue("txtCompEcc", Session["CompanyEccNo"].ToString());
rptname.SetParameterValue("txtCompVatWef", Convert.ToDateTime(Session["CompanyVatWef"].ToString()).ToShortDateString());
rptname.SetParameterValue("txtCompCstWef", Convert.ToDateTime(Session["CompanyCstWef"].ToString()).ToShortDateString());
rptname.SetParameterValue("txtCompIso", Session["CompanyIso"].ToString());
rptname.SetParameterValue("txtCompRegd", Session["CompanyRegd"].ToString());
rptname.SetParameterValue("txtCompWebsite", Session["CompanyWebsite"].ToString());
rptname.SetParameterValue("txtCompEmail", Session["CompanyEmail"].ToString());
rptname.SetParameterValue("txtCompFinancialYr", Session["CompanyFinancialYr"].ToString());
//string IsoNo = DL_DBAccess.GetColumn("select ISO_NO from ISONO_MASTER,INVOICE_MASTER where INM_CODE='" + code + "' and ISO_SCREEN_NO=81 and INM_DATE<=ISO_WEF_DATE and INM_DATE>=ISO_WEF_DATE");
string CINNo = DL_DBAccess.GetColumn("select CM_CIN_NO from COMPANY_MASTER where CM_ID='" + Session["CompanyId"] + "'");
rptname.SetParameterValue("txtCINNo", CINNo);
CrystalReportViewer1.ReportSource = rptname;
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Tax Invoice", "GenerateReport", Ex.Message);
}
}
protected void ddlItemCode_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (ddlWorkOrderNo.SelectedIndex != 0 && ddlItemCode.SelectedIndex != 0)
{
if (ddlBatchType.SelectedValue == "1")
{
DatabaseAccessLayer dbaccess = new DatabaseAccessLayer();
txtWorkOrdQty.Text = dbaccess.GetColumn("select WOD_WORK_ORDER_QTY from WORK_ORDER_MASTER,WORK_ORDER_DETAIL where WO_CODE='" + ddlWorkOrderNo.SelectedValue + "' and WOD_WO_CODE=WO_CODE and WOD_I_CODE='" + ddlItemCode.SelectedValue + "' ");
}
}
else
{
txtWorkOrdQty.Text = "0.000";
}
}
catch (Exception Ex)
{
CommonClasses.SendError(" Batch Ticket", "ddlWorkOrderNo_SelectedIndexChanged", Ex.Message);
}
}
private void GenerateReport(string code, string p_type)
{
DL_DBAccess = new DatabaseAccessLayer();
//DataTable dtfinal = CommonClasses.Execute("select EM_CODE ,EM_NAME ,BM_NAME,CONVERT(VARCHAR(11),EM_JOINDATE,113) as EM_JOINDATE,CONVERT(VARCHAR(11),FS_LEAVE_DATE,113) as FS_LEAVE_DATE,CONVERT(VARCHAR(11),FS_RESIGN_DATE,113) as FS_RESIGN_DATE,DS_NAME,FS_LAST_SAL,FS_BONUS_AMT,FS_LEAVE_AMT,FS_LTA_AMT,FS_ADV_AMT,FS_LOAN_AMT,FS_NOTICE_AMT,FS_FINAL_AMT,FS_PAYABLE_LEAVES as LeaveDay,FS_NOTICE_DAYS as NoticeDay from HR_FINAL_SETTLEMENT,HR_EMPLOYEE_MASTER,HR_DESINGNATION_MASTER,CM_BRANCH_MASTER where EM_CODE=FS_EM_CODE and BM_CODE=EM_BM_CODE and EM_DM_CODE=DS_CODE and FS_CODE=" + fsCode + " and FS_DELETE_FLAG=0 and FS_CM_COMP_ID=" + Session["CompanyId"].ToString() + "");
try
{
DataTable dtfinal = new DataTable();
DataTable dtCompState = new DataTable();
DataTable dtCustState = new DataTable();
dtCompState = CommonClasses.Execute("SELECT * FROM COMPANY_MASTER WHERE CM_CODE='" + Session["CompanyCode"] + "' AND ISNULL(CM_DELETE_FLAG,0)='0' AND CM_ID= '" + Session["CompanyId"] + "'");
dtCustState = CommonClasses.Execute("SELECT P_SM_CODE,* FROM CUSTPO_MASTER INNER JOIN PARTY_MASTER ON CUSTPO_MASTER.CPOM_P_CODE=PARTY_MASTER.P_CODE WHERE CUSTPO_MASTER.CPOM_CODE='" + code + "' AND CUSTPO_MASTER.CPOM_CM_COMP_ID='" + Session["CompanyId"] + "' AND CUSTPO_MASTER.ES_DELETE=0");
string TaxType = "";
if (dtCompState.Rows[0]["CM_STATE"].ToString() == dtCustState.Rows[0]["P_SM_CODE"].ToString())
{
TaxType = "Integr";
}
else
{
TaxType = "WithoutIntegr";
}
if (p_type == "PrintWork")
{
//dtfinal = CommonClasses.Execute("select E_H_EDU,E_EDU_CESS,E_SPECIAL,E_BASIC,CPOM_CODE,CPOM_P_CODE,P_NAME,P_ADD1,CPOM_PONO,CPOM_TYPE,WO_DATE as CPOM_DATE,CPOM_CR_DAYS,CPOD_CPOM_CODE,CPOD_I_CODE,I_NAME,I_CODENO,I_SPECIFICATION,I_MATERIAL,I_SIZE,I_UOM_NAME,WOD_WORK_ORDER_QTY as CPOD_ORD_QTY,CPOD_RATE,CPOM_T_NAME,CPOM_T_PER,CPOM_EXC_PER,CPOM_EXC_EDU_PER,CPOM_EXC_HEDU_PER,CPOD_DESC,CPOM_BASIC_AMT,CPOM_DISCOUNT_PER,CPOM_DISCOUNT_AMT,CPOM_DISCOUNT_REASON,CPOM_DEVIATION_AMT,CPOM_DEVIATION_REASON,CPOM_PACKING_AMT,CPOM_EXC_AMT,CPOM_T_AMT,CPOM_ROUNDING,CPOM_GRAND_TOT,I_LENGTH,I_HEIGHT,I_WIDTH,I_ROWS,I_STORIED,ST_SALES_TAX,ST_TAX_NAME,WO_NO AS CPOM_WORK_ODR_NO,CPOD_CUST_I_CODE,CPOD_CUST_I_NAME,CM_ADDRESS1,CM_ADDRESS2, CM_FAXNO, CM_PHONENO1,CM_PHONENO2, CM_EMAILID, CM_WEBSITE,CONVERT(VARCHAR, CPOM_PO_DATE ,103) AS CPOM_PO_DATE FROM EXCISE_TARIFF_MASTER,CUSTPO_DETAIL,CUSTPO_MASTER,ITEM_MASTER,ITEM_UNIT_MASTER,PARTY_MASTER,SALES_TAX_MASTER,COMPANY_MASTER,WORK_ORDER_MASTER, WORK_ORDER_DETAIL where ITEM_MASTER.I_CODE = CUSTPO_DETAIL.CPOD_I_CODE and ITEM_MASTER.I_E_CODE = EXCISE_TARIFF_MASTER.E_CODE and CPOD_CPOM_CODE=CPOM_CODE and CPOM_P_CODE=P_CODE and CUSTPO_DETAIL.CPOD_UOM_CODE=ITEM_UNIT_MASTER.I_UOM_CODE and CUSTPO_MASTER.ES_DELETE=0 and CPOD_ST_CODE=ST_CODE and CPOM_CODE=WOD_CPOM_CODE and WO_CODE=WOD_WO_CODE and WO_CODE='" + code + "' and CPOM_CM_COMP_ID=CM_ID and CPOM_CM_COMP_ID='" + Session["CompanyId"] + "' AND WOD_I_CODE=CPOD_I_CODE and CM_CODE='" + Session["CompanyCode"] + "'");
//Copy From else
dtfinal = CommonClasses.Execute("select E_H_EDU,E_EDU_CESS,E_SPECIAL,E_BASIC,CPOM_CODE,CPOM_P_CODE,P_NAME,P_ADD1,CPOM_PONO,CPOM_TYPE,CONVERT(VARCHAR, CPOM_DATE,106) AS CPOM_DATE,CPOM_CR_DAYS,CPOD_CPOM_CODE,CPOD_I_CODE,I_NAME,I_CODENO,I_SPECIFICATION,I_MATERIAL,I_SIZE,I_UOM_NAME,CPOD_ORD_QTY,CPOD_RATE,CPOM_T_NAME,CPOM_T_PER,CPOM_EXC_PER,CPOM_EXC_EDU_PER,CPOM_EXC_HEDU_PER,CPOD_DESC,CPOM_BASIC_AMT,CPOM_DISCOUNT_PER,CPOM_DISCOUNT_AMT,CPOM_DISCOUNT_REASON,CPOM_DEVIATION_AMT,CPOM_DEVIATION_REASON,CPOM_PACKING_AMT,CPOM_EXC_AMT,CPOM_T_AMT,CPOM_ROUNDING,CPOM_GRAND_TOT,I_LENGTH,I_HEIGHT,I_WIDTH,I_ROWS,I_STORIED,ST_SALES_TAX,ST_TAX_NAME,CPOM_NO AS CPOM_WORK_ODR_NO,CPOD_CUST_I_CODE,CPOD_CUST_I_NAME,CM_ADDRESS1,CM_ADDRESS2, CM_FAXNO, CM_PHONENO1,CM_PHONENO2, CM_EMAILID, CM_WEBSITE,CONVERT(VARCHAR, CPOM_PO_DATE ,103) AS CPOM_PO_DATE FROM EXCISE_TARIFF_MASTER,CUSTPO_DETAIL,CUSTPO_MASTER,ITEM_MASTER,ITEM_UNIT_MASTER,PARTY_MASTER,SALES_TAX_MASTER,COMPANY_MASTER where ITEM_MASTER.I_CODE = CUSTPO_DETAIL.CPOD_I_CODE and ITEM_MASTER.I_E_CODE = EXCISE_TARIFF_MASTER.E_CODE and CPOD_CPOM_CODE=CPOM_CODE and CPOM_P_CODE=P_CODE and CUSTPO_DETAIL.CPOD_UOM_CODE=ITEM_UNIT_MASTER.I_UOM_CODE and CUSTPO_MASTER.ES_DELETE=0 and CPOD_ST_CODE=ST_CODE and CPOM_CODE='" + code + "' and CPOM_CM_COMP_ID=CM_ID and CPOM_CM_COMP_ID='" + Session["CompanyId"] + "' and CM_CODE='" + Session["CompanyCode"] + "'");
}
else
{
dtfinal = CommonClasses.Execute("select E_H_EDU,E_EDU_CESS,E_SPECIAL,E_BASIC,CPOM_CODE,CPOM_P_CODE,P_NAME,P_ADD1,CPOM_PONO,CPOM_TYPE,CONVERT(VARCHAR, CPOM_DATE,106) AS CPOM_DATE,CPOM_CR_DAYS,CPOD_CPOM_CODE,CPOD_I_CODE,I_NAME,I_CODENO,I_SPECIFICATION,I_MATERIAL,I_SIZE,I_UOM_NAME,CPOD_ORD_QTY,CPOD_RATE,CPOM_T_NAME,CPOM_T_PER,CPOM_EXC_PER,CPOM_EXC_EDU_PER,CPOM_EXC_HEDU_PER,CPOD_DESC,CPOM_BASIC_AMT,CPOM_DISCOUNT_PER,CPOM_DISCOUNT_AMT,CPOM_DISCOUNT_REASON,CPOM_DEVIATION_AMT,CPOM_DEVIATION_REASON,CPOM_PACKING_AMT,CPOM_EXC_AMT,CPOM_T_AMT,CPOM_ROUNDING,CPOM_GRAND_TOT,I_LENGTH,I_HEIGHT,I_WIDTH,I_ROWS,I_STORIED,0 AS ST_SALES_TAX, 'NA' AS ST_TAX_NAME,CPOM_NO AS CPOM_WORK_ODR_NO,CPOD_CUST_I_CODE,CPOD_CUST_I_NAME,CM_ADDRESS1,CM_ADDRESS2, CM_FAXNO, CM_PHONENO1,CM_PHONENO2, CM_EMAILID, CM_WEBSITE,CONVERT(VARCHAR, CPOM_PO_DATE ,103) AS CPOM_PO_DATE ,CPOM_FREIGHT_CHARGES FROM EXCISE_TARIFF_MASTER,CUSTPO_DETAIL,CUSTPO_MASTER,ITEM_MASTER,ITEM_UNIT_MASTER,PARTY_MASTER,COMPANY_MASTER where ITEM_MASTER.I_CODE = CUSTPO_DETAIL.CPOD_I_CODE and ITEM_MASTER.I_E_CODE = EXCISE_TARIFF_MASTER.E_CODE and CPOD_CPOM_CODE=CPOM_CODE and CPOM_P_CODE=P_CODE and CUSTPO_DETAIL.CPOD_UOM_CODE=ITEM_UNIT_MASTER.I_UOM_CODE and CUSTPO_MASTER.ES_DELETE=0 and CPOM_CODE='" + code + "' and CPOM_CM_COMP_ID=CM_ID and CPOM_CM_COMP_ID='" + Session["CompanyId"] + "' and CM_CODE='" + Session["CompanyCode"] + "'");
}
if (dtfinal.Rows.Count > 0)
{
if (p_type == "saleorder")
{
ReportDocument rptname = null;
rptname = new ReportDocument();
rptname.Load(Server.MapPath("~/Reports/rptCustomerPO.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptCustomerPO.rpt");
rptname.Refresh();
rptname.SetDataSource(dtfinal);
rptname.SetParameterValue("txtCompName", Session["CompanyName"].ToString());
rptname.SetParameterValue("txtCompAdd", Session["CompanyAdd1"].ToString());
rptname.SetParameterValue("txtCompPhone", Session["CompanyPhone"].ToString());
rptname.SetParameterValue("txtCompfax", Session["Companyfax"].ToString());
rptname.SetParameterValue("TaxType", TaxType.ToString());
string IsoNo = DL_DBAccess.GetColumn("select ISO_NO from ISONO_MASTER,CUSTPO_MASTER where CPOM_CODE='" + code + "' and ISO_SCREEN_NO=81 and ISO_WEF_DATE<=CPOM_DATE");
if (IsoNo == "")
{
rptname.SetParameterValue("txtIsoNo", "1");
}
else
{
rptname.SetParameterValue("txtIsoNo", IsoNo.ToString());
}
CrystalReportViewer1.ReportSource = rptname;
}
else
{
ReportDocument rptname = null;
rptname = new ReportDocument();
rptname.Load(Server.MapPath("~/Reports/rptWorkOrderPrint.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptWorkOrderPrint.rpt");
rptname.Refresh();
rptname.SetDataSource(dtfinal);
rptname.SetParameterValue("txtCompName", Session["CompanyName"].ToString());
rptname.SetParameterValue("txtCompAdd", Session["CompanyAdd1"].ToString());
rptname.SetParameterValue("txtCompPhone", Session["CompanyPhone"].ToString());
rptname.SetParameterValue("txtCompfax", Session["Companyfax"].ToString());
string IsoNo = DL_DBAccess.GetColumn("select ISO_NO from ISONO_MASTER,CUSTPO_MASTER where CPOM_CODE='" + code + "' and ISO_SCREEN_NO=86 and ISO_WEF_DATE<=CPOM_DATE order by ISO_WEF_DATE DESC");
if (IsoNo == "")
{
rptname.SetParameterValue("txtIsoNo", "1");
}
else
{
rptname.SetParameterValue("txtIsoNo", IsoNo.ToString());
}
CrystalReportViewer1.ReportSource = rptname;
}
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Customer PO Register", "GenerateReport", Ex.Message);
}
}
private void GenerateReport(string code, string Autho_Flag, string Po_Type)
{
DL_DBAccess = new DatabaseAccessLayer();
DataTable dtfinal = new DataTable();
try
{
//DataTable dtfinal = CommonClasses.Execute("select EM_CODE ,EM_NAME ,BM_NAME,CONVERT(VARCHAR(11),EM_JOINDATE,113) as EM_JOINDATE,CONVERT(VARCHAR(11),FS_LEAVE_DATE,113) as FS_LEAVE_DATE,CONVERT(VARCHAR(11),FS_RESIGN_DATE,113) as FS_RESIGN_DATE,DS_NAME,FS_LAST_SAL,FS_BONUS_AMT,FS_LEAVE_AMT,FS_LTA_AMT,FS_ADV_AMT,FS_LOAN_AMT,FS_NOTICE_AMT,FS_FINAL_AMT,FS_PAYABLE_LEAVES as LeaveDay,FS_NOTICE_DAYS as NoticeDay from HR_FINAL_SETTLEMENT,HR_EMPLOYEE_MASTER,HR_DESINGNATION_MASTER,CM_BRANCH_MASTER where EM_CODE=FS_EM_CODE and BM_CODE=EM_BM_CODE and EM_DM_CODE=DS_CODE and FS_CODE=" + fsCode + " and FS_DELETE_FLAG=0 and FS_CM_COMP_ID=" + Session["CompanyId"].ToString() + "");
//if (Po_Type == "Export PO")
//{
// dtfinal = CommonClasses.Execute("SELECT dbo.SUPP_PO_DETAILS.SPOD_DISC_AMT, dbo.SUPP_PO_MASTER.SPOM_CODE, dbo.PARTY_MASTER.P_NAME, dbo.PARTY_MASTER.P_ADD1, dbo.PARTY_MASTER.P_CONTACT, dbo.PARTY_MASTER.P_PHONE, dbo.COMPANY_MASTER.CM_PAN_NO as P_PAN, dbo.COMPANY_MASTER.CM_CST_NO as P_CST, dbo.COMPANY_MASTER.CM_VAT_TIN_NO as P_VAT, dbo.COMPANY_MASTER.CM_ECC_NO as P_ECC_NO, dbo.COMPANY_MASTER.CM_EXCISE_DIVISION as P_EXC_DIV, dbo.COMPANY_MASTER.CM_EXCISE_RANGE as P_EXC_RANGE, dbo.COMPANY_MASTER.CM_COMMISONERATE as P_EXC_COLLECTORATE, dbo.SUPP_PO_MASTER.SPOM_PO_NO, dbo.SUPP_PO_MASTER.SPOM_DATE, dbo.ITEM_MASTER.I_CODE, CASE WHEN SPOD_ITEM_NAME = '' THEN I_NAME ELSE SPOD_ITEM_NAME END AS I_NAME, dbo.ITEM_MASTER.I_MATERIAL, dbo.SUPP_PO_DETAILS.SPOD_ORDER_QTY, dbo.SUPP_PO_DETAILS.SPOD_RATE, dbo.SUPP_PO_DETAILS.SPOD_ORDER_QTY * dbo.SUPP_PO_DETAILS.SPOD_RATE AS SPOD_AMOUNT, dbo.SUPP_PO_DETAILS.SPOD_EXC_Y_N, dbo.SALES_TAX_MASTER.ST_TAX_NAME, dbo.SALES_TAX_MASTER.ST_SALES_TAX, dbo.ITEM_MASTER.I_E_CODE, dbo.EXCISE_TARIFF_MASTER.E_BASIC, dbo.EXCISE_TARIFF_MASTER.E_EDU_CESS, dbo.EXCISE_TARIFF_MASTER.E_H_EDU, dbo.SUPP_PO_MASTER.SPOM_DELIVERED_TO, dbo.SUPP_PO_MASTER.SPOM_TRANSPOTER, dbo.SUPP_PO_MASTER.SOM_FREIGHT_TERM, dbo.SUPP_PO_MASTER.SPOM_PAY_TERM1, dbo.SUPP_PO_MASTER.SPOM_DEL_SHCEDULE, dbo.SUPP_PO_MASTER.SPOM_NOTES, dbo.SUPP_PO_MASTER.SPOM_GUARNTY, dbo.SUPP_PO_MASTER.SPOM_SUP_REF_DATE, dbo.PARTY_MASTER.P_MOB, dbo.SUPP_PO_DETAILS.SPOD_SPECIFICATION, dbo.ITEM_UNIT_MASTER.I_UOM_NAME, dbo.SUPP_PO_MASTER.SPOM_CURR_CODE, dbo.CURRANCY_MASTER.CURR_SHORT_NAME AS CURR_NAME, dbo.CURRANCY_MASTER.CURR_RATE, dbo.COMPANY_MASTER.CM_BANK_NAME, dbo.COMPANY_MASTER.CM_BANK_ACC_NO, dbo.SUPP_PO_MASTER.SPOM_CIF_NO, dbo.SUPP_PO_MASTER.SPOM_PACKING AS SPOM_PAKING, dbo.COMPANY_MASTER.CM_BANK_NAME AS Expr1, dbo.COMPANY_MASTER.CM_BANK_ACC_NO AS Expr2, ISNULL(dbo.SUPP_PO_MASTER.SPOM_AM_COUNT, 0) AS SPOM_AM_COUNT, dbo.SUPP_PO_MASTER.SPOM_PACKING, dbo.SUPP_PO_MASTER.SPOM_SUP_REF, dbo.ITEM_MASTER.I_CAT_CODE, dbo.SUPP_PO_DETAILS.SPOD_ITEM_NAME, dbo.COMPANY_MASTER.CM_ADDRESS1, dbo.COMPANY_MASTER.CM_ADDRESS2, dbo.COMPANY_MASTER.CM_PHONENO1, dbo.COMPANY_MASTER.CM_PHONENO2, dbo.COMPANY_MASTER.CM_FAXNO, dbo.COMPANY_MASTER.CM_EMAILID, dbo.COMPANY_MASTER.CM_WEBSITE FROM dbo.ITEM_UNIT_MASTER INNER JOIN dbo.SUPP_PO_DETAILS ON dbo.ITEM_UNIT_MASTER.I_UOM_CODE = dbo.SUPP_PO_DETAILS.SPOD_UOM_CODE INNER JOIN dbo.SUPP_PO_MASTER ON dbo.SUPP_PO_DETAILS.SPOD_SPOM_CODE = dbo.SUPP_PO_MASTER.SPOM_CODE INNER JOIN dbo.PARTY_MASTER ON dbo.SUPP_PO_MASTER.SPOM_P_CODE = dbo.PARTY_MASTER.P_CODE INNER JOIN dbo.ITEM_MASTER ON dbo.SUPP_PO_DETAILS.SPOD_I_CODE = dbo.ITEM_MASTER.I_CODE INNER JOIN dbo.SALES_TAX_MASTER ON dbo.SUPP_PO_DETAILS.SPOD_T_CODE = dbo.SALES_TAX_MASTER.ST_CODE INNER JOIN dbo.EXCISE_TARIFF_MASTER ON dbo.ITEM_MASTER.I_E_CODE = dbo.EXCISE_TARIFF_MASTER.E_CODE INNER JOIN dbo.CURRANCY_MASTER ON dbo.SUPP_PO_MASTER.SPOM_CURR_CODE = dbo.CURRANCY_MASTER.CURR_CODE INNER JOIN dbo.COMPANY_MASTER ON dbo.SUPP_PO_MASTER.SPOM_CM_CODE = dbo.COMPANY_MASTER.CM_CODE WHERE (dbo.SUPP_PO_MASTER.ES_DELETE = 0) AND (dbo.SUPP_PO_MASTER.SPOM_CM_CODE = '" + Session["CompanyCode"] + "') AND (dbo.SUPP_PO_MASTER.SPOM_CODE = '" + code + "')");
// ReportDocument rptname = null;
// rptname = new ReportDocument();
// rptname.Load(Server.MapPath("~/Reports/rptImportSupplierPo.rpt"));
// rptname.FileName = Server.MapPath("~/Reports/rptImportSupplierPo.rpt");
// rptname.Refresh();
// rptname.SetDataSource(dtfinal);
// rptname.SetParameterValue("txtUserName", Session["Username"].ToString());
// rptname.SetParameterValue("txtCM_VAT_WEF",Convert.ToDateTime(Session["CompanyVatWef"]).ToString("dd/MM/yyyy").ToString());
// rptname.SetParameterValue("txtCM_CST_WEF", Convert.ToDateTime(Session["CompanyCstWef"]).ToString("dd/MM/yyyy").ToString());
// if (Autho_Flag == "true")
// {
// rptname.SetParameterValue("txtAuthFalg", "0");
// }
// else
// {
// rptname.SetParameterValue("txtAuthFalg", "1");
// }
// string IsoNo = DL_DBAccess.GetColumn("select ISO_NO from ISONO_MASTER,SUPP_PO_MASTER where SPOM_CODE='" + code + "' and ISO_SCREEN_NO=42 and ISO_WEF_DATE<=SPOM_DATE order by ISO_WEF_DATE DESC");
// rptname.SetParameterValue("txtIsoNo", IsoNo);
// if (IsoNo == "")
// {
// rptname.SetParameterValue("txtIsoNo", "1");
// }
// else
// {
// rptname.SetParameterValue("txtIsoNo", IsoNo.ToString());
// }
// CrystalReportViewer1.ReportSource = rptname;
//}
//else
{
//dtfinal = CommonClasses.Execute("SELECT 'PC-'+''+SUBSTRING(P_NAME,1,1)+''+ CONVERT(VARCHAR,P_PARTY_CODE) AS P_PARTY_CODE, SPOM_USER_CODE,UM_NAME,UM_USERNAME , dbo.SUPP_PO_DETAILS.SPOD_DISC_AMT, dbo.SUPP_PO_MASTER.SPOM_CODE, dbo.PARTY_MASTER.P_NAME, dbo.PARTY_MASTER.P_ADD1, dbo.PARTY_MASTER.P_CONTACT, dbo.PARTY_MASTER.P_PHONE, P_PAN, P_CST, P_VAT, P_ECC_NO, P_EXC_DIV, P_EXC_RANGE, P_EXC_COLLECTORATE, dbo.SUPP_PO_MASTER.SPOM_PO_NO, dbo.SUPP_PO_MASTER.SPOM_DATE, dbo.ITEM_MASTER.I_CODE, I_NAME, dbo.ITEM_MASTER.I_MATERIAL, dbo.SUPP_PO_DETAILS.SPOD_ORDER_QTY, dbo.SUPP_PO_DETAILS.SPOD_RATE, dbo.SUPP_PO_DETAILS.SPOD_ORDER_QTY * dbo.SUPP_PO_DETAILS.SPOD_RATE AS SPOD_AMOUNT, dbo.SUPP_PO_DETAILS.SPOD_EXC_Y_N, dbo.SALES_TAX_MASTER.ST_TAX_NAME, dbo.SALES_TAX_MASTER.ST_SALES_TAX, dbo.ITEM_MASTER.I_E_CODE, SPOD_EXC_PER AS E_BASIC, dbo.EXCISE_TARIFF_MASTER.E_EDU_CESS, dbo.EXCISE_TARIFF_MASTER.E_H_EDU, dbo.SUPP_PO_MASTER.SPOM_DELIVERED_TO, dbo.SUPP_PO_MASTER.SPOM_TRANSPOTER, dbo.SUPP_PO_MASTER.SOM_FREIGHT_TERM, dbo.SUPP_PO_MASTER.SPOM_PAY_TERM1, dbo.SUPP_PO_MASTER.SPOM_DEL_SHCEDULE, dbo.SUPP_PO_MASTER.SPOM_NOTES, dbo.SUPP_PO_MASTER.SPOM_GUARNTY, dbo.SUPP_PO_MASTER.SPOM_SUP_REF_DATE, dbo.PARTY_MASTER.P_MOB, dbo.SUPP_PO_DETAILS.SPOD_SPECIFICATION, dbo.ITEM_UNIT_MASTER.I_UOM_NAME, (CASE WHEN (LEN(I_NAME) / 30) = 0 THEN 1 ELSE (LEN(I_NAME) / 30) END) AS I_LENGTH, (CASE WHEN (LEN(I_MATERIAL) / 30) = 0 THEN 1 ELSE (LEN(I_MATERIAL) / 30) END) AS I_MATERIAL_LENGTH, (CASE WHEN (LEN(SPOD_SPECIFICATION) / 30) = 0 THEN 1 ELSE (LEN(SPOD_SPECIFICATION) / 30) END) AS SPOD_SPECIFICATION_LENGTH, ISNULL(dbo.SUPP_PO_MASTER.SPOM_AM_COUNT, 0) AS SPOM_AM_COUNT, dbo.SUPP_PO_MASTER.SPOM_PACKING AS SPOM_PAKING, dbo.SUPP_PO_MASTER.SPOM_SUP_REF, dbo.ITEM_MASTER.I_CAT_CODE, dbo.SUPP_PO_DETAILS.SPOD_ITEM_NAME, dbo.COMPANY_MASTER.CM_ADDRESS1, dbo.COMPANY_MASTER.CM_ADDRESS2, dbo.COMPANY_MASTER.CM_PHONENO1, dbo.COMPANY_MASTER.CM_FAXNO, dbo.COMPANY_MASTER.CM_EMAILID, dbo.COMPANY_MASTER.CM_PHONENO2, dbo.COMPANY_MASTER.CM_WEBSITE,dbo.COMPANY_MASTER.CM_BANK_NAME,dbo.COMPANY_MASTER.CM_BANK_ACC_NO,I_CODENO,E_COMMODITY,E_TARIFF_NO,P_EMAIL,SPOM_CIF_NO,SPOM_AM_DATE,PROCM_NAME AS SPOM_PROJECT,SPOM_VALID_DATE ,SPOD_DISC_PER,SPOM_PONO,SPOM_PROJ_NAME,PO_T_SHORT_NAME,PO_T_FIRST_LETTER,PO_T_DESC,SPOM_AM_DATE FROM dbo.ITEM_UNIT_MASTER INNER JOIN dbo.SUPP_PO_DETAILS ON dbo.ITEM_UNIT_MASTER.I_UOM_CODE = dbo.SUPP_PO_DETAILS.SPOD_UOM_CODE INNER JOIN dbo.SUPP_PO_MASTER ON dbo.SUPP_PO_DETAILS.SPOD_SPOM_CODE = dbo.SUPP_PO_MASTER.SPOM_CODE INNER JOIN dbo.PARTY_MASTER ON dbo.SUPP_PO_MASTER.SPOM_P_CODE = dbo.PARTY_MASTER.P_CODE INNER JOIN dbo.ITEM_MASTER ON dbo.SUPP_PO_DETAILS.SPOD_I_CODE = dbo.ITEM_MASTER.I_CODE INNER JOIN dbo.SALES_TAX_MASTER ON dbo.SUPP_PO_DETAILS.SPOD_T_CODE = dbo.SALES_TAX_MASTER.ST_CODE INNER JOIN dbo.EXCISE_TARIFF_MASTER ON dbo.ITEM_MASTER.I_E_CODE = dbo.EXCISE_TARIFF_MASTER.E_CODE INNER JOIN dbo.COMPANY_MASTER ON dbo.SUPP_PO_MASTER.SPOM_CM_CODE = dbo.COMPANY_MASTER.CM_CODE INNER JOIN USER_MASTER ON USER_MASTER.UM_CODE=SPOM_USER_CODE INNER JOIN PO_TYPE_MASTER ON SPOM_TYPE=PO_T_CODE INNER JOIN PROJECT_CODE_MASTER ON SPOM_PROJECT=PROJECT_CODE_MASTER.PROCM_CODE WHERE (dbo.SUPP_PO_MASTER.ES_DELETE = 0) AND (dbo.SUPP_PO_MASTER.SPOM_CM_CODE = '" + Session["CompanyCode"] + "') AND (dbo.SUPP_PO_MASTER.SPOM_CODE = '" + code + "')");
dtfinal = CommonClasses.Execute("SELECT 'PC-' + '' + SUBSTRING(PARTY_MASTER.P_NAME, 1, 1) + '' + CONVERT(VARCHAR, PARTY_MASTER.P_PARTY_CODE) AS P_PARTY_CODE, SERVICE_PO_MASTER.SRPOM_USER_CODE, USER_MASTER.UM_NAME, USER_MASTER.UM_USERNAME, SERVICE_PO_DETAILS.SRPOD_DISC_AMT, SERVICE_PO_MASTER.SRPOM_CODE, PARTY_MASTER.P_NAME, PARTY_MASTER.P_ADD1, PARTY_MASTER.P_CONTACT, PARTY_MASTER.P_PHONE, PARTY_MASTER.P_PAN, PARTY_MASTER.P_CST, PARTY_MASTER.P_VAT, PARTY_MASTER.P_ECC_NO, PARTY_MASTER.P_EXC_DIV, PARTY_MASTER.P_EXC_RANGE, PARTY_MASTER.P_EXC_COLLECTORATE, SERVICE_PO_MASTER.SRPOM_PO_NO, SERVICE_PO_MASTER.SRPOM_DATE, SERVICE_TYPE_MASTER.S_CODE, SERVICE_TYPE_MASTER.S_NAME, '' AS S_MATERIAL, SERVICE_PO_DETAILS.SRPOD_ORDER_QTY, SERVICE_PO_DETAILS.SRPOD_RATE, SERVICE_PO_DETAILS.SRPOD_ORDER_QTY * SERVICE_PO_DETAILS.SRPOD_RATE AS SRPOD_AMOUNT, SERVICE_PO_DETAILS.SRPOD_EXC_Y_N, SERVICE_TYPE_MASTER.S_E_CODE, CASE when P_SM_CODE=CM_STATE then SRPOD_EXC_PER else 0 END AS E_BASIC, CASE when P_SM_CODE=CM_STATE then E_EDU_CESS else 0 END as E_EDU_CESS, CASE when P_SM_CODE=CM_STATE then 0 else E_H_EDU END as E_H_EDU, SERVICE_PO_MASTER.SRPOM_DELIVERED_TO, SERVICE_PO_MASTER.SRPOM_TRANSPOTER, SERVICE_PO_MASTER.SOM_FREIGHT_TERM, SERVICE_PO_MASTER.SRPOM_PAY_TERM1, SERVICE_PO_MASTER.SRPOM_DEL_SHCEDULE, SERVICE_PO_MASTER.SRPOM_NOTES, SERVICE_PO_MASTER.SRPOM_GUARNTY, SERVICE_PO_MASTER.SRPOM_SUP_REF_DATE, PARTY_MASTER.P_MOB, SERVICE_PO_DETAILS.SRPOD_SPECIFICATION, (CASE WHEN (LEN(S_NAME) / 30) = 0 THEN 1 ELSE (LEN(S_NAME) / 30) END) AS S_LENGTH, '' AS S_MATERIAL_LENGTH, (CASE WHEN (LEN(SRPOD_SPECIFICATION) / 30) = 0 THEN 1 ELSE (LEN(SRPOD_SPECIFICATION) / 30) END) AS SRPOD_SPECIFICATION_LENGTH, ISNULL(SERVICE_PO_MASTER.SRPOM_AM_COUNT, 0) AS SRPOM_AM_COUNT, SERVICE_PO_MASTER.SRPOM_PACKING AS SRPOM_PAKING, SERVICE_PO_MASTER.SRPOM_SUP_REF, '' AS S_CAT_CODE, SERVICE_PO_DETAILS.SRPOD_ITEM_NAME, COMPANY_MASTER.CM_ADDRESS1, COMPANY_MASTER.CM_ADDRESS2, COMPANY_MASTER.CM_PHONENO1, COMPANY_MASTER.CM_FAXNO, COMPANY_MASTER.CM_EMAILID, COMPANY_MASTER.CM_PHONENO2, COMPANY_MASTER.CM_WEBSITE, COMPANY_MASTER.CM_BANK_NAME, COMPANY_MASTER.CM_BANK_ACC_NO, SERVICE_TYPE_MASTER.S_CODENO, EXCISE_TARIFF_MASTER.E_COMMODITY, EXCISE_TARIFF_MASTER.E_TARIFF_NO, PARTY_MASTER.P_EMAIL, SERVICE_PO_MASTER.SRPOM_CIF_NO, SERVICE_PO_MASTER.SRPOM_AM_DATE, PROJECT_CODE_MASTER.PROCM_NAME AS SRPOM_PROJECT, SERVICE_PO_MASTER.SRPOM_VALID_DATE, SERVICE_PO_DETAILS.SRPOD_DISC_PER, SERVICE_PO_MASTER.SRPOM_PONO, SERVICE_PO_MASTER.SRPOM_PROJ_NAME, PO_TYPE_MASTER.PO_T_SHORT_NAME, PO_TYPE_MASTER.PO_T_FIRST_LETTER, PO_TYPE_MASTER.PO_T_DESC,SRPOM_AM_DATE ,SRPOD_CENTRAL_TAX_AMT AS SPOD_EXC_AMT,SRPOD_STATE_TAX_AMT AS SPOD_EXC_E_AMT, SRPOD_INTEGRATED_TAX_AMT AS SPOD_EXC_HE_AMT,E_TARIFF_NO as SPOD_E_TARIFF_NO ,CASE WHEN P_LBT_IND=1 then P_LBT_NO ELSE 'NA' END AS P_GST_NO FROM SERVICE_PO_DETAILS INNER JOIN SERVICE_PO_MASTER ON SERVICE_PO_DETAILS.SRPOD_SPOM_CODE = SERVICE_PO_MASTER.SRPOM_CODE INNER JOIN PARTY_MASTER ON SERVICE_PO_MASTER.SRPOM_P_CODE = PARTY_MASTER.P_CODE INNER JOIN SERVICE_TYPE_MASTER ON SERVICE_PO_DETAILS.SRPOD_I_CODE = SERVICE_TYPE_MASTER.S_CODE INNER JOIN EXCISE_TARIFF_MASTER ON SERVICE_TYPE_MASTER.S_E_CODE = EXCISE_TARIFF_MASTER.E_CODE INNER JOIN COMPANY_MASTER ON SERVICE_PO_MASTER.SRPOM_CM_CODE = COMPANY_MASTER.CM_CODE INNER JOIN USER_MASTER ON USER_MASTER.UM_CODE = SERVICE_PO_MASTER.SRPOM_USER_CODE INNER JOIN PO_TYPE_MASTER ON SERVICE_PO_MASTER.SRPOM_TYPE = PO_TYPE_MASTER.PO_T_CODE INNER JOIN PROJECT_CODE_MASTER ON SERVICE_PO_MASTER.SRPOM_PROJECT = PROJECT_CODE_MASTER.PROCM_CODE WHERE (SERVICE_PO_MASTER.ES_DELETE = 0) AND (SERVICE_PO_MASTER.SRPOM_CM_CODE = '" + Session["CompanyCode"] + "') AND (SERVICE_PO_MASTER.SRPOM_CODE = '" + code + "')");
if (dtfinal.Rows.Count > 0)
{
ReportDocument rptname = null;
rptname = new ReportDocument();
rptname.Load(Server.MapPath("~/Reports/rptServicePoPrint1.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptServicePoPrint1.rpt");
rptname.Refresh();
rptname.SetDataSource(dtfinal);
rptname.SetParameterValue("txtUserName", dtfinal.Rows[0]["UM_NAME"].ToString());
DataTable dtComp = new DataTable();
dtComp = CommonClasses.Execute(" SELECT CM_NAME, CM_ID, CM_ADDRESS1, CM_PHONENO1, CM_FAXNO, CM_EMAILID, CM_WEBSITE, CM_VAT_TIN_NO, CM_CST_NO, CM_PAN_NO, CM_ECC_NO,CM_VAT_WEF, CM_CST_WEF,CM_EXCISE_RANGE ,CM_EXCISE_DIVISION,CM_COMMISONERATE,CM_GST_NO FROM COMPANY_MASTER where CM_ID='" + Session["CompanyId"].ToString() + "'");
rptname.SetParameterValue("txtComp", dtComp.Rows[0]["CM_NAME"].ToString().ToUpper());
rptname.SetParameterValue("txtAdd", dtComp.Rows[0]["CM_ADDRESS1"].ToString().ToUpper());
rptname.SetParameterValue("txtPhone", dtComp.Rows[0]["CM_PHONENO1"].ToString());
rptname.SetParameterValue("txtFax", dtComp.Rows[0]["CM_FAXNO"].ToString());
rptname.SetParameterValue("txtEmail", dtComp.Rows[0]["CM_EMAILID"].ToString());
rptname.SetParameterValue("txtVAT", dtComp.Rows[0]["CM_VAT_TIN_NO"].ToString());
rptname.SetParameterValue("txtCST", dtComp.Rows[0]["CM_CST_NO"].ToString());
rptname.SetParameterValue("txtECC", dtComp.Rows[0]["CM_ECC_NO"].ToString());
rptname.SetParameterValue("txtRange", dtComp.Rows[0]["CM_EXCISE_RANGE"].ToString());
rptname.SetParameterValue("txtDivision", dtComp.Rows[0]["CM_EXCISE_DIVISION"].ToString());
rptname.SetParameterValue("txtComm", dtComp.Rows[0]["CM_COMMISONERATE"].ToString());
rptname.SetParameterValue("txtP_CODE", dtfinal.Rows[0]["P_PARTY_CODE"].ToString());
rptname.SetParameterValue("txtGST", dtComp.Rows[0]["CM_GST_NO"].ToString());
rptname.SetParameterValue("txtPAN_NO", dtComp.Rows[0]["CM_PAN_NO"].ToString());
rptname.SetParameterValue("txtCM_VAT_WEF", Convert.ToDateTime(Session["CompanyVatWef"]).ToString("dd/MM/yyyy").ToString());
rptname.SetParameterValue("txtCM_CST_WEF", Convert.ToDateTime(Session["CompanyCstWef"]).ToString("dd/MM/yyyy").ToString());
if (Autho_Flag == "true")
{
rptname.SetParameterValue("txtAuthFalg", "0");
}
else
{
rptname.SetParameterValue("txtAuthFalg", "1");
}
string IsoNo = DL_DBAccess.GetColumn("select ISO_NO from ISONO_MASTER,SUPP_PO_MASTER where SPOM_CODE='" + code + "' and ISO_SCREEN_NO=42 and ISO_WEF_DATE<=SPOM_DATE order by ISO_WEF_DATE DESC");
rptname.SetParameterValue("txtIsoNo", IsoNo);
if (IsoNo == "")
{
rptname.SetParameterValue("txtIsoNo", "1");
}
else
{
rptname.SetParameterValue("txtIsoNo", IsoNo.ToString());
}
CrystalReportViewer1.ReportSource = rptname;
}
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Service PO Print", "GenerateReport", Ex.Message);
}
}
private void GenerateReport(string code, string printtype)
{
DL_DBAccess = new DatabaseAccessLayer();
try
{
if (printtype == "ExpInv")
{
#region Export Invoice Print
DataTable dtfinal = CommonClasses.Execute("SELECT DISTINCT(I_CODE),ITEM_UNIT_MASTER.I_UOM_NAME as I_UOM_NAME,P_CODE,E_TARIFF_NO,P_NAME,P_ADD1,P_VEND_CODE,P_CST,P_VAT,P_ECC_NO,INM_NO,INM_DATE,INM_TRANSPORT,INM_VEH_NO,INM_LR_NO,INM_LR_DATE,I_NAME,CPOD_CUST_I_CODE,CPOD_CUST_I_NAME,CPOM_PONO,CPOM_DATE,IND_SUBHEADING,IND_BACHNO,IND_NO_PACK,IND_PAK_QTY,IND_INQTY,IND_RATE,E_BASIC,E_SPECIAL,E_EDU_CESS,E_H_EDU,ST_TAX_NAME,ST_SALES_TAX,INM_BOND_NO,INM_BOND_DATE,INM_AREA_FORM_NO,INM_FORM_DATE,P_PHONE,INM_PRE_CARRIAGE,INM_PORT_OF_DISCH,INM_PORT_OF_LOAD,INM_PLACE_OF_DEL,IND_CONTAINER_NO,IND_NET_WEIGHT,IND_GROSS_WEIGHT,IND_NO_OF_BARRELS,I_CODENO,INM_FREIGHT,INM_INSURANCE,INM_FINAL_DEST,INM_TOD,INM_TOP,INM_VOY_NO,INM_PLACE_REC,INM_M_NO,INM_NOS_PACK,INM_UN_NO,INM_HAZ,INM_HS_CODENO,INM_CONTA_NO,INM_SEAL_NO,INM_OTS_NO,INM_CURR_RATE,Counrty2.COUNTRY_NAME as INM_CONTRY_ORIGIN,Counrty1.COUNTRY_NAME as INM_COUNTRY_DEST,INM_LC_NO,INM_LC_DATE,INM_UN_PAK_GRP,INM_UN_PAK_CODE,INM_UT1_FILE_NO,INM_FILE_NO,INM_PER_E_NO FROM EXCISE_TARIFF_MASTER,CUSTPO_DETAIL,CUSTPO_MASTER,INVOICE_MASTER,INVOICE_DETAIL,ITEM_MASTER,SALES_TAX_MASTER,PARTY_MASTER,COUNTRY_MASTER Counrty1,COUNTRY_MASTER Counrty2,ITEM_UNIT_MASTER WHERE ITEM_UNIT_MASTER.I_UOM_CODE=IND_UOM_CODE and INM_CODE = IND_INM_CODE and CPOD_CPOM_CODE = CPOM_CODE and INM_P_CODE = P_CODE AND INM_P_CODE = CPOM_P_CODE and CPOM_CODE = IND_CPOM_CODE AND IND_I_CODE=CPOD_I_CODE and IND_I_CODE = I_CODE and I_E_CODE=E_CODE and IND_I_CODE=CPOD_I_CODE AND CPOD_ST_CODE=ST_CODE and INM_COUNTRY_DEST= Counrty1.COUNTRY_CODE and INM_CONTRY_ORIGIN=Counrty2.COUNTRY_CODE and INM_CODE='" + code + "' ");
if (dtfinal.Rows.Count > 0)
{
DataTable dtLinceDet = CommonClasses.Execute("select CM_EXP_LICEN_NO,CM_EXP_PERMISSOIN_NO from COMPANY_MASTER where CM_ID='" + Session["CompanyID"] + "'");
ReportDocument rptname = null;
rptname = new ReportDocument();
//string path = Server.MapPath("~/Reports/rptExportInvoice.rpt");
rptname.Load(Server.MapPath("~/Reports/rptExportInvoice.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptExportInvoice.rpt");
rptname.Refresh();
rptname.SetDataSource(dtfinal);
rptname.SetParameterValue("txtCompAdd", Session["CompanyAdd1"].ToString());
rptname.SetParameterValue("txtCompName", Session["CompanyName"].ToString());
rptname.SetParameterValue("txtCompPhone", Session["CompanyPhone"].ToString());
rptname.SetParameterValue("txtCompFax", Session["Companyfax"].ToString());
rptname.SetParameterValue("txtCompFinancialYr", Session["CompanyFinancialYr"].ToString());
rptname.SetParameterValue("txtCompEXPLicen", dtLinceDet.Rows[0]["CM_EXP_LICEN_NO"]);
rptname.SetParameterValue("txtCompEXPPermission", dtLinceDet.Rows[0]["CM_EXP_PERMISSOIN_NO"]);
string COUNTRY_NAME = DL_DBAccess.GetColumn("select COUNTRY_NAME from INVOICE_MASTER,COUNTRY_MASTER where INM_COUNTRY_DEST=COUNTRY_CODE and INM_CODE='" + code + "'");
int InvType = 0;
if (COUNTRY_NAME == "RUSSIA")
{
InvType = 1;
}
else
{
InvType = 0;
}
rptname.SetParameterValue("txtInvType", InvType);
CrystalReportViewer1.ReportSource = rptname;
}
#endregion
}
else if (printtype == "PackList")
{
#region Export Packing List
DataTable dtfinal = CommonClasses.Execute("SELECT DISTINCT(I_CODE),ITEM_UNIT_MASTER.I_UOM_NAME as I_UOM_NAME,P_CODE,E_TARIFF_NO,P_NAME,P_ADD1,P_VEND_CODE,P_CST,P_VAT,P_ECC_NO,INM_NO,INM_DATE,INM_TRANSPORT,INM_VEH_NO,INM_LR_NO,INM_LR_DATE,I_NAME,CPOD_CUST_I_CODE,CPOD_CUST_I_NAME,CPOM_PONO,CPOM_DATE,IND_SUBHEADING,IND_BACHNO,IND_NO_PACK,IND_PAK_QTY,IND_INQTY,IND_RATE,E_BASIC,E_SPECIAL,E_EDU_CESS,E_H_EDU,ST_TAX_NAME,ST_SALES_TAX,INM_BOND_NO,INM_BOND_DATE,INM_AREA_FORM_NO,INM_FORM_DATE,P_PHONE,INM_PRE_CARRIAGE,INM_PORT_OF_DISCH,INM_PORT_OF_LOAD,INM_PLACE_OF_DEL,IND_CONTAINER_NO,IND_NET_WEIGHT,IND_GROSS_WEIGHT,IND_NO_OF_BARRELS,I_CODENO,INM_FREIGHT,INM_INSURANCE,INM_FINAL_DEST,INM_TOD,INM_TOP,INM_VOY_NO,INM_PLACE_REC,INM_M_NO,INM_NOS_PACK,INM_UN_NO,INM_HAZ,INM_HS_CODENO,INM_CONTA_NO,INM_SEAL_NO,INM_OTS_NO,INM_CURR_RATE,Counrty2.COUNTRY_NAME as INM_CONTRY_ORIGIN,Counrty1.COUNTRY_NAME as INM_COUNTRY_DEST,INM_LC_NO,INM_LC_DATE,INM_UN_PAK_GRP,INM_UN_PAK_CODE,INM_UT1_FILE_NO,INM_FILE_NO,INM_PER_E_NO FROM EXCISE_TARIFF_MASTER,CUSTPO_DETAIL,CUSTPO_MASTER,INVOICE_MASTER,INVOICE_DETAIL,ITEM_MASTER,SALES_TAX_MASTER,PARTY_MASTER,COUNTRY_MASTER Counrty1,COUNTRY_MASTER Counrty2,ITEM_UNIT_MASTER WHERE ITEM_UNIT_MASTER.I_UOM_CODE=IND_UOM_CODE and INM_CODE = IND_INM_CODE and CPOD_CPOM_CODE = CPOM_CODE and INM_P_CODE = P_CODE AND INM_P_CODE = CPOM_P_CODE and CPOM_CODE = IND_CPOM_CODE AND IND_I_CODE=CPOD_I_CODE and IND_I_CODE = I_CODE and I_E_CODE=E_CODE and IND_I_CODE=CPOD_I_CODE AND CPOD_ST_CODE=ST_CODE and INM_COUNTRY_DEST= Counrty1.COUNTRY_CODE and INM_CONTRY_ORIGIN=Counrty2.COUNTRY_CODE and INM_CODE='" + code + "' group by I_CODE,I_UOM_NAME,INM_NO,P_CODE,P_NAME,P_ADD1,P_VEND_CODE,P_CST,P_VAT,P_ECC_NO ,INM_DATE,INM_TRANSPORT,INM_LR_NO,INM_LR_DATE,I_NAME,CPOD_CUST_I_CODE,CPOD_CUST_I_NAME ,CPOM_PONO,CPOM_DATE,IND_SUBHEADING,IND_BACHNO,IND_NO_PACK,IND_PAK_QTY,IND_INQTY,IND_RATE ,E_BASIC,E_SPECIAL,E_EDU_CESS,E_H_EDU,INM_VEH_NO,ST_TAX_NAME,ST_SALES_TAX ,E_TARIFF_NO,INM_BOND_NO,INM_BOND_DATE,INM_AREA_FORM_NO,INM_FORM_DATE,P_PHONE,INM_PRE_CARRIAGE,INM_PORT_OF_DISCH,INM_PORT_OF_LOAD,INM_PLACE_OF_DEL,IND_CONTAINER_NO,IND_NET_WEIGHT,IND_GROSS_WEIGHT,IND_NO_OF_BARRELS,I_CODENO,INM_FREIGHT,INM_INSURANCE,INM_FINAL_DEST,INM_TOD,INM_TOP,INM_VOY_NO,INM_PLACE_REC,INM_M_NO,INM_NOS_PACK,INM_UN_NO,INM_HAZ,INM_HS_CODENO,INM_CONTA_NO,INM_SEAL_NO,INM_OTS_NO,INM_CURR_RATE,Counrty2.COUNTRY_NAME,Counrty1.COUNTRY_NAME,INM_LC_NO,INM_LC_DATE,INM_UN_PAK_GRP,INM_UN_PAK_CODE,INM_UT1_FILE_NO,INM_FILE_NO,INM_PER_E_NO");
if (dtfinal.Rows.Count > 0)
{
DataTable dtLinceDet = CommonClasses.Execute("select CM_EXP_LICEN_NO,CM_EXP_PERMISSOIN_NO from COMPANY_MASTER where CM_ID='" + Session["CompanyID"] + "'");
ReportDocument rptname = null;
rptname = new ReportDocument();
//string path = Server.MapPath("~/Reports/rptExportInvoice.rpt");
rptname.Load(Server.MapPath("~/Reports/rptExportInvoicePackingList.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptExportInvoicePackingList.rpt");
rptname.Refresh();
rptname.SetDataSource(dtfinal);
rptname.SetParameterValue("txtCompAdd", Session["CompanyAdd1"].ToString());
rptname.SetParameterValue("txtCompName", Session["CompanyName"].ToString());
rptname.SetParameterValue("txtCompPhone", Session["CompanyPhone"].ToString());
rptname.SetParameterValue("txtCompFax", Session["Companyfax"].ToString());
rptname.SetParameterValue("txtCompFinancialYr", Session["CompanyFinancialYr"].ToString());
rptname.SetParameterValue("txtCompEXPLicen", dtLinceDet.Rows[0]["CM_EXP_LICEN_NO"]);
rptname.SetParameterValue("txtCompEXPPermission", dtLinceDet.Rows[0]["CM_EXP_PERMISSOIN_NO"]);
string COUNTRY_NAME = DL_DBAccess.GetColumn("select COUNTRY_NAME from INVOICE_MASTER,COUNTRY_MASTER where INM_COUNTRY_DEST=COUNTRY_CODE and INM_CODE='" + code + "'");
int InvType = 0;
if (COUNTRY_NAME == "RUSSIA")
{
InvType = 1;
}
else
{
InvType = 0;
}
rptname.SetParameterValue("txtInvType", InvType);
CrystalReportViewer1.ReportSource = rptname;
}
#endregion
}
else if (printtype == "ExpInvDom")
{
#region Export Invoice Domestic Print
DataTable dtfinal1 = CommonClasses.Execute("SELECT DISTINCT(I_CODE),INM_CODE,P_CODE,E_TARIFF_NO,P_NAME,P_ADD1,P_VEND_CODE,P_CST,P_VAT,P_ECC_NO,INM_NO,INM_DATE,INM_TRANSPORT_BY as INM_TRANSPORT,INM_VEH_NO,INM_LR_NO,INM_LR_DATE,I_NAME,CPOD_CUST_I_CODE,CPOD_CUST_I_NAME,CPOM_PONO,CPOM_DATE,IND_SUBHEADING,IND_BACHNO,INM_BOND_NO,INM_BOND_DATE,INM_AREA_FORM_NO,INM_FORM_DATE,P_PHONE,cast(isnull(IND_NO_PACK,0) as numeric(10,0)) as IND_PAK_QTY,cast(isnull(IND_INQTY,0) as numeric(10,3)) as IND_INQTY,cast(isnull(IND_RATE,0) as numeric(10,2)) as IND_RATE,cast(isnull(IND_AMT,0) as numeric(10,2)) as INM_AMT,cast(isnull(INM_NET_AMT,0) as numeric(10,2)) as INM_NET_AMT,cast(isnull(INM_DISC,0) as numeric(10,2)) as INM_DISC,cast(isnull(INM_DISC_AMT,0) as numeric(10,2)) as INM_DISC_AMT,cast(isnull(INM_PACK_AMT,0) as numeric(10,2)) as INM_PACK_AMT,cast(isnull(INM_ACCESSIBLE_AMT,0) as numeric(10,2)) as INM_ACCESSIBLE_AMT,cast(isnull(INM_BEXCISE,0) as numeric(10,2)) as INM_BEXCISE,cast(isnull(INM_BE_AMT,0) as numeric(10,2)) as INM_BE_AMT,cast(isnull(INM_EDUC_CESS,0) as numeric(10,2)) as INM_EDUC_CESS,cast(isnull(INM_EDUC_AMT,0) as numeric(10,2)) as INM_EDUC_AMT,cast(isnull(INM_H_EDUC_CESS,0) as numeric(10,2)) as INM_H_EDUC_CESS,cast(isnull(INM_H_EDUC_AMT,0) as numeric(10,2)) as INM_H_EDUC_AMT,cast(isnull(INM_TAXABLE_AMT,0) as numeric(10,2)) as INM_TAXABLE_AMT,cast(isnull(INM_S_TAX,0) as numeric(10,2)) as INM_S_TAX,cast(isnull(INM_S_TAX_AMT,0) as numeric(10,2)) as INM_S_TAX_AMT,cast(isnull(INM_OTHER_AMT,0) as numeric(10,2)) as INM_OTHER_AMT,cast(isnull(INM_FREIGHT,0) as numeric(10,2)) as INM_FREIGHT,cast(isnull(INM_INSURANCE,0) as numeric(10,2)) as INM_INSURANCE,cast(isnull(INM_TRANS_AMT,0) as numeric(10,2)) as INM_TRANS_AMT,cast(isnull(INM_OCTRI_AMT,0) as numeric(10,2)) as INM_OCTRI_AMT,cast(isnull(INM_ROUNDING_AMT,0) as numeric(10,2)) as INM_ROUNDING_AMT,cast(isnull(INM_G_AMT,0) as numeric(10,2)) as INM_G_AMT,cast(isnull(INM_ADV_DUTY,0) as numeric(20,2)) as INM_ADV_DUTY,cast(isnull(INM_TAX_TCS_AMT,0) as numeric(20,2)) as INM_TAX_TCS_AMT,ST_TAX_NAME ,INM_ISSUE_DATE,INM_REMOVAL_DATE,INM_ISSU_TIME,INM_REMOVEL_TIME,P_ECC_NO,INM_LC_NO,INM_LC_DATE,INM_UN_PAK_GRP,INM_UN_PAK_CODE,INM_UT1_FILE_NO,INM_FILE_NO,INM_PER_E_NO,IND_PACK_DESC FROM EXCISE_TARIFF_MASTER,CUSTPO_DETAIL,CUSTPO_MASTER,INVOICE_MASTER,INVOICE_DETAIL,ITEM_MASTER,SALES_TAX_MASTER,PARTY_MASTER WHERE INM_CODE = IND_INM_CODE and CPOD_CPOM_CODE = CPOM_CODE and INM_P_CODE = P_CODE AND INM_P_CODE = CPOM_P_CODE and CPOM_CODE = IND_CPOM_CODE AND IND_I_CODE=CPOD_I_CODE and IND_I_CODE = I_CODE and I_E_CODE=E_CODE and IND_I_CODE=CPOD_I_CODE AND CPOD_ST_CODE=ST_CODE and INM_CODE='" + code + "'");
if (dtfinal1.Rows.Count > 0)
{
ReportDocument rptname = null;
rptname = new ReportDocument();
//string path = Server.MapPath("~/Reports/rptExportInvoice.rpt");
rptname.Load(Server.MapPath("~/Reports/rptExpDomInvoice.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptExpDomInvoice.rpt");
rptname.Refresh();
rptname.SetDataSource(dtfinal1);
rptname.SetParameterValue("txtCompPhone", Session["CompanyPhone"].ToString());
rptname.SetParameterValue("txtCompFaxNo", Session["Companyfax"].ToString());
rptname.SetParameterValue("txtCompVatTin", Session["CompanyVatTin"].ToString());
rptname.SetParameterValue("txtCompCstTin", Session["CompanyCstTin"].ToString());
rptname.SetParameterValue("txtCompEcc", Session["CompanyEccNo"].ToString());
rptname.SetParameterValue("txtCompVatWef", Convert.ToDateTime(Session["CompanyVatWef"].ToString()).ToShortDateString());
rptname.SetParameterValue("txtCompCstWef", Convert.ToDateTime(Session["CompanyCstWef"].ToString()).ToShortDateString());
rptname.SetParameterValue("txtCompIso", Session["CompanyIso"].ToString());
rptname.SetParameterValue("txtCompRegd", Session["CompanyRegd"].ToString());
rptname.SetParameterValue("txtCompWebsite", Session["CompanyWebsite"].ToString());
rptname.SetParameterValue("txtCompEmail", Session["CompanyEmail"].ToString());
rptname.SetParameterValue("txtCompFinancialYr", Session["CompanyFinancialYr"].ToString());
string CINNo = DL_DBAccess.GetColumn("select CM_CIN_NO from COMPANY_MASTER where CM_ID='" + Session["CompanyId"] + "'");
rptname.SetParameterValue("txtCINNo", CINNo);
string COUNTRY_NAME = DL_DBAccess.GetColumn("select COUNTRY_NAME from INVOICE_MASTER,COUNTRY_MASTER where INM_COUNTRY_DEST=COUNTRY_CODE and INM_CODE='" + code + "'");
int InvType = 0;
if (COUNTRY_NAME == "RUSSIA")
{
InvType = 1;
}
else
{
InvType = 0;
}
rptname.SetParameterValue("txtInvType", InvType);
CrystalReportViewer1.ReportSource = rptname;
}
#endregion
}
else if (printtype == "EximinationAdditionalReport")
{
#region Eximination Additional Report
DataTable dtfinal1 = CommonClasses.Execute("SELECT INM_CARRIER_NAME, INM_CONTA_NO, CM_ADDRESS1,CM_ADDRESS2, CM_FAXNO, CM_PHONENO1,CM_PHONENO2, CM_EMAILID, CM_WEBSITE FROM INVOICE_MASTER,COMPANY_MASTER where INVOICE_MASTER.INM_CM_CODE = COMPANY_MASTER.CM_CODE and INM_CODE='" + code + "'");
if (dtfinal1.Rows.Count > 0)
{
ReportDocument rptname = null;
rptname = new ReportDocument();
//string path = Server.MapPath("~/Reports/rptExportInvoice.rpt");
rptname.Load(Server.MapPath("~/Reports/rptEximinationAdditionalReport.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptEximinationAdditionalReport.rpt");
rptname.Refresh();
rptname.SetDataSource(dtfinal1);
//rptname.SetParameterValue("txtCompPhone", Session["CompanyPhone"].ToString());
//rptname.SetParameterValue("txtCompFaxNo", Session["Companyfax"].ToString());
//rptname.SetParameterValue("txtCompVatTin", Session["CompanyVatTin"].ToString());
//rptname.SetParameterValue("txtCompCstTin", Session["CompanyCstTin"].ToString());
//rptname.SetParameterValue("txtCompEcc", Session["CompanyEccNo"].ToString());
//rptname.SetParameterValue("txtCompVatWef", Convert.ToDateTime(Session["CompanyVatWef"].ToString()).ToShortDateString());
//rptname.SetParameterValue("txtCompCstWef", Convert.ToDateTime(Session["CompanyCstWef"].ToString()).ToShortDateString());
rptname.SetParameterValue("txtCompIso", "(" + Session["CompanyIso"].ToString() + ")");
//rptname.SetParameterValue("txtCompRegd", Session["CompanyRegd"].ToString());
//rptname.SetParameterValue("txtCompWebsite", Session["CompanyWebsite"].ToString());
//rptname.SetParameterValue("txtCompEmail", Session["CompanyEmail"].ToString());
//rptname.SetParameterValue("txtCompFinancialYr", Session["CompanyFinancialYr"].ToString());
CrystalReportViewer1.ReportSource = rptname;
}
#endregion
}
else if (printtype == "DangerousGoodsDeclaration")
{
#region Export Invoice Domestic Print
DataTable dtfinal1 = CommonClasses.Execute("SELECT INM_SHIPMENT,P_MOB, P_CONTACT, INM_EXA_BOXES, P_NAME, P_CODE, INM_CODE, INM_NO, P_ADD1, P_PHONE, INM_DATE, INM_PORT_OF_DISCH, INM_PORT_OF_LOAD, INM_PLACE_OF_DEL, sum(IND_GROSS_WEIGHT) as IND_GROSS_WEIGHT, sum(IND_NET_WEIGHT) as IND_NET_WEIGHT, sum(IND_NO_OF_BARRELS) as IND_NO_OF_BARRELS, INM_FINAL_DEST, INM_UN_NO, INM_VOY_NO, INM_NOS_PACK, INM_HAZ, INM_CONTA_NO, INM_CARRIER_NAME, INM_CARRIER_BOOK_NO, INM_SHIP_NAME, INM_TECH_NAME, INM_OUT_PAKGS, INM_INR_PAKG, INM_SUB_CLASS, INM_SHIP_DECLAR, INM_MARINE_POLLT, INM_FLASH_POINT, INM_EMS_NO, INM_UN_PAK_CODE, INM_UN_PAK_GRP FROM INVOICE_DETAIL,INVOICE_MASTER,PARTY_MASTER WHERE IND_INM_CODE = INM_CODE AND INM_P_CODE = P_CODE and inm_code=" + code + " group by P_NAME, P_CODE, INM_CODE, INM_NO, P_ADD1, P_PHONE, INM_DATE, INM_PORT_OF_DISCH, INM_PORT_OF_LOAD, INM_PLACE_OF_DEL, INM_FINAL_DEST, INM_UN_NO, INM_VOY_NO, INM_NOS_PACK, INM_HAZ, INM_CONTA_NO, INM_CARRIER_NAME, INM_CARRIER_BOOK_NO, INM_SHIP_NAME, INM_TECH_NAME, INM_OUT_PAKGS, INM_INR_PAKG, INM_SUB_CLASS, INM_SHIP_DECLAR, INM_MARINE_POLLT, INM_FLASH_POINT, INM_EMS_NO, INM_UN_PAK_CODE, INM_UN_PAK_GRP,INM_EXA_BOXES,P_CONTACT,P_MOB,INM_SHIPMENT ");
if (dtfinal1.Rows.Count > 0)
{
ReportDocument rptname = null;
rptname = new ReportDocument();
//string path = Server.MapPath("~/Reports/rptExportInvoice.rpt");
rptname.Load(Server.MapPath("~/Reports/rptDangerousGoodsDeclaration.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptDangerousGoodsDeclaration.rpt");
rptname.Refresh();
rptname.SetDataSource(dtfinal1);
rptname.SetParameterValue("txtCompPhone", Session["CompanyPhone"].ToString());
rptname.SetParameterValue("txtCompFaxNo", Session["Companyfax"].ToString());
rptname.SetParameterValue("txtCompAdd", Session["CompanyAdd"].ToString());
rptname.SetParameterValue("txtCompName", Session["CompanyName"].ToString());
string Boxes = dtfinal1.Rows[0]["INM_EXA_BOXES"].ToString();
rptname.SetParameterValue("txtBoxes", Boxes);
string P_Mob = dtfinal1.Rows[0]["P_MOB"].ToString();
rptname.SetParameterValue("txtP_Mob", P_Mob);
string P_CONTACT = dtfinal1.Rows[0]["P_CONTACT"].ToString();
rptname.SetParameterValue("txtP_CONTACT", P_CONTACT);
string INM_SHIPMENT = dtfinal1.Rows[0]["INM_SHIPMENT"].ToString();
rptname.SetParameterValue("txtINM_SHIPMENT", INM_SHIPMENT);
//rptname.SetParameterValue("txtCompVatTin", Session["CompanyVatTin"].ToString());
//rptname.SetParameterValue("txtCompCstTin", Session["CompanyCstTin"].ToString());
//rptname.SetParameterValue("txtCompEcc", Session["CompanyEccNo"].ToString());
//rptname.SetParameterValue("txtCompVatWef", Convert.ToDateTime(Session["CompanyVatWef"].ToString()).ToShortDateString());
//rptname.SetParameterValue("txtCompCstWef", Convert.ToDateTime(Session["CompanyCstWef"].ToString()).ToShortDateString());
//rptname.SetParameterValue("txtCompIso", Session["CompanyIso"].ToString());
//rptname.SetParameterValue("txtCompRegd", Session["CompanyRegd"].ToString());
//rptname.SetParameterValue("txtCompWebsite", Session["CompanyWebsite"].ToString());
//rptname.SetParameterValue("txtCompEmail", Session["CompanyEmail"].ToString());
//rptname.SetParameterValue("txtCompFinancialYr", Session["CompanyFinancialYr"].ToString());
CrystalReportViewer1.ReportSource = rptname;
}
#endregion
}
else if (printtype == "FormSDF")
{
#region Export Invoice Domestic Print
DataTable dtfinal1 = CommonClasses.Execute("SELECT INM_NO, INM_DATE,INM_G_AMT,CM_BANK_NAME+' '+CM_BANK_ADDRESS as BankDetails from INVOICE_MASTER,COMPANY_MASTER WHERE CM_CODE=INM_CM_CODE and INM_CODE =" + code);
if (dtfinal1.Rows.Count > 0)
{
ReportDocument rptname = null;
rptname = new ReportDocument();
//string path = Server.MapPath("~/Reports/rptExportInvoice.rpt");
rptname.Load(Server.MapPath("~/Reports/rptAppendixIFormSDF.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptAppendixIFormSDF.rpt");
rptname.Refresh();
rptname.SetDataSource(dtfinal1);
rptname.SetParameterValue("txtCompAdd", Session["CompanyAdd"].ToString());
rptname.SetParameterValue("txtCompName", Session["CompanyName"].ToString());
//rptname.SetParameterValue("txtCompVatTin", Session["CompanyVatTin"].ToString());
//rptname.SetParameterValue("txtCompCstTin", Session["CompanyCstTin"].ToString());
//rptname.SetParameterValue("txtCompEcc", Session["CompanyEccNo"].ToString());
//rptname.SetParameterValue("txtCompVatWef", Convert.ToDateTime(Session["CompanyVatWef"].ToString()).ToShortDateString());
//rptname.SetParameterValue("txtCompCstWef", Convert.ToDateTime(Session["CompanyCstWef"].ToString()).ToShortDateString());
//rptname.SetParameterValue("txtCompIso", Session["CompanyIso"].ToString());
//rptname.SetParameterValue("txtCompRegd", Session["CompanyRegd"].ToString());
//rptname.SetParameterValue("txtCompWebsite", Session["CompanyWebsite"].ToString());
//rptname.SetParameterValue("txtCompEmail", Session["CompanyEmail"].ToString());
//rptname.SetParameterValue("txtCompFinancialYr", Session["CompanyFinancialYr"].ToString());
CrystalReportViewer1.ReportSource = rptname;
}
#endregion
}
else if (printtype == "AreInv")
{
#region Export ARE Form 1
//DataTable dtfinal1 = CommonClasses.Execute("SELECT CM_NAME,CM_ADDRESS1,CM_ADDRESS2,CM_EXP_LICEN_NO,CM_EXP_PERMISSOIN_NO,CM_EXCISE_DIVISION, CM_EXCISE_RANGE,CM_COMMISONERATE,CM_EXC_SUPRE_DETAILS,INM_NO,INM_CODE,INM_DATE,INM_COUNTRY_DEST, INM_UT1_FILE_NO,INM_AUTHO_SIGN,INM_AREA_FORM_NO,INM_FORM_DATE,COUNTRY_NAME as COUNTORY_NAME FROM COMPANY_MASTER INNER JOIN INVOICE_MASTER ON COMPANY_MASTER.CM_CODE = INVOICE_MASTER.INM_CM_CODE LEFT OUTER JOIN COUNTRY_MASTER ON INVOICE_MASTER.INM_COUNTRY_DEST = COUNTRY_MASTER.COUNTRY_CODE WHERE INM_CODE='" + code + "'");
DataTable dtfinal1 = CommonClasses.Execute("SELECT CM_NAME,CM_ADDRESS1,CM_ADDRESS2+' '+CM_REGD_NO as CM_ADDRESS2,CM_EXP_LICEN_NO,CM_EXP_PERMISSOIN_NO,CM_EXCISE_DIVISION,CM_EXCISE_RANGE,CM_COMMISONERATE,CM_EXC_SUPRE_DETAILS,INM_NO,INM_CODE,INM_DATE,INM_COUNTRY_DEST,INM_UT1_FILE_NO,INM_AUTHO_SIGN,INM_AREA_FORM_NO,INM_FORM_DATE,COUNTRY_NAME AS COUNTORY_NAME,SUM(IND_INQTY) AS IND_INQTY,SUM(IND_INQTY * IND_RATE) AS AMT,SUM(IND_EX_AMT) AS IND_EX_AMT,SUM(IND_E_CESS_AMT) AS IND_E_CESS_AMT,SUM(IND_SH_CESS_AMT) AS IND_SH_CESS_AMT,sum(IND_GROSS_WEIGHT) as IND_GROSS_WEIGHT,sum(IND_NET_WEIGHT) as IND_NET_WEIGHT,IND_CPOM_CODE,E_BASIC,E_EDU_CESS,E_H_EDU,INM_TRANSPORT_BY,INM_ARE_REMARK,INM_REMOVAL_DATE,INM_REMOVEL_TIME FROM COMPANY_MASTER INNER JOIN INVOICE_MASTER ON COMPANY_MASTER.CM_CODE = INVOICE_MASTER.INM_CM_CODE INNER JOIN INVOICE_DETAIL ON INVOICE_MASTER.INM_CODE = INVOICE_DETAIL.IND_INM_CODE INNER JOIN ITEM_MASTER ON INVOICE_DETAIL.IND_I_CODE = ITEM_MASTER.I_CODE INNER JOIN EXCISE_TARIFF_MASTER ON ITEM_MASTER.I_E_CODE = EXCISE_TARIFF_MASTER.E_CODE LEFT OUTER JOIN COUNTRY_MASTER ON INVOICE_MASTER.INM_COUNTRY_DEST = COUNTRY_MASTER.COUNTRY_CODE WHERE (INVOICE_MASTER.INM_CODE = '" + code + "') GROUP BY CM_NAME,CM_ADDRESS1,CM_ADDRESS2,CM_REGD_NO,CM_EXP_LICEN_NO,CM_EXP_PERMISSOIN_NO,CM_EXCISE_DIVISION,CM_EXCISE_RANGE,CM_COMMISONERATE,CM_EXC_SUPRE_DETAILS,INM_NO,INM_CODE,INM_DATE, INM_COUNTRY_DEST,INM_UT1_FILE_NO,INM_AUTHO_SIGN,INM_AREA_FORM_NO,INM_FORM_DATE,COUNTRY_NAME,IND_CPOM_CODE,E_BASIC,E_EDU_CESS,E_H_EDU,INM_TRANSPORT_BY,INM_ARE_REMARK,INM_REMOVAL_DATE,INM_REMOVEL_TIME");
//DataTable dtfinal1 = CommonClasses.Execute("SELECT CM_NAME,CM_ADDRESS1,CM_ADDRESS2,CM_EXP_LICEN_NO,CM_EXP_PERMISSOIN_NO,CM_EXCISE_RANGE,CM_EXCISE_DIVISION,CM_COMMISONERATE,CM_EXC_SUPRE_DETAILS,INM_NO,INM_CODE,INM_DATE,INM_COUNTRY_DEST,INM_UT1_FILE_NO,INM_AUTHO_SIGN,INM_AREA_FORM_NO,INM_FORM_DATE,COUNTRY_NAME,I_NAME,IND_INQTY,IND_RATE,IND_INQTY*IND_RATE as AMT,IND_PACK_DESC FROM INVOICE_DETAIL INNER JOIN INVOICE_MASTER ON INVOICE_DETAIL.IND_INM_CODE = INVOICE_MASTER.INM_CODE INNER JOIN ITEM_MASTER ON INVOICE_DETAIL.IND_I_CODE = ITEM_MASTER.I_CODE INNER JOIN COMPANY_MASTER ON INVOICE_MASTER.INM_CM_CODE = COMPANY_MASTER.CM_CODE LEFT OUTER JOIN COUNTRY_MASTER ON INVOICE_MASTER.INM_COUNTRY_DEST = COUNTRY_MASTER.COUNTRY_CODE where INM_CODE='" + code + "' group by CM_NAME,CM_ADDRESS1,CM_ADDRESS2,CM_EXP_LICEN_NO,CM_EXP_PERMISSOIN_NO,CM_EXCISE_RANGE,CM_EXCISE_DIVISION,CM_COMMISONERATE,CM_EXC_SUPRE_DETAILS,INM_NO,INM_CODE,INM_DATE,INM_COUNTRY_DEST,INM_UT1_FILE_NO,INM_AUTHO_SIGN,INM_AREA_FORM_NO,INM_FORM_DATE,COUNTRY_NAME,I_NAME,IND_INQTY,IND_RATE,IND_PACK_DESC");
DataTable dtAre1Det = CommonClasses.Execute("SELECT I_NAME,cast(IND_INQTY as numeric(20,3)) as IND_INQTY,Cast(IND_RATE as numeric(20,2)) AS IND_RATE, cast(IND_INQTY*IND_RATE as numeric(20,2)) AS AMT,IND_PACK_DESC as IND_PACK_DESC,INM_CODE FROM INVOICE_DETAIL INNER JOIN INVOICE_MASTER ON INVOICE_DETAIL.IND_INM_CODE = INVOICE_MASTER.INM_CODE INNER JOIN ITEM_MASTER ON INVOICE_DETAIL.IND_I_CODE = ITEM_MASTER.I_CODE AND INM_CODE='" + code + "'");
DataTable dtExpInvoiceDet = new DataTable();
if (dtExpInvoiceDet.Columns.Count == 0)
{
dtExpInvoiceDet.Columns.Add("I_NAME");
dtExpInvoiceDet.Columns.Add("IND_INQTY");
dtExpInvoiceDet.Columns.Add("IND_RATE");
dtExpInvoiceDet.Columns.Add("AMT");
dtExpInvoiceDet.Columns.Add("IND_PACK_DESC");
dtExpInvoiceDet.Columns.Add("INM_CODE");
}
for (int n = 0; n < dtAre1Det.Rows.Count; n++)
{
dtExpInvoiceDet.Rows.Add(dtAre1Det.Rows[n]["I_NAME"].ToString(), dtAre1Det.Rows[n]["IND_INQTY"].ToString(), dtAre1Det.Rows[n]["IND_RATE"].ToString(), dtAre1Det.Rows[n]["AMT"].ToString(), dtAre1Det.Rows[n]["IND_PACK_DESC"].ToString(), dtAre1Det.Rows[n]["INM_CODE"].ToString());
}
if (dtfinal1.Rows.Count > 0)
{
ReportDocument rptname = null;
rptname = new ReportDocument();
//string path = Server.MapPath("~/Reports/rptExportInvoice.rpt");
rptname.Load(Server.MapPath("~/Reports/rptARE1Invoice.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptARE1Invoice.rpt");
rptname.Refresh();
rptname.SetDataSource(dtfinal1);
rptname.OpenSubreport("rptAreDet").SetDataSource(dtExpInvoiceDet);
//rptname.SetParameterValue("txtCompPhone", Session["CompanyPhone"].ToString());
//rptname.SetParameterValue("txtCompFaxNo", Session["Companyfax"].ToString());
//rptname.SetParameterValue("txtCompVatTin", Session["CompanyVatTin"].ToString());
//rptname.SetParameterValue("txtCompCstTin", Session["CompanyCstTin"].ToString());
//rptname.SetParameterValue("txtCompEcc", Session["CompanyEccNo"].ToString());
//rptname.SetParameterValue("txtCompVatWef", Convert.ToDateTime(Session["CompanyVatWef"].ToString()).ToShortDateString());
//rptname.SetParameterValue("txtCompCstWef", Convert.ToDateTime(Session["CompanyCstWef"].ToString()).ToShortDateString());
//rptname.SetParameterValue("txtCompIso", Session["CompanyIso"].ToString());
//rptname.SetParameterValue("txtCompRegd", Session["CompanyRegd"].ToString());
//rptname.SetParameterValue("txtCompWebsite", Session["CompanyWebsite"].ToString());
//rptname.SetParameterValue("txtCompEmail", Session["CompanyEmail"].ToString());
//rptname.SetParameterValue("txtCompFinancialYr", Session["CompanyFinancialYr"].ToString());
CrystalReportViewer1.ReportSource = rptname;
}
#endregion
}
else if (printtype == "ExpInvIndA")
{
#region ExpInvIndA
DataTable dtfinal1 = CommonClasses.Execute("SELECT COMPANY_MASTER.CM_CODE, COMPANY_MASTER.CM_NAME, COMPANY_MASTER.CM_ADDRESS1, COMPANY_MASTER.CM_ADDRESS2, COMPANY_MASTER.CM_PHONENO1, COMPANY_MASTER.CM_FAXNO, COMPANY_MASTER.CM_EMAILID, COMPANY_MASTER.CM_WEBSITE, COMPANY_MASTER.CM_ISO_NUMBER, INVOICE_MASTER.INM_CODE, INVOICE_MASTER.INM_NO, INVOICE_MASTER.INM_DATE, INVOICE_MASTER.INM_TOD, INVOICE_MASTER.INM_TOP, INVOICE_MASTER.INM_AUTHO_SIGN FROM COMPANY_MASTER CROSS JOIN INVOICE_MASTER where INM_CODE=" + code + "");
if (dtfinal1.Rows.Count > 0)
{
ReportDocument rptname = null;
rptname = new ReportDocument();
rptname.Load(Server.MapPath("~/Reports/rptExpInvIndA.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptExpInvIndA.rpt");
rptname.Refresh();
rptname.SetDataSource(dtfinal1);
CrystalReportViewer1.ReportSource = rptname;
}
else
{
}
#endregion
}
else if (printtype == "ARE1Declaration")
{
#region ARE1Declaration
DataTable dtfinal1 = CommonClasses.Execute("SELECT INM_UT1_FILE_NO,INM_FILE_NO as INM_ARE_REMARK from INVOICE_MASTER where INM_CODE=" + code + "");
if (dtfinal1.Rows.Count > 0)
{
ReportDocument rptname = null;
rptname = new ReportDocument();
rptname.Load(Server.MapPath("~/Reports/rptARE1Declaration.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptARE1Declaration.rpt");
rptname.Refresh();
rptname.SetDataSource(dtfinal1);
CrystalReportViewer1.ReportSource = rptname;
}
else
{
}
#endregion
}
else if (printtype == "Eximination")
{
#region Eximination
DataTable dtfinal1 = CommonClasses.Execute("SELECT INVOICE_MASTER.INM_PER_E_NO, INVOICE_MASTER.INM_CUST_SEAL_NO, COMPANY_MASTER.CM_NAME, COMPANY_MASTER.CM_CODE,COMPANY_MASTER.CM_ADDRESS2 as CM_ADDRESS1, INVOICE_MASTER.INM_CODE, INVOICE_MASTER.INM_DATE, INVOICE_MASTER.INM_AREA_FORM_NO, INVOICE_MASTER.INM_SEAL_NO, INVOICE_MASTER.INM_CONTA_NO FROM COMPANY_MASTER CROSS JOIN INVOICE_MASTER where INM_CODE=" + code + "");
if (dtfinal1.Rows.Count > 0)
{
ReportDocument rptname = null;
rptname = new ReportDocument();
rptname.Load(Server.MapPath("~/Reports/rptEximinationReport.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptEximinationReport.rpt");
rptname.Refresh();
rptname.SetDataSource(dtfinal1);
CrystalReportViewer1.ReportSource = rptname;
}
else
{
}
#endregion
}
else if (printtype == "ANNEXURE C-1")
{
#region ANNEXUREC-1
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
DataTable dtfinal1 = CommonClasses.Execute(" SELECT distinct( INM_CODE) as INM_CODE,INM_EXA_BOXES, INVOICE_MASTER.INM_CONTA_NO,INVOICE_MASTER.INM_SHIPP_BILL_NO, INVOICE_MASTER.INM_NONCARGO_NOPAKG,INVOICE_MASTER.INM_DATE, COMPANY_MASTER.CM_CODE, COMPANY_MASTER.CM_NAME, INVOICE_MASTER.INM_IEC_NO, INVOICE_MASTER.INM_CEN_EXC_REG, INVOICE_MASTER.INM_BOND_NO, COMPANY_MASTER.CM_ADDRESS1, INVOICE_MASTER.INM_DATE_OF_EXAM, INVOICE_MASTER.INM_SUP_C_EXC_NAME,INVOICE_MASTER.INM_INSP_C_EXC_NAME, COMPANY_MASTER.CM_COMMISONERATE, COMPANY_MASTER.CM_EXCISE_DIVISION, COMPANY_MASTER.CM_EXCISE_RANGE, INVOICE_MASTER.INM_NO, INVOICE_MASTER.INM_PACK_AMT, PARTY_MASTER.P_NAME, PARTY_MASTER.P_ADD1, INVOICE_MASTER.INM_M_NO, INVOICE_MASTER.INM_CUST_SEAL_NO, INVOICE_MASTER.INM_OTS_NO, INVOICE_MASTER.INM_CODE, INVOICE_MASTER.INM_P_CODE, COMPANY_MASTER.CM_PAN_NO, INVOICE_MASTER.INM_SEAL_NO FROM INVOICE_DETAIL INNER JOIN INVOICE_MASTER ON INVOICE_DETAIL.IND_INM_CODE = INVOICE_MASTER.INM_CODE INNER JOIN PARTY_MASTER ON INVOICE_MASTER.INM_P_CODE = PARTY_MASTER.P_CODE CROSS JOIN COMPANY_MASTER where INM_CODE=" + code + "");
DataTable dtitem = CommonClasses.Execute(" SELECT SUM(INVOICE_DETAIL.IND_INQTY)as IND_INQTY, ITEM_MASTER.I_NAME FROM INVOICE_MASTER INNER JOIN INVOICE_DETAIL ON INVOICE_MASTER.INM_CODE = INVOICE_DETAIL.IND_INM_CODE AND INVOICE_MASTER.INM_CODE = INVOICE_DETAIL.IND_INM_CODE LEFT OUTER JOIN ITEM_MASTER ON INVOICE_DETAIL.IND_I_CODE = ITEM_MASTER.I_CODE WHERE(INVOICE_MASTER.INM_CODE=" + code + ")GROUP BY INVOICE_DETAIL.IND_INQTY, INVOICE_DETAIL.IND_I_CODE, INVOICE_MASTER.INM_CODE, ITEM_MASTER.I_NAME");
DataTable dtQty = CommonClasses.Execute(" SELECT SUM(INVOICE_DETAIL.IND_INQTY)as IND_INQTY,sum(IND_NET_WEIGHT ) as IND_NET_WEIGHT,SUM(IND_NO_OF_BARRELS) as IND_NO_OF_BARRELS FROM INVOICE_MASTER INNER JOIN INVOICE_DETAIL ON INVOICE_MASTER.INM_CODE = INVOICE_DETAIL.IND_INM_CODE AND INVOICE_MASTER.INM_CODE = INVOICE_DETAIL.IND_INM_CODE LEFT OUTER JOIN ITEM_MASTER ON INVOICE_DETAIL.IND_I_CODE = ITEM_MASTER.I_CODE WHERE(INVOICE_MASTER.INM_CODE=" + code + ")");
if (dtfinal1.Rows.Count > 0)
{
ReportDocument rptname = null;
rptname = new ReportDocument();
rptname.Load(Server.MapPath("~/Reports/rptExpInvAnnexureC1.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptExpInvAnnexureC1.rpt");
rptname.Refresh();
// rptname.SetDataSource(ds);
string s = "";
double Qty = Convert.ToDouble(dtQty.Rows[0]["IND_INQTY"].ToString());
string PalletNo = dtfinal1.Rows[0]["INM_EXA_BOXES"].ToString();
string Netweight = dtQty.Rows[0]["IND_NET_WEIGHT"].ToString();
string NoofBar = dtQty.Rows[0]["IND_NO_OF_BARRELS"].ToString();
for (int i = 0; i < dtitem.Rows.Count; i++)
{
s = s + dtitem.Rows[i]["I_NAME"].ToString() + " ,& ";
}
s = s.Remove(s.Length - 2, 2);
s = s + "(As per Invoice & Packing List)";
rptname.Database.Tables[0].SetDataSource(dtfinal1);
// rptname.Database.Tables[1].SetDataSource(dtitem);
rptname.SetParameterValue("txtItem", s);
rptname.SetParameterValue("txtQty", Qty);
rptname.SetParameterValue("txtPalletNo", PalletNo);
rptname.SetParameterValue("txtNetweight", Netweight);
rptname.SetParameterValue("txtNoofBar", NoofBar);
CrystalReportViewer1.ReportSource = rptname;
}
else
{
}
#endregion
}
else if (printtype == "AUTHORITYLETTER")
{
#region Authority Letter
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
DataTable dtfinal1 = CommonClasses.Execute(" SELECT distinct( INM_CODE) as INM_CODE,INM_DATE,INM_NO,INM_LC_NO,INM_LC_DATE,INM_TRANSPORT_BY as INM_TRANSPORT,CM_COMM_CUSTOM,CM_AUT_SPEC_SIGN from INVOICE_MASTER,COMPANY_MASTER where CM_CODE=INM_CM_CODE and INM_CODE=" + code + "");
if (dtfinal1.Rows.Count > 0)
{
ReportDocument rptname = null;
rptname = new ReportDocument();
rptname.Load(Server.MapPath("~/Reports/rptAuthorityLetter.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptAuthorityLetter.rpt");
rptname.Refresh();
rptname.Database.Tables[0].SetDataSource(dtfinal1);
// rptname.Database.Tables[1].SetDataSource(dtitem);
rptname.SetParameterValue("txtCompFinancialYr", Session["CompanyFinancialYr"].ToString());
CrystalReportViewer1.ReportSource = rptname;
}
else
{
}
#endregion
}
else
{
#region PROFORMA INVOICE
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
DataTable dtfinal1 = CommonClasses.Execute(" SELECT INM_PORT_OF_LOAD,INM_PORT_OF_DISCH,INM_CODE,COMPANY_MASTER.CM_NAME, COMPANY_MASTER.CM_ADDRESS1, COMPANY_MASTER.CM_PHONENO1, COMPANY_MASTER.CM_FAXNO, COMPANY_MASTER.CM_EMAILID, COMPANY_MASTER.CM_WEBSITE, COMPANY_MASTER.CM_ISO_NUMBER, COMPANY_MASTER.CM_BANK_NAME, COMPANY_MASTER.CM_BANK_ADDRESS, COMPANY_MASTER.CM_BANK_ACC_NO, COMPANY_MASTER.CM_ACC_TYPE, COMPANY_MASTER.CM_B_SWIFT_CODE, COMPANY_MASTER.CM_IFSC_CODE, COMPANY_MASTER.CM_ADDRESS2, COMPANY_MASTER.CM_CODE, COUNTRY_MASTER1.COUNTRY_NAME as INM_COUNTRY_ORIGIN, COUNTRY_MASTER2.COUNTRY_NAME as INM_COUNTRY_DEST, PARTY_MASTER.P_CODE, PARTY_MASTER.P_NAME, PARTY_MASTER.P_CONTACT, PARTY_MASTER.P_ADD1, PARTY_MASTER.P_MOB, PARTY_MASTER.P_FAX, INVOICE_MASTER.INM_NO, INVOICE_MASTER.INM_DATE, INVOICE_MASTER.INM_IEC_NO, INVOICE_MASTER.INM_PRE_CARRIAGE, INVOICE_MASTER.INM_PLACE_REC, INVOICE_MASTER.INM_CONTRY_ORIGIN as INM_CONTRY_ORIGIN1, INVOICE_MASTER.INM_COUNTRY_DEST, INVOICE_MASTER.INM_VOY_NO, INVOICE_MASTER.INM_FINAL_DEST as INM_FINAL_DEST1, INVOICE_MASTER.INM_TOD, INVOICE_MASTER.INM_TOP, INVOICE_MASTER.INM_M_NO, INVOICE_MASTER.INM_NOS_PACK FROM COUNTRY_MASTER COUNTRY_MASTER1,COUNTRY_MASTER COUNTRY_MASTER2, INVOICE_MASTER , COMPANY_MASTER , PARTY_MASTER where COUNTRY_MASTER1.COUNTRY_CODE = INVOICE_MASTER.INM_CONTRY_ORIGIN and INVOICE_MASTER.INM_COUNTRY_DEST= COUNTRY_MASTER2.COUNTRY_CODE and INM_P_CODE=P_CODE and INM_CODE=" + code + " ");
DataTable dtitem = CommonClasses.Execute(" SELECT IND_GROSS_WEIGHT,IND_NET_WEIGHT, INVOICE_DETAIL.IND_INM_CODE, INVOICE_DETAIL.IND_I_CODE, INVOICE_DETAIL.IND_INQTY, INVOICE_DETAIL.IND_RATE, INVOICE_DETAIL.IND_AMT, INVOICE_DETAIL.IND_GROSS_WEIGHT, INVOICE_DETAIL.IND_NET_WEIGHT, ITEM_UNIT_MASTER.I_UOM_NAME, INVOICE_MASTER.INM_CODE,I_NAME FROM ITEM_UNIT_MASTER , INVOICE_DETAIL , INVOICE_MASTER ,ITEM_MASTER where INM_CODE=IND_INM_CODE and I_CODE=IND_I_CODE and ITEM_UNIT_MASTER.I_UOM_CODE=ITEM_MASTER.I_UOM_CODE and INM_CODE=" + code + " ");
if (dtfinal1.Rows.Count > 0)
{
ReportDocument rptname = null;
rptname = new ReportDocument();
rptname.Load(Server.MapPath("~/Reports/rptProformaInvoice.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptProformaInvoice.rpt");
rptname.Refresh();
//string Load = dtfinal1.Rows[0]["INM_PORT_OF_LOAD"].ToString();
// string Disch = dtfinal1.Rows[0]["INM_PORT_OF_DISCH"].ToString();
rptname.SetDataSource(dtfinal1);
rptname.Database.Tables[1].SetDataSource(dtitem);
string CINNo = DL_DBAccess.GetColumn("select CM_CIN_NO from COMPANY_MASTER where CM_ID='" + Session["CompanyId"] + "'");
rptname.SetParameterValue("txtCINNo", CINNo);
// rptname.SetParameterValue("txtportl", Load);
//rptname.SetParameterValue("txtport", Disch);
CrystalReportViewer1.ReportSource = rptname;
}
else
{
}
#endregion
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Export Invoice", "GenerateReport", Ex.Message);
}
}
private void GenerateReport(string code, string Autho_Flag, string Po_Type)
{
DL_DBAccess = new DatabaseAccessLayer();
DataTable dtfinal = new DataTable();
try
{
{
dtfinal = CommonClasses.Execute("SELECT SUBSTRING(P_NAME,1,1)+''+ CONVERT(VARCHAR,P_PARTY_CODE) AS P_PARTY_CODE,SPOM_USER_CODE,UM_NAME,UM_USERNAME , dbo.SUPP_PO_DETAILS.SPOD_DISC_AMT, dbo.SUPP_PO_MASTER.SPOM_CODE, dbo.PARTY_MASTER.P_NAME, dbo.PARTY_MASTER.P_ADD1, dbo.PARTY_MASTER.P_CONTACT, dbo.PARTY_MASTER.P_PHONE, P_PAN, P_CST, P_VAT, P_ECC_NO, P_EXC_DIV, P_EXC_RANGE, P_EXC_COLLECTORATE, dbo.SUPP_PO_MASTER.SPOM_PO_NO, dbo.SUPP_PO_MASTER.SPOM_DATE, dbo.ITEM_MASTER.I_CODE, I_NAME, dbo.ITEM_MASTER.I_MATERIAL, dbo.SUPP_PO_DETAILS.SPOD_ORDER_QTY, dbo.SUPP_PO_DETAILS.SPOD_RATE, dbo.SUPP_PO_DETAILS.SPOD_ORDER_QTY * dbo.SUPP_PO_DETAILS.SPOD_RATE AS SPOD_AMOUNT, dbo.SUPP_PO_DETAILS.SPOD_EXC_Y_N, dbo.SALES_TAX_MASTER.ST_TAX_NAME, dbo.SALES_TAX_MASTER.ST_SALES_TAX, dbo.ITEM_MASTER.I_E_CODE,CASE when P_SM_CODE=CM_STATE then SPOD_EXC_PER else 0 END AS E_BASIC, CASE when P_SM_CODE=CM_STATE then E_EDU_CESS else 0 END AS E_EDU_CESS, CASE when P_SM_CODE=CM_STATE then 0 else E_H_EDU END AS E_H_EDU, dbo.SUPP_PO_MASTER.SPOM_DELIVERED_TO, dbo.SUPP_PO_MASTER.SPOM_TRANSPOTER, dbo.SUPP_PO_MASTER.SOM_FREIGHT_TERM, dbo.SUPP_PO_MASTER.SPOM_PAY_TERM1, dbo.SUPP_PO_MASTER.SPOM_DEL_SHCEDULE, dbo.SUPP_PO_MASTER.SPOM_NOTES, dbo.SUPP_PO_MASTER.SPOM_GUARNTY, dbo.SUPP_PO_MASTER.SPOM_SUP_REF_DATE, dbo.PARTY_MASTER.P_MOB, dbo.SUPP_PO_DETAILS.SPOD_SPECIFICATION, dbo.ITEM_UNIT_MASTER.I_UOM_NAME, (CASE WHEN (LEN(I_NAME) / 30) = 0 THEN 1 ELSE (LEN(I_NAME) / 30) END) AS I_LENGTH, (CASE WHEN (LEN(I_MATERIAL) / 30) = 0 THEN 1 ELSE (LEN(I_MATERIAL) / 30) END) AS I_MATERIAL_LENGTH, (CASE WHEN (LEN(SPOD_SPECIFICATION) / 30) = 0 THEN 1 ELSE (LEN(SPOD_SPECIFICATION) / 30) END) AS SPOD_SPECIFICATION_LENGTH, ISNULL(dbo.SUPP_PO_MASTER.SPOM_AM_COUNT, 0) AS SPOM_AM_COUNT, dbo.SUPP_PO_MASTER.SPOM_PACKING AS SPOM_PAKING, dbo.SUPP_PO_MASTER.SPOM_SUP_REF, dbo.ITEM_MASTER.I_CAT_CODE, dbo.SUPP_PO_DETAILS.SPOD_ITEM_NAME, dbo.COMPANY_MASTER.CM_ADDRESS1, dbo.COMPANY_MASTER.CM_ADDRESS2, dbo.COMPANY_MASTER.CM_PHONENO1, dbo.COMPANY_MASTER.CM_FAXNO, dbo.COMPANY_MASTER.CM_EMAILID, dbo.COMPANY_MASTER.CM_PHONENO2, dbo.COMPANY_MASTER.CM_WEBSITE,dbo.COMPANY_MASTER.CM_BANK_NAME,dbo.COMPANY_MASTER.CM_BANK_ACC_NO,I_CODENO,E_COMMODITY,E_TARIFF_NO,P_EMAIL,SPOM_CIF_NO,SPOM_AM_DATE,PROCM_NAME AS SPOM_PROJECT,SPOM_VALID_DATE,PROCESS_NAME,SPOD_DISC_PER,SPOM_PONO,SPOM_PROJ_NAME,PO_T_SHORT_NAME,PO_T_FIRST_LETTER,PO_T_DESC ,SPOM_AM_DATE ,ISNULL(SPOD_CENTRAL_TAX_AMT,0) AS SPOD_EXC_AMT,ISNULL(SPOD_STATE_TAX_AMT,0) AS SPOD_EXC_E_AMT, ISNULL(SPOD_INTEGRATED_TAX_AMT,0) AS SPOD_EXC_HE_AMT,SPOD_E_TARRIF_CODE AS SPOD_E_CODE,E_TARIFF_NO AS SPOD_E_TARIFF_NO ,CASE WHEN P_LBT_IND=1 then P_LBT_NO ELSE 'NA' END AS P_GST_NO FROM dbo.ITEM_UNIT_MASTER INNER JOIN dbo.SUPP_PO_DETAILS ON dbo.ITEM_UNIT_MASTER.I_UOM_CODE = dbo.SUPP_PO_DETAILS.SPOD_UOM_CODE INNER JOIN dbo.SUPP_PO_MASTER ON dbo.SUPP_PO_DETAILS.SPOD_SPOM_CODE = dbo.SUPP_PO_MASTER.SPOM_CODE INNER JOIN dbo.PARTY_MASTER ON dbo.SUPP_PO_MASTER.SPOM_P_CODE = dbo.PARTY_MASTER.P_CODE INNER JOIN dbo.ITEM_MASTER ON dbo.SUPP_PO_DETAILS.SPOD_I_CODE = dbo.ITEM_MASTER.I_CODE INNER JOIN dbo.SALES_TAX_MASTER ON dbo.SUPP_PO_DETAILS.SPOD_T_CODE = dbo.SALES_TAX_MASTER.ST_CODE INNER JOIN dbo.EXCISE_TARIFF_MASTER ON dbo.ITEM_MASTER.I_SCAT_CODE = dbo.EXCISE_TARIFF_MASTER.E_CODE INNER JOIN dbo.COMPANY_MASTER ON dbo.SUPP_PO_MASTER.SPOM_CM_CODE = dbo.COMPANY_MASTER.CM_CODE INNER JOIN USER_MASTER ON USER_MASTER.UM_CODE=SPOM_USER_CODE INNER JOIN PROCESS_MASTER ON PROCESS_CODE=SPOD_PROCESS_CODE INNER JOIN PO_TYPE_MASTER ON SPOM_TYPE=PO_T_CODE INNER JOIN PROJECT_CODE_MASTER ON PROCM_CODE=SPOM_PROJECT WHERE (dbo.SUPP_PO_MASTER.ES_DELETE = 0) AND (dbo.SUPP_PO_MASTER.SPOM_CODE = '" + code + "')");
ReportDocument rptname = null;
rptname = new ReportDocument();
rptname.Load(Server.MapPath("~/Reports/rptSuConPoPrint.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptSuConPoPrint.rpt");
rptname.Refresh();
rptname.SetDataSource(dtfinal);
rptname.SetParameterValue("txtUserName", dtfinal.Rows[0]["UM_NAME"].ToString());
DataTable dtComp = new DataTable();
dtComp = CommonClasses.Execute(" SELECT CM_GST_NO, CM_NAME, CM_ID, CM_ADDRESS1, CM_PHONENO1, CM_FAXNO, CM_EMAILID, CM_WEBSITE, CM_VAT_TIN_NO, CM_CST_NO, CM_PAN_NO, CM_ECC_NO,CM_VAT_WEF, CM_CST_WEF,CM_EXCISE_RANGE ,CM_EXCISE_DIVISION,CM_COMMISONERATE FROM COMPANY_MASTER where CM_ID='" + Session["CompanyId"].ToString() + "'");
rptname.SetParameterValue("txtComp", dtComp.Rows[0]["CM_NAME"].ToString().ToUpper());
rptname.SetParameterValue("txtAdd", dtComp.Rows[0]["CM_ADDRESS1"].ToString().ToUpper());
rptname.SetParameterValue("txtPhone", dtComp.Rows[0]["CM_PHONENO1"].ToString());
rptname.SetParameterValue("txtFax", dtComp.Rows[0]["CM_FAXNO"].ToString());
rptname.SetParameterValue("txtEmail", dtComp.Rows[0]["CM_EMAILID"].ToString());
rptname.SetParameterValue("txtVAT", dtComp.Rows[0]["CM_VAT_TIN_NO"].ToString());
rptname.SetParameterValue("txtCST", dtComp.Rows[0]["CM_CST_NO"].ToString());
rptname.SetParameterValue("txtECC", dtComp.Rows[0]["CM_ECC_NO"].ToString());
rptname.SetParameterValue("txtRange", dtComp.Rows[0]["CM_EXCISE_RANGE"].ToString());
rptname.SetParameterValue("txtDivision", dtComp.Rows[0]["CM_EXCISE_DIVISION"].ToString());
rptname.SetParameterValue("txtComm", dtComp.Rows[0]["CM_COMMISONERATE"].ToString());
rptname.SetParameterValue("txtP_CODE", dtfinal.Rows[0]["P_PARTY_CODE"].ToString());
rptname.SetParameterValue("txtGST", dtComp.Rows[0]["CM_GST_NO"].ToString());
rptname.SetParameterValue("txtPAN_NO", dtComp.Rows[0]["CM_PAN_NO"].ToString());
rptname.SetParameterValue("txtCM_VAT_WEF", Convert.ToDateTime(Session["CompanyVatWef"]).ToString("dd/MM/yyyy").ToString());
rptname.SetParameterValue("txtCM_CST_WEF", Convert.ToDateTime(Session["CompanyCstWef"]).ToString("dd/MM/yyyy").ToString());
if (Autho_Flag == "true")
{
rptname.SetParameterValue("txtAuthFalg", "0");
}
else
{
rptname.SetParameterValue("txtAuthFalg", "1");
}
string IsoNo = DL_DBAccess.GetColumn("select ISO_NO from ISONO_MASTER,SUPP_PO_MASTER where SPOM_CODE='" + code + "' and ISO_SCREEN_NO=42 and ISO_WEF_DATE<=SPOM_DATE order by ISO_WEF_DATE DESC");
rptname.SetParameterValue("txtIsoNo", IsoNo);
if (IsoNo == "")
{
rptname.SetParameterValue("txtIsoNo", "1");
}
else
{
rptname.SetParameterValue("txtIsoNo", IsoNo.ToString());
}
CrystalReportViewer1.ReportSource = rptname;
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Supplier PO Print", "GenerateReport", Ex.Message);
}
}
private void GenerateReport(string code, string printType)
{
try
{
DL_DBAccess = new DatabaseAccessLayer();
DataTable dtfinal = new DataTable();
if (printType == "REQUSITION")
{
dtfinal = CommonClasses.Execute("select MR_CODE,MR_BATCH_NO,MR_DATE,MR_TYPE,MR_CPOM_CODE,MR_I_CODE,MRD_I_CODE,isnull(MRD_ADD_IN,0) as MRD_ADD_IN,isnull(MRD_REQ_QTY,0) as MRD_REQ_QTY,MRD_ISSUE_QTY,MRD_PROD_QTY,MRD_PURC_REQ_QTY,(I1.I_NAME) as FINISH_I_NAME,I1.I_CODENO as FINISH_I_CODENO,I2.I_NAME as RAW_I_NAME,I2.I_CODENO as RAW_I_CODENO,MR_DEPT_NAME,BT_NO,SHM_FORMULA_CODE as MR_FORMULA from MATERIAL_REQUISITION_MASTER,MATERIAL_REQUISITION_DETAIL,BATCH_MASTER,SHADE_MASTER,ITEM_MASTER as I1,ITEM_MASTER I2 where BT_SHM_CODE=SHM_CODE and MR_BATCH_CODE=BT_CODE and MR_CODE=MRD_MR_CODE and MR_I_CODE=I1.I_CODE and MRD_I_CODE=I2.I_CODE and MATERIAL_REQUISITION_MASTER.ES_DELETE=0 and MR_CODE='" + code + "'");
}
else
{
string type = DL_DBAccess.GetColumn("select IM_TYPE from ISSUE_MASTER where IM_CODE='" + code + "'");
if (type == "1")
{
dtfinal = CommonClasses.Execute("SELECT dbo.ISSUE_MASTER.IM_CODE AS MR_CODE, dbo.MATERIAL_REQUISITION_MASTER.MR_BATCH_NO as MR_BATCH_NO, dbo.ISSUE_MASTER.IM_DATE AS MR_DATE,dbo.ISSUE_MASTER.IM_TYPE AS MR_TYPE, dbo.MATERIAL_REQUISITION_MASTER.MR_I_CODE, dbo.ISSUE_MASTER_DETAIL.IMD_I_CODE AS MRD_I_CODE, dbo.ISSUE_MASTER_DETAIL.IMD_REQ_QTY AS MRD_REQ_QTY,dbo.ISSUE_MASTER_DETAIL.IMD_ISSUE_QTY AS MRD_ISSUE_QTY, I1.I_NAME AS FINISH_I_NAME, I1.I_CODENO AS FINISH_I_CODENO, I2.I_NAME AS RAW_I_NAME, I2.I_CODENO AS RAW_I_CODENO, dbo.SHADE_MASTER.SHM_FORMULA_CODE as MR_FORMULA, dbo.BATCH_MASTER.BT_NO,'Store' as MR_DEPT_NAME,dbo.ISSUE_MASTER_DETAIL.IMD_REQ_QTY AS MRD_ADD_IN FROM dbo.SHADE_MASTER INNER JOIN dbo.BATCH_MASTER ON dbo.SHADE_MASTER.SHM_CODE = dbo.BATCH_MASTER.BT_SHM_CODE INNER JOIN dbo.ITEM_MASTER AS I2 INNER JOIN dbo.ISSUE_MASTER INNER JOIN dbo.ISSUE_MASTER_DETAIL ON dbo.ISSUE_MASTER.IM_CODE = dbo.ISSUE_MASTER_DETAIL.IM_CODE ON I2.I_CODE = dbo.ISSUE_MASTER_DETAIL.IMD_I_CODE INNER JOIN dbo.ITEM_MASTER AS I1 INNER JOIN dbo.MATERIAL_REQUISITION_MASTER ON I1.I_CODE = dbo.MATERIAL_REQUISITION_MASTER.MR_I_CODE ON dbo.ISSUE_MASTER.IM_MATERIAL_REQ = dbo.MATERIAL_REQUISITION_MASTER.MR_CODE ON dbo.BATCH_MASTER.BT_CODE = dbo.MATERIAL_REQUISITION_MASTER.MR_BATCH_CODE WHERE (dbo.MATERIAL_REQUISITION_MASTER.ES_DELETE = 0) AND (dbo.ISSUE_MASTER.IM_CODE = '" + code + "')");
}
else
{
dtfinal = CommonClasses.Execute("select ISSUE_MASTER.IM_CODE as MR_CODE,IM_NO as MR_BATCH_NO,IM_DATE as MR_DATE,IM_TYPE as MR_TYPE,IMD_I_CODE as MRD_I_CODE,IMD_REQ_QTY as MRD_REQ_QTY,IMD_ISSUE_QTY as MRD_ISSUE_QTY,I2.I_NAME as RAW_I_NAME,I2.I_CODENO as RAW_I_CODENO,ISNULL(IMD_RATE,0) AS IMD_RATE,ISNULL(IMD_AMOUNT,0) AS IMD_AMOUNT ,IM_ISSUEBY,IM_REQBY,IM_UM_CODE,UM_NAME,UM_USERNAME from ISSUE_MASTER,ISSUE_MASTER_DETAIL,ITEM_MASTER I2,USER_MASTER where ISSUE_MASTER.IM_CODE=ISSUE_MASTER_DETAIL.IM_CODE and IMD_I_CODE=I2.I_CODE and ISSUE_MASTER.IM_CODE='" + code + "' AND IM_UM_CODE=UM_CODE ");
}
}
if (dtfinal.Rows.Count > 0)
{
try
{
ReportDocument rptname = null;
rptname = new ReportDocument();
rptname.Load(Server.MapPath("~/Reports/rptMaterialRequisitionPrint.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptMaterialRequisitionPrint.rpt");
rptname.Refresh();
rptname.SetDataSource(dtfinal);
rptname.SetParameterValue("txtCompName", Session["CompanyName"].ToString());
if (printType == "REQUSITION")
{
rptname.SetParameterValue("txtTitle", "Material Requisition");
}
else
{
rptname.SetParameterValue("txtTitle", "Issue To Production");
}
CrystalReportViewer1.ReportSource = rptname;
}
catch (Exception Ex)
{
CommonClasses.SendError("Material Requisition Print", "GenerateReport", Ex.Message);
}
}
else
{
PanelMsg.Visible = true;
lblmsg.Text = "Record Not Found";
return;
}
}
catch (Exception Ex)
{
}
}
private void GenerateReport(string code, string type)
{
DL_DBAccess = new DatabaseAccessLayer();
//DataTable dtfinal = CommonClasses.Execute("select EM_CODE ,EM_NAME ,BM_NAME,CONVERT(VARCHAR(11),EM_JOINDATE,113) as EM_JOINDATE,CONVERT(VARCHAR(11),FS_LEAVE_DATE,113) as FS_LEAVE_DATE,CONVERT(VARCHAR(11),FS_RESIGN_DATE,113) as FS_RESIGN_DATE,DS_NAME,FS_LAST_SAL,FS_BONUS_AMT,FS_LEAVE_AMT,FS_LTA_AMT,FS_ADV_AMT,FS_LOAN_AMT,FS_NOTICE_AMT,FS_FINAL_AMT,FS_PAYABLE_LEAVES as LeaveDay,FS_NOTICE_DAYS as NoticeDay from HR_FINAL_SETTLEMENT,HR_EMPLOYEE_MASTER,HR_DESINGNATION_MASTER,CM_BRANCH_MASTER where EM_CODE=FS_EM_CODE and BM_CODE=EM_BM_CODE and EM_DM_CODE=DS_CODE and FS_CODE=" + fsCode + " and FS_DELETE_FLAG=0 and FS_CM_COMP_ID=" + Session["CompanyId"].ToString() + "");
try
{
// DataTable dtfinal = CommonClasses.Execute("SELECT DISTINCT(I_CODE),P_CODE,P_NAME,P_ADD1,P_VEND_CODE,P_CST,P_VAT,P_ECC_NO,INM_NO,INM_DATE,INM_TRANSPORT,INM_VEH_NO,INM_LR_NO,INM_LR_DATE,I_NAME,CPOD_CUST_I_CODE,CPOD_CUST_I_NAME,CPOM_PONO,CONVERT(VARCHAR(11),CPOM_DATE,113) as CPOM_DATE,IND_SUBHEADING,IND_BACHNO,IND_NO_PACK,IND_PAK_QTY,IND_INQTY,IND_RATE,E_BASIC,E_SPECIAL,E_EDU_CESS,E_H_EDU,ST_TAX_NAME,ST_SALES_TAX FROM EXCISE_TARIFF_MASTER,CUSTPO_DETAIL,CUSTPO_MASTER,INVOICE_MASTER,INVOICE_DETAIL,ITEM_MASTER,SALES_TAX_MASTER,PARTY_MASTER WHERE INM_CODE = IND_INM_CODE and CPOD_CPOM_CODE = CPOM_CODE and INM_P_CODE = P_CODE AND INM_P_CODE = CPOM_P_CODE and CPOM_CODE = IND_CPOM_CODE AND IND_I_CODE=CPOD_I_CODE and IND_I_CODE = I_CODE and I_E_CODE=E_CODE and IND_I_CODE=CPOD_I_CODE AND CPOD_ST_CODE=ST_CODE and INM_CODE='" + code + "' group by I_CODE,INM_NO,P_CODE,P_NAME,P_ADD1,P_VEND_CODE,P_CST,P_VAT,P_ECC_NO,INM_DATE,INM_TRANSPORT,INM_LR_NO,INM_LR_DATE,I_NAME,CPOD_CUST_I_CODE,CPOD_CUST_I_NAME,CPOM_PONO,CPOM_DATE,IND_SUBHEADING,IND_BACHNO,IND_NO_PACK,IND_PAK_QTY,IND_INQTY,IND_RATE,E_BASIC,E_SPECIAL,E_EDU_CESS,E_H_EDU,INM_VEH_NO,ST_TAX_NAME,ST_SALES_TAX");
//DataTable dtfinal = CommonClasses.Execute("SELECT DISTINCT(I_CODE),P_CODE,E_TARIFF_NO,P_NAME,P_ADD1,P_VEND_CODE,P_CST,P_VAT,P_ECC_NO,INM_NO,INM_DATE,INM_TRANSPORT,INM_VEH_NO,INM_LR_NO,INM_LR_DATE,I_NAME,CPOD_CUST_I_CODE,CPOD_CUST_I_NAME,CPOM_PONO,ST_TAX_NAME,CONVERT(VARCHAR(11),CPOM_DATE,113) as CPOM_DATE,IND_SUBHEADING,IND_BACHNO,IND_NO_PACK,cast(isnull(IND_PAK_QTY,0) as numeric(20,3)) as IND_PAK_QTY,cast(isnull(IND_INQTY,0) as numeric(20,3)) as IND_INQTY,cast(isnull(IND_RATE,0) as numeric(20,2)) as IND_RATE,cast(isnull(IND_AMT,0) as numeric(20,2)) as IND_AMT,cast(isnull(INM_NET_AMT,0) as numeric(20,2)) as INM_NET_AMT,cast(isnull(INM_DISC,0) as numeric(20,2)) as INM_DISC,cast(isnull(INM_DISC_AMT,0) as numeric(20,2)) as INM_DISC_AMT,cast(isnull(INM_PACK_AMT,0) as numeric(20,2)) as INM_PACK_AMT,cast(isnull(INM_ACCESSIBLE_AMT,0) as numeric(20,2)) as INM_ACCESSIBLE_AMT,cast(isnull(INM_BEXCISE,0) as numeric(20,2)) as INM_BEXCISE,cast(isnull(INM_BE_AMT,0) as numeric(20,2)) as INM_BE_AMT,cast(isnull(INM_EDUC_CESS,0) as numeric(20,2)) as INM_EDUC_CESS,cast(isnull(INM_EDUC_AMT,0) as numeric(20,2)) as INM_EDUC_AMT,cast(isnull(INM_H_EDUC_CESS,0) as numeric(20,2)) as INM_H_EDUC_CESS,cast(isnull(INM_H_EDUC_AMT,0) as numeric(20,2)) as INM_H_EDUC_AMT,cast(isnull(INM_TAXABLE_AMT,0) as numeric(20,2)) as INM_TAXABLE_AMT,cast(isnull(INM_S_TAX,0) as numeric(20,2)) as INM_S_TAX,cast(isnull(INM_S_TAX_AMT,0) as numeric(20,2)) as INM_S_TAX_AMT,cast(isnull(INM_OTHER_AMT,0) as numeric(20,2)) as INM_OTHER_AMT,cast(isnull(INM_FREIGHT,0) as numeric(20,2)) as INM_FREIGHT,cast(isnull(INM_INSURANCE,0) as numeric(20,2)) as INM_INSURANCE,cast(isnull(INM_TRANS_AMT,0) as numeric(20,2)) as INM_TRANS_AMT,cast(isnull(INM_OCTRI_AMT,0) as numeric(20,2)) as INM_OCTRI_AMT,cast(isnull(INM_ROUNDING_AMT,0) as numeric(20,2)) as INM_ROUNDING_AMT,cast(isnull(INM_G_AMT,0) as numeric(20,2)) as INM_G_AMT,cast(isnull(INM_TAX_TCS_AMT,0) as numeric(20,2)) as INM_TAX_TCS_AMT FROM EXCISE_TARIFF_MASTER,CUSTPO_DETAIL,CUSTPO_MASTER,INVOICE_MASTER,INVOICE_DETAIL,ITEM_MASTER,SALES_TAX_MASTER,PARTY_MASTER WHERE INM_CODE = IND_INM_CODE and CPOD_CPOM_CODE = CPOM_CODE and INM_P_CODE = P_CODE AND INM_P_CODE = CPOM_P_CODE and CPOM_CODE = IND_CPOM_CODE AND IND_I_CODE=CPOD_I_CODE and IND_I_CODE = I_CODE and I_E_CODE=E_CODE and IND_I_CODE=CPOD_I_CODE AND CPOD_ST_CODE=ST_CODE and INM_CODE='" + code + "' group by I_CODE,INM_NO,P_CODE,P_NAME,P_ADD1,P_VEND_CODE,P_CST,P_VAT,P_ECC_NO ,INM_DATE,INM_TRANSPORT,INM_LR_NO,INM_LR_DATE,I_NAME,CPOD_CUST_I_CODE,CPOD_CUST_I_NAME ,CPOM_PONO,CPOM_DATE,IND_SUBHEADING,IND_BACHNO,IND_NO_PACK,IND_PAK_QTY,IND_INQTY,IND_RATE ,E_BASIC,E_SPECIAL,E_EDU_CESS,E_H_EDU,INM_VEH_NO,ST_TAX_NAME,ST_SALES_TAX ,E_TARIFF_NO,IND_AMT,INM_NET_AMT,INM_DISC,INM_DISC_AMT,INM_PACK_AMT,INM_ACCESSIBLE_AMT,INM_BEXCISE,INM_BE_AMT,INM_EDUC_CESS,INM_EDUC_AMT,INM_H_EDUC_CESS,INM_H_EDUC_AMT,INM_TAXABLE_AMT,INM_S_TAX,INM_S_TAX_AMT,INM_OTHER_AMT,INM_FREIGHT,INM_INSURANCE,INM_TRANS_AMT,INM_OCTRI_AMT,INM_ROUNDING_AMT,INM_G_AMT,ST_TAX_NAME,INM_TAX_TCS_AMT");
DataTable dtfinal = new DataTable();
if (reportType == "Single")
{
dtfinal = CommonClasses.Execute("SELECT DISTINCT(I_CODE),P_CODE,E_TARIFF_NO,P_NAME,P_ADD1,P_VEND_CODE,P_CST,P_VAT,P_ECC_NO,INM_TNO,INM_NO,INM_DATE,INM_TRANSPORT,INM_VEH_NO,INM_LR_NO,INM_LR_DATE,I_NAME,I_CODENO AS CPOD_CUST_I_CODE,IND_PACK_DESC as CPOD_CUST_I_NAME,CPOM_PONO,ST_TAX_NAME,CPOM_PO_DATE as CPOM_DATE,IND_SUBHEADING,IND_BACHNO,IND_NO_PACK,cast(isnull(IND_PAK_QTY,0) as numeric(20,3)) as IND_PAK_QTY,cast(isnull(IND_INQTY,0) as numeric(20,3)) as IND_INQTY,cast(isnull(IND_RATE,0) as numeric(20,2)) as IND_RATE,cast(isnull(IND_AMT,0) as numeric(20,2)) as IND_AMT,cast(isnull(INM_NET_AMT,0) as numeric(20,2)) as INM_NET_AMT,cast(isnull(INM_DISC,0) as numeric(20,2)) as INM_DISC,cast(isnull(INM_DISC_AMT,0) as numeric(20,2)) as INM_DISC_AMT,cast(isnull(INM_PACK_AMT,0) as numeric(20,2)) as INM_PACK_AMT,cast(isnull(INM_ACCESSIBLE_AMT,0) as numeric(20,2)) as INM_ACCESSIBLE_AMT,(case when P_SM_CODE=CM_STATE then EXCISE_TARIFF_MASTER.E_BASIC else 0 end) as INM_BEXCISE,cast(isnull(INM_BE_AMT,0) as numeric(20,2)) as INM_BE_AMT,(case when P_SM_CODE=CM_STATE then EXCISE_TARIFF_MASTER.E_EDU_CESS else 0 end) as INM_EDUC_CESS,cast(isnull(INM_EDUC_AMT,0) as numeric(20,2)) as INM_EDUC_AMT,(case when P_SM_CODE<>CM_STATE then EXCISE_TARIFF_MASTER.E_H_EDU else 0 end) as INM_H_EDUC_CESS,cast(isnull(INM_H_EDUC_AMT,0) as numeric(20,2)) as INM_H_EDUC_AMT,cast(isnull(INM_TAXABLE_AMT,0) as numeric(20,2)) as INM_TAXABLE_AMT,cast(isnull(INM_S_TAX,0) as numeric(20,2)) as INM_S_TAX,cast(isnull(INM_S_TAX_AMT,0) as numeric(20,2)) as INM_S_TAX_AMT,cast(isnull(INM_OTHER_AMT,0) as numeric(20,2)) as INM_OTHER_AMT,cast(isnull(INM_FREIGHT,0) as numeric(20,2)) as INM_FREIGHT,cast(isnull(INM_INSURANCE,0) as numeric(20,2)) as INM_INSURANCE,cast(isnull(INM_TRANS_AMT,0) as numeric(20,2)) as INM_TRANS_AMT,cast(isnull(INM_OCTRI_AMT,0) as numeric(20,2)) as INM_OCTRI_AMT,cast(isnull(INM_ROUNDING_AMT,0) as numeric(20,2)) as INM_ROUNDING_AMT,cast(isnull(INM_G_AMT,0) as numeric(20,2)) as INM_G_AMT,cast(isnull(INM_TAX_TCS_AMT,0) as numeric(20,2)) as INM_TAX_TCS_AMT,INM_ISSUE_DATE,INM_REMOVAL_DATE,INM_ISSU_TIME,INM_REMOVEL_TIME,EXCISE_TARIFF_MASTER.E_COMMODITY,ITEM_UNIT_MASTER.I_UOM_NAME,INM_TAX_TCS,ISNULL(IND_AMORTAMT,0) AS IND_AMORTAMT, ISNULL(IND_AMORTRATE,0) AS IND_AMORTRATE,isnull(INM_ADDRESS_SELECTED,0) as INM_ADDRESS_SELECTED FROM EXCISE_TARIFF_MASTER,CUSTPO_DETAIL,CUSTPO_MASTER,INVOICE_MASTER,INVOICE_DETAIL,ITEM_MASTER,SALES_TAX_MASTER,PARTY_MASTER,ITEM_UNIT_MASTER WHERE INM_CODE = IND_INM_CODE and CPOD_CPOM_CODE = CPOM_CODE and INM_P_CODE = P_CODE AND INM_P_CODE = CPOM_P_CODE and CPOM_CODE = IND_CPOM_CODE AND IND_I_CODE=CPOD_I_CODE and IND_I_CODE = I_CODE and I_E_CODE=E_CODE and IND_I_CODE=CPOD_I_CODE AND CPOD_ST_CODE=ST_CODE and INM_CODE='" + code + "' AND INM_TYPE='OutJWINM' and ITEM_UNIT_MASTER.I_UOM_CODE=ITEM_MASTER.I_UOM_CODE and INM_ADDRESS_SELECTED=" + Request.QueryString[3].ToString() + "");
}
else
{
dtfinal = CommonClasses.Execute("SELECT DISTINCT(I_CODE),P_CODE,E_TARIFF_NO,P_NAME,P_ADD1,P_VEND_CODE,P_CST,P_VAT,P_ECC_NO,INM_TNO,INM_NO,INM_DATE,INM_TRANSPORT,INM_VEH_NO,INM_LR_NO,INM_LR_DATE,I_NAME, I_CODENO AS CPOD_CUST_I_CODE,IND_PACK_DESC as CPOD_CUST_I_NAME,CPOM_PONO,ST_TAX_NAME,CPOM_PO_DATE as CPOM_DATE,IND_SUBHEADING,IND_BACHNO,IND_NO_PACK,cast(isnull(IND_PAK_QTY,0) as numeric(20,3)) as IND_PAK_QTY,cast(isnull(IND_INQTY,0) as numeric(20,3)) as IND_INQTY,cast(isnull(IND_RATE,0) as numeric(20,2)) as IND_RATE,cast(isnull(IND_AMT,0) as numeric(20,2)) as IND_AMT,cast(isnull(INM_NET_AMT,0) as numeric(20,2)) as INM_NET_AMT,cast(isnull(INM_DISC,0) as numeric(20,2)) as INM_DISC,cast(isnull(INM_DISC_AMT,0) as numeric(20,2)) as INM_DISC_AMT,cast(isnull(INM_PACK_AMT,0) as numeric(20,2)) as INM_PACK_AMT,cast(isnull(INM_ACCESSIBLE_AMT,0) as numeric(20,2)) as INM_ACCESSIBLE_AMT,(case when P_SM_CODE=CM_STATE then EXCISE_TARIFF_MASTER.E_BASIC else 0 end) as INM_BEXCISE,cast(isnull(INM_BE_AMT,0) as numeric(20,2)) as INM_BE_AMT,(case when P_SM_CODE=CM_STATE then EXCISE_TARIFF_MASTER.E_EDU_CESS else 0 end) as INM_EDUC_CESS,cast(isnull(INM_EDUC_AMT,0) as numeric(20,2)) as INM_EDUC_AMT,(case when P_SM_CODE<>CM_STATE then EXCISE_TARIFF_MASTER.E_H_EDU else 0 end) as INM_H_EDUC_CESS,cast(isnull(INM_H_EDUC_AMT,0) as numeric(20,2)) as INM_H_EDUC_AMT,cast(isnull(INM_TAXABLE_AMT,0) as numeric(20,2)) as INM_TAXABLE_AMT,cast(isnull(INM_S_TAX,0) as numeric(20,2)) as INM_S_TAX,cast(isnull(INM_S_TAX_AMT,0) as numeric(20,2)) as INM_S_TAX_AMT,cast(isnull(INM_OTHER_AMT,0) as numeric(20,2)) as INM_OTHER_AMT,cast(isnull(INM_FREIGHT,0) as numeric(20,2)) as INM_FREIGHT,cast(isnull(INM_INSURANCE,0) as numeric(20,2)) as INM_INSURANCE,cast(isnull(INM_TRANS_AMT,0) as numeric(20,2)) as INM_TRANS_AMT,cast(isnull(INM_OCTRI_AMT,0) as numeric(20,2)) as INM_OCTRI_AMT,cast(isnull(INM_ROUNDING_AMT,0) as numeric(20,2)) as INM_ROUNDING_AMT,cast(isnull(INM_G_AMT,0) as numeric(20,2)) as INM_G_AMT,cast(isnull(INM_TAX_TCS_AMT,0) as numeric(20,2)) as INM_TAX_TCS_AMT,INM_ISSUE_DATE,INM_REMOVAL_DATE,INM_ISSU_TIME,INM_REMOVEL_TIME,EXCISE_TARIFF_MASTER.E_COMMODITY,ITEM_UNIT_MASTER.I_UOM_NAME,INM_TAX_TCS,ISNULL(IND_AMORTAMT,0) AS IND_AMORTAMT, ISNULL(IND_AMORTRATE,0) AS IND_AMORTRATE,0 AS [HSN_NO] ,INM_ELECTRREFNUM,'' as INM_ADDRESS,'' as INM_STATE ,ISNULL(P_LBT_NO,'') AS P_GST_NO ,ISNULL( IND_EX_AMT,0) AS IND_EX_AMT,ISNULL(IND_E_CESS_AMT,0) AS IND_E_CESS_AMT,ISNULL(IND_SH_CESS_AMT,0) AS IND_SH_CESS_AMT ,INM_CODE,P_VEND_CODE,SM_NAME,SM_STATE_CODE,IND_HSN_CODE AS IND_E_TARIFF_NO,isnull(INM_ADDRESS_SELECTED,0) as INM_ADDRESS_SELECTED FROM EXCISE_TARIFF_MASTER,CUSTPO_DETAIL,CUSTPO_MASTER,INVOICE_MASTER,INVOICE_DETAIL,ITEM_MASTER,SALES_TAX_MASTER,COMPANY_MASTER,PARTY_MASTER,ITEM_UNIT_MASTER,STATE_MASTER WHERE INM_CM_CODE = COMPANY_MASTER.CM_CODE and INM_CODE = IND_INM_CODE and CPOD_CPOM_CODE = CPOM_CODE and INM_P_CODE = P_CODE AND INM_P_CODE = CPOM_P_CODE and CPOM_CODE = IND_CPOM_CODE AND IND_I_CODE=CPOD_I_CODE and IND_I_CODE = I_CODE and I_SCAT_CODE=E_CODE and IND_I_CODE=CPOD_I_CODE AND CPOD_ST_CODE=ST_CODE and ITEM_UNIT_MASTER.I_UOM_CODE=ITEM_MASTER.I_UOM_CODE AND INVOICE_MASTER.ES_DELETE=0 AND INM_TYPE='OutJWINM' AND P_SM_CODE=SM_CODE and INM_NO BETWEEN '" + invoice_code + "' AND '" + reportType + "' and INM_ADDRESS_SELECTED=" + Request.QueryString[3].ToString() + "");
}
DataTable dtCompGSTNo = CommonClasses.Execute("SELECT CM_GST_NO,SM_NAME,CM_NAME,CM_ADDRESS1,CM_ADDRESS2 FROM COMPANY_MASTER,STATE_MASTER where SM_CODE=CM_STATE AND CM_ID=" + Session["CompanyId"].ToString() + "");
if (dtfinal.Rows.Count > 0)
{
ReportDocument rptname = null;
rptname = new ReportDocument();
if (type == "1")
{
rptname.Load(Server.MapPath("~/Reports/rptTaxInvoice.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptTaxInvoice.rpt");
rptname.Refresh();
rptname.SetDataSource(dtfinal);
rptname.SetParameterValue("txtCompPhone", Session["CompanyPhone"].ToString());
rptname.SetParameterValue("txtCompFaxNo", Session["Companyfax"].ToString());
rptname.SetParameterValue("txtCompVatTin", Session["CompanyVatTin"].ToString());
rptname.SetParameterValue("txtCompCstTin", Session["CompanyCstTin"].ToString());
rptname.SetParameterValue("txtCompEcc", Session["CompanyEccNo"].ToString());
rptname.SetParameterValue("txtCompVatWef", Convert.ToDateTime(Session["CompanyVatWef"].ToString()).ToShortDateString());
rptname.SetParameterValue("txtCompCstWef", Convert.ToDateTime(Session["CompanyCstWef"].ToString()).ToShortDateString());
rptname.SetParameterValue("txtCompIso", Session["CompanyIso"].ToString());
rptname.SetParameterValue("txtCompRegd", Session["CompanyRegd"].ToString());
rptname.SetParameterValue("txtCompWebsite", Session["CompanyWebsite"].ToString());
rptname.SetParameterValue("txtCompEmail", Session["CompanyEmail"].ToString());
rptname.SetParameterValue("txtCompFinancialYr", Session["CompanyFinancialYr"].ToString());
//string IsoNo = DL_DBAccess.GetColumn("select ISO_NO from ISONO_MASTER,INVOICE_MASTER where INM_CODE='" + code + "' and ISO_SCREEN_NO=81 and INM_DATE<=ISO_WEF_DATE and INM_DATE>=ISO_WEF_DATE");
string CINNo = DL_DBAccess.GetColumn("select CM_CIN_NO from COMPANY_MASTER where CM_ID='" + Session["CompanyId"] + "'");
rptname.SetParameterValue("txtCINNo", CINNo);
}
else
{
DataTable dtTaxInvoiceGST = new DataTable();
dtTaxInvoiceGST = dtfinal;
DataTable dtTemp = new DataTable();
DataSet dsTaxInvoiceGST = new DataSet();
dtTemp.Columns.Add("INM_CODE", typeof(int));
dtTemp.Columns.Add("INM_NO", typeof(int));
dtTemp.Columns.Add("INM_NAME", typeof(string));
dtTemp.Columns.Add("INM_SEQNO", typeof(int));
DataRow dr = dtTemp.NewRow();
dr["INM_CODE"] = code;
dr["INM_NO"] = 1;
dr["INM_NAME"] = "Original For Recipient";
dr["INM_SEQNO"] = 1;
dtTemp.Rows.Add(dr);
dr = dtTemp.NewRow();
dr["INM_CODE"] = code;
dr["INM_NO"] = 1;
dr["INM_NAME"] = "Duplicate For Transporter";
dr["INM_SEQNO"] = 2;
dtTemp.Rows.Add(dr);
dr = dtTemp.NewRow();
dr["INM_CODE"] = code;
dr["INM_NO"] = 1;
dr["INM_NAME"] = "Triplicate for Supplier";
dr["INM_SEQNO"] = 3;
dtTemp.Rows.Add(dr);
dr = dtTemp.NewRow();
dr["INM_CODE"] = code;
dr["INM_NO"] = 1;
dr["INM_NAME"] = "Quaradruplicate";
dr["INM_SEQNO"] = 4;
dtTemp.Rows.Add(dr);
dsTaxInvoiceGST.Tables.Add(dtTaxInvoiceGST);
dsTaxInvoiceGST.Tables[0].TableName = "dtTaxInvoiceGST";
DataTable dta = new DataTable();
dta = (DataTable)dtTemp;
dsTaxInvoiceGST.Tables.Add(dta);
dsTaxInvoiceGST.Tables[1].TableName = "NoOfCopyTaxInvoice";
rptname.Load(Server.MapPath("~/Reports/rptTaxInvoiceGSTLabour.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptTaxInvoiceGSTLabour.rpt");
rptname.SetDataSource(dsTaxInvoiceGST);
rptname.SetParameterValue("txtCompName", dtCompGSTNo.Rows[0]["CM_NAME"].ToString());
if (dtfinal.Rows[0]["INM_ADDRESS_SELECTED"].ToString() == "1")
{
rptname.SetParameterValue("txtCompAdd", dtCompGSTNo.Rows[0]["CM_ADDRESS2"].ToString());
}
else
{
rptname.SetParameterValue("txtCompAdd", dtCompGSTNo.Rows[0]["CM_ADDRESS1"].ToString());
}
rptname.SetParameterValue("txtCompGSTNo", dtCompGSTNo.Rows[0]["CM_GST_NO"].ToString());
rptname.SetParameterValue("txtCompCity", dtCompGSTNo.Rows[0]["SM_NAME"].ToString());
}
CrystalReportViewer1.ReportSource = rptname;
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Tax Invoice", "GenerateReport", Ex.Message);
}
}
private void GenerateReport(string Title, string chkdate, string chkComp, string From, string To, string i_name)
{
DL_DBAccess = new DatabaseAccessLayer();
string Query = "";
//Query = "SELECT Distinct CPOM_DOC_NO,ITEM_MASTER.I_CODENO,ITEM_MASTER.I_NAME,ITEM_UNIT_MASTER.I_UOM_NAME,CPOM_PONO,CPOM_DATE,CPOD_ORD_QTY,CPOD_RATE,CPOD_DISPACH,CPOM_PO_DATE FROM PARTY_MASTER ,CUSTPO_MASTER,CUSTPO_DETAIL,ITEM_MASTER ,ITEM_UNIT_MASTER WHERE CPOM_CODE = CPOD_CPOM_CODE AND P_CODE = CPOM_P_CODE AND CPOD_I_CODE = I_CODE AND ITEM_UNIT_MASTER.I_UOM_CODE=CUSTPO_DETAIL.CPOD_UOM_CODE and CUSTPO_MASTER.ES_DELETE=0 ";
Query = "SELECT Distinct P_NAME,ITEM_MASTER.I_CODENO,ITEM_MASTER.I_NAME,CPOM_PONO,CPOM_DATE,CPOD_ORD_QTY,CPOD_DISPACH,CPOM_PO_DATE FROM PARTY_MASTER ,CUSTPO_MASTER,CUSTPO_DETAIL,ITEM_MASTER WHERE CPOM_CODE = CPOD_CPOM_CODE AND P_CODE = CPOM_P_CODE AND CPOD_I_CODE = I_CODE and CUSTPO_MASTER.ES_DELETE=0 ";
if (chkdate == "All" && chkComp == "All")
{
Query = Query;
}
if (chkdate != "All" && chkComp == "All")
{
Query = Query + " and CPOM_DATE between '" + Convert.ToDateTime(From).ToString("dd/MMM/yyyy") + "' and '" + Convert.ToDateTime(To).ToString("dd/MMM/yyyy") + "'";
}
if (chkdate == "All" && chkComp != "All")
{
Query = Query + " and CPOM_P_CODE='" + i_name + "' ";
}
if (chkdate != "All" && chkComp != "All")
{
Query = Query + " and CPOM_DATE between '" + Convert.ToDateTime(From).ToString("dd/MMM/yyyy") + "' and '" + Convert.ToDateTime(To).ToString("dd/MMM/yyyy") + "' and CPOM_P_CODE='" + i_name + "' ";
}
DataSet ds = new DataSet();
DataTable dt = new DataTable();
dt = CommonClasses.Execute(Query);
if (dt.Rows.Count > 0)
{
ReportDocument rptname = null;
rptname = new ReportDocument();
rptname.Load(Server.MapPath("~/Reports/rptSalesOrderPendingStatus.rpt"));
rptname.FileName = Server.MapPath("~/Reports/rptSalesOrderPendingStatus.rpt");
rptname.Refresh();
//rptname.SetParameterValue("txtName", Session["CompanyName"].ToString());
rptname.SetDataSource(dt);
rptname.SetParameterValue("txtCompName", Session["CompanyName"].ToString());
rptname.SetParameterValue("txtPeriod", " From " + Convert.ToDateTime(From).ToString("dd/MMM/yyyy") + " To " + Convert.ToDateTime(To).ToString("dd/MMM/yyyy"));
string IsoNo = DL_DBAccess.GetColumn("select ISO_NO from ISONO_MASTER where ISO_SCREEN_NO=90 and ISO_WEF_DATE<='" + Convert.ToDateTime(To).ToString("dd/MMM/yyyy") + "' order by ISO_WEF_DATE DESC");
string CustName = "";
CustName = DL_DBAccess.GetColumn("select P_NAME from PARTY_MASTER where P_CODE='" + i_name + "'");
if (IsoNo == "")
{
rptname.SetParameterValue("txtIsoNo", "1");
}
else
{
rptname.SetParameterValue("txtIsoNo", IsoNo);
}
if (CustName == "")
{
rptname.SetParameterValue("txtCustName", "1");
}
else
{
rptname.SetParameterValue("txtCustName", CustName);
}
CrystalReportViewer1.ReportSource = rptname;
}
else
{
PanelMsg.Visible = true;
lblmsg.Text = "Record Not Found";
return;
}
}
protected void dgCustomerEnquiry_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName.Equals("View"))
{
if (CommonClasses.ValidRights(int.Parse(right.Substring(1, 1)), this, "For View"))
{
string type = "VIEW";
string ce_code = e.CommandArgument.ToString();
Response.Redirect("~/Transactions/ADD/CustomerEnquiry.aspx?c_name=" + type + "&ce_code=" + ce_code, false);
}
else
{
PanelMsg.Visible = true;
lblmsg.Text = "You have no rights to view";
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true);
// ShowMessage("#Avisos", "You Have No Rights To View", CommonClasses.MSG_Erro);
return;
}
}
if (e.CommandName.Equals("Modify"))
{
if (CommonClasses.ValidRights(int.Parse(right.Substring(2, 1)), this, "For Modify"))
{
if (!ModifyLog(e.CommandArgument.ToString()))
{
string type = "MODIFY";
string ce_code = e.CommandArgument.ToString();
DataTable dtcheck = CommonClasses.Execute("select INQ_CODE,INQ_QT_FLAG from ENQUIRY_MASTER where INQ_CODE=" + ce_code + "");
if (dtcheck.Rows[0]["INQ_QT_FLAG"].ToString() == "True")
{
PanelMsg.Visible = true;
lblmsg.Text = "Perticular Enquiry is used In Sale Order, can't modify the record";
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true);
//ShowMessage("#Avisos", "Perticular Enquiry is used In quotation, can't modify the record", CommonClasses.MSG_Erro);
}
else
{
Response.Redirect("~/Transactions/ADD/CustomerEnquiry.aspx?c_name=" + type + "&ce_code=" + ce_code, false);
}
}
else
{
PanelMsg.Visible = true;
lblmsg.Text = "Record used by another person";
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true);
// ShowMessage("#Avisos", "Record Used By Another Person", CommonClasses.MSG_Erro);
return;
}
}
else
{
PanelMsg.Visible = true;
lblmsg.Text = "You have no rights to modify";
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true);
//ShowMessage("#Avisos", "You Have No Rights To Modify", CommonClasses.MSG_Erro);
return;
}
}
if (e.CommandName.Equals("Print"))
{
if (CommonClasses.ValidRights(int.Parse(right.Substring(5, 1)), this, "For Print"))
{
//string type = "MODIFY";
string cpom_code = e.CommandArgument.ToString();
Response.Redirect("~/RoportForms/ADD/CustomerEnquiryPrint.aspx?cpom_code=" + cpom_code, false);
}
else
{
lblmsg.Text = "You have no rights to print";
PanelMsg.Visible = true;
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true);
return;
}
}
if (e.CommandName.Equals("Convert"))
{
string cpom_code = e.CommandArgument.ToString();
string Sale = databaseaccess.GetColumn("select isnull(INQ_QT_FLAG,0) as INQ_QT_FLAG from ENQUIRY_MASTER where INQ_CODE='" + cpom_code + "'");
if (!Convert.ToBoolean(Sale))
{
string type = "ConvertToOrder";
Response.Redirect("~/Transactions/ADD/CustomerPO.aspx?c_name=" + type + "&cpom_code=" + cpom_code, false);
}
else
{
lblmsg.Text = "Allready Create Sale Order";
PanelMsg.Visible = true;
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true);
return;
}
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Customer Enquiry - View", "dgCustomerEnquiry_RowCommand", Ex.Message);
}
}
