protected void btnUpdate_Click(object sender, EventArgs e)
{
DataTable dtHMR = new DataTable();
string strHMRQuery = "select * from HMR";
dtHMR = objQueryController.ExecuteQuery(strHMRQuery);
DataTable dtProdMonth = new DataTable();
string strProdMonthQuery = "select * from ProductionMonth";
dtProdMonth = objQueryController.ExecuteQuery(strProdMonthQuery);
DataTable dtView = new DataTable();
string strViewQuery = "Select distinct * from vwMastersCode";
dtView = objQueryController.ExecuteQuery(strViewQuery);
DataTable dtModel = new DataTable();
string strModelQuery = "select * from Model";
dtModel = objQueryController.ExecuteQuery(strModelQuery);
AcrController objCont = new AcrController();
int rcount = 0;
foreach (GridViewRow gr in grdAcrException.Rows)
{
bool Discard = ((CheckBox)gr.FindControl("chkDiscard")).Checked;
string str = ((HiddenField)gr.FindControl("hdnID")).Value;
if (Discard == true)
{
string strDiscardQuery = "Delete from AcrTemp where ID=" + Convert.ToInt64(str);
objQueryController.ExecuteQuery(strDiscardQuery);
string strQuery = "Select [WCDOCNO],[DLR_REF],[TRACTOR NO],[ENGINE NO], [INS DATE],[DEF DATE],[REP DATE],[HMR],[DLR CO],[DEALER NAME],[REG],[CR DATE],[ITEM CODE],[DESCRIPTION],[QTY],[COST],[DEF],[NDP],[VALUE],[CVOICE],[OUTLV],[DT],[CUL CODE],[F24],[CR-AMOUNT],[ AUTH AMT] as Auth_Amt,[ DIFF] as Diff,[Production_Month],[Model_Code],[HMR_Range],[Production_Month_Year],[IsApproved],[ID],FromDate,ToDate,Cause,IsItemEx,IsDefectEx,IsModelEx,IsCulpritEx,IsCVoiceEx,Engine,IsEngine from acrtemp where model_code='' or [cul code]='' or def='' or Cvoice='' or [item code]=''";
DataTable dt = new DataTable();
dt = objQueryController.ExecuteQuery(strQuery);
grdAcrException.DataSource = dt;
grdAcrException.DataBind();
}
else
{
string strCause = "item;culprit;cvoice;defect;model";
AcrUI objUI = new AcrUI();
int CurrentYearID = 0;
int CurrentMonthID = 0;
string strQuarterYear = "";
try
{
objUI.WCDOCNO = Convert.ToDecimal(((TextBox)gr.FindControl("txtWCDOCNO")).Text);
objUI.DLR_REF = Convert.ToString(((TextBox)gr.FindControl("txtDlrRef")).Text);
objUI.TRACTOR_NO = Convert.ToInt64(((TextBox)gr.FindControl("txtTractorNo")).Text);
objUI.ENGINE_NO = Convert.ToString(((TextBox)gr.FindControl("txtEngineNo")).Text);
string strInsdate = ((TextBox)gr.FindControl("txtINSDATE")).Text;
if (strInsdate == "" || strInsdate == "00.00.0000")
objUI.INS_DATE = Convert.ToDateTime("1/1/2001");
else
objUI.INS_DATE = Convert.ToDateTime(ConvertDateTime(((TextBox)gr.FindControl("txtINSDATE")).Text));
if (((TextBox)gr.FindControl("txtDEFDATE")).Text == "" || ((TextBox)gr.FindControl("txtDEFDATE")).Text == "00.00.0000")
objUI.DEF_DATE = Convert.ToDateTime("1/1/2001");
else
objUI.DEF_DATE = Convert.ToDateTime(ConvertDateTime(((TextBox)gr.FindControl("txtDEFDATE")).Text));
if (((TextBox)gr.FindControl("txtREPDATE")).Text == "" || ((TextBox)gr.FindControl("txtREPDATE")).Text == "00.00.0000")
objUI.REP_DATE = Convert.ToDateTime("1/1/2001");
else
objUI.REP_DATE = Convert.ToDateTime(ConvertDateTime(((TextBox)gr.FindControl("txtREPDATE")).Text));
objUI.HMR = Convert.ToInt16(((TextBox)gr.FindControl("txtHMR")).Text);
objUI.DLR_CO = Convert.ToString(((TextBox)gr.FindControl("txtDealerCode")).Text);
objUI.DEALER_NAME = Convert.ToString(((TextBox)gr.FindControl("txtDealerName")).Text);
objUI.REG = Convert.ToString(((TextBox)gr.FindControl("txtREG")).Text);
//objUI.CR_DATE = Convert.ToDateTime(((TextBox)gr.FindControl("txtCRDATE")).Text);
if (((TextBox)gr.FindControl("txtCRDATE")).Text == "" || ((TextBox)gr.FindControl("txtCRDATE")).Text == "00.00.0000")
objUI.CR_DATE = Convert.ToDateTime("1/1/2001");
else
objUI.CR_DATE = Convert.ToDateTime(ConvertDateTime(((TextBox)gr.FindControl("txtCRDATE")).Text));
objUI.DESCRIPTION = Convert.ToString(((TextBox)gr.FindControl("txtDescription")).Text);
objUI.QUANTITY = Convert.ToInt16(((TextBox)gr.FindControl("txtQuantity")).Text);
objUI.COST = Convert.ToString(((TextBox)gr.FindControl("txtCost")).Text);
objUI.NDP = Convert.ToDecimal(((TextBox)gr.FindControl("txtNDP")).Text);
objUI.VALUE = Convert.ToDecimal(((TextBox)gr.FindControl("txtVALUE")).Text);
objUI.OUTLV = Convert.ToDecimal(((TextBox)gr.FindControl("txtOUTLV")).Text);
objUI.DT = Convert.ToString(((TextBox)gr.FindControl("txtDT")).Text);
string strBlank = Convert.ToString(((TextBox)gr.FindControl("txtBlank")).Text);
if (strBlank == "")
{
objUI.BLANK = Convert.ToDouble(null);
}
else
{
objUI.BLANK = Convert.ToDouble(((TextBox)gr.FindControl("txtBlank")).Text);
}
string strCR_AMOUNT = Convert.ToString(((TextBox)gr.FindControl("txtCRAMT")).Text);
if (strCR_AMOUNT == "")
{
objUI.CR_AMOUNT = Convert.ToDouble(null);
}
else
{
objUI.CR_AMOUNT = Convert.ToDouble(((TextBox)gr.FindControl("txtCRAMT")).Text);
}
string strAUTH_AMOUNT = Convert.ToString(((TextBox)gr.FindControl("txtAUTHAMT")).Text);
if (strAUTH_AMOUNT == "")
{
objUI.AUTH_AMOUNT = Convert.ToDouble(null);
}
else
{
objUI.AUTH_AMOUNT = Convert.ToDouble(((TextBox)gr.FindControl("txtAUTHAMT")).Text);
}
string strDIFF = Convert.ToString(((TextBox)gr.FindControl("txtDIFF")).Text);
if (strDIFF == "")
{
objUI.DIFF = Convert.ToDouble(null);
}
else
{
objUI.DIFF = Convert.ToDouble(((TextBox)gr.FindControl("txtDIFF")).Text);
}
try
{
int HMR = Convert.ToInt16(((TextBox)gr.FindControl("txtHMR")).Text);
foreach (DataRow drHMR in dtHMR.Rows)
{
int MinHMR = Convert.ToInt16(drHMR["Min_Value"]); //Get the minimum HMR value from HMR Table
int MaxHMR = Convert.ToInt16(drHMR["Max_Value"]); //Get the maximum HMR value from HMR Table
if (HMR >= MinHMR && HMR <= MaxHMR) //Check HMR Range
{
objUI.HMR_Range = Convert.ToString(drHMR["HMR_Range"]);
}
}
}
catch { }
string strTractorNo = Convert.ToString(((TextBox)gr.FindControl("txtTractorNo")).Text);
int tractornoLength = strTractorNo.Length;
string ProductionMonth = "";
string ModelCode = "0";
if (tractornoLength == 11) //If Tractor No Length is 11
{
ProductionMonth = strTractorNo.Substring(1, 2); // 2nd and 3rd digit is Production Month
ModelCode = strTractorNo.Substring(3, 3); // The next 3 digits i.e. 4th, 5th and 6th digits is Model Code
}
else if (tractornoLength == 12) //If Tractor No Length is 12
{
ProductionMonth = strTractorNo.Substring(1, 3); // 2nd to 4th digit is Production Month
ModelCode = strTractorNo.Substring(4, 3); // The next 3 digits i.e. 5th, 6th and 7th digits is Model Code
}
//DataView dv = new DataView(dtModel);
//dv.RowFilter = "Code =" + Convert.ToInt16(ModelCode);
//DataTable dtModelCode = dv.ToTable();
objUI.Production_Month = Convert.ToInt16(ProductionMonth);
objUI.Model_Code = Convert.ToString(ModelCode);
//Convert.ToString(dtModelCode.Rows[0]["Model_Code"]);
if (ProductionMonth != "")
{
int BaseProductionMonth = Convert.ToInt16(dtProdMonth.Rows[0]["BaseProductionMonth_Code"]);
int BaseMonthID = Convert.ToInt16(dtProdMonth.Rows[0]["Month_ID"]);
int BaseYearID = Convert.ToInt16(dtProdMonth.Rows[0]["Year_ID"]);
string strBaseDate = Convert.ToString(BaseMonthID) + "/1/" + BaseYearID;
DateTime BaseDate = Convert.ToDateTime(strBaseDate);
int Offset = Convert.ToInt16(ProductionMonth) - BaseProductionMonth;
DateTime ProdMonthYear = BaseDate.AddMonths(Offset);
CurrentYearID = ProdMonthYear.Year;
CurrentMonthID = ProdMonthYear.Month;
string strCurrentYearID = (Convert.ToString(CurrentYearID)).Substring(2,2);
string strMonth = getMonth(CurrentMonthID);
string strProductionMonthYear = strMonth + "-" + strCurrentYearID;
objUI.MonthID = CurrentMonthID;
objUI.YearID = CurrentYearID;
string strQuarter = "";
if (CurrentMonthID == 4 || CurrentMonthID == 5 || CurrentMonthID == 6)
{
strQuarter = "Q1";
}
else if (CurrentMonthID == 7 || CurrentMonthID == 8 || CurrentMonthID == 9)
{
strQuarter = "Q2";
}
else if (CurrentMonthID == 10 || CurrentMonthID == 11 || CurrentMonthID == 12)
{
strQuarter = "Q3";
}
else if (CurrentMonthID == 1 || CurrentMonthID == 2 || CurrentMonthID == 3)
{
strQuarter = "Q4";
}
if (CurrentMonthID < 4)
{
string strPreviousYearID = (Convert.ToString(CurrentYearID - 1)).Substring(2, 2);
strCurrentYearID = strCurrentYearID.Replace("0", "");
strQuarterYear = strPreviousYearID + strCurrentYearID + strQuarter;
}
else
{
string strNextYearID = (Convert.ToString(CurrentYearID + 1)).Substring(2, 2);
strNextYearID = strNextYearID.Replace("0", "");
strQuarterYear = strCurrentYearID + strNextYearID + strQuarter;
}
objUI.Quarter = strQuarterYear;
objUI.Production_Month_Year = strProductionMonthYear;
}
objUI.FromDate = Convert.ToDateTime(((Label)gr.FindControl("lblFromDate")).Text);
objUI.ToDate = Convert.ToDateTime(((Label)gr.FindControl("lblToDate")).Text);
objUI.Engine = Convert.ToString(((HiddenField)gr.FindControl("hdnEngine")).Value);
objUI.IsEngine = Convert.ToInt16(((HiddenField)gr.FindControl("hdnIsEngine")).Value);
int flag = 0;
for (int i = 0; i < dtView.Rows.Count; i++)
{
if ("item" == dtView.Rows[i]["tablename"].ToString() && ((TextBox)gr.FindControl("txtItemCode")).Text == dtView.Rows[i]["code"].ToString())
{
objUI.ITEM_CODE = Convert.ToString(((TextBox)gr.FindControl("txtItemCode")).Text);
strCause = strCause.Replace("item", "");
flag++;
}
if ("culprit" == dtView.Rows[i]["tablename"].ToString() && ((TextBox)gr.FindControl("txtCulCode")).Text == dtView.Rows[i]["code"].ToString())
{
string strCUL_CODE = Convert.ToString(((TextBox)gr.FindControl("txtCulCode")).Text);
if (strCUL_CODE == "")
{
objUI.CUL_CODE = Convert.ToInt32(null);
}
else
{
objUI.CUL_CODE = Convert.ToInt32(((TextBox)gr.FindControl("txtCulCode")).Text);
}
strCause = strCause.Replace(";culprit", "");
flag++;
}
if ("customervoice" == dtView.Rows[i]["tablename"].ToString() && ((TextBox)gr.FindControl("txtCVOICE")).Text == dtView.Rows[i]["code"].ToString())
{
string strCVOICE = Convert.ToString(((TextBox)gr.FindControl("txtCVOICE")).Text);
if (strCVOICE == "")
{
objUI.CVOICE = Convert.ToInt16(null);
}
else
{
objUI.CVOICE = Convert.ToInt16(((TextBox)gr.FindControl("txtCVOICE")).Text);
}
strCause = strCause.Replace(";cvoice", "");
flag++;
}
if ("defect" == dtView.Rows[i]["tablename"].ToString() && ((TextBox)gr.FindControl("txtDEF")).Text == dtView.Rows[i]["code"].ToString())
{
string strDEF = Convert.ToString(((TextBox)gr.FindControl("txtDEF")).Text);
if (strDEF == "")
{
objUI.DEF = Convert.ToInt16(null);
}
else
{
objUI.DEF = Convert.ToInt16(((TextBox)gr.FindControl("txtDEF")).Text);
}
strCause = strCause.Replace(";defect", "");
flag++;
}
if ("model" == dtView.Rows[i]["tablename"].ToString() && Convert.ToString(ModelCode) == dtView.Rows[i]["code"].ToString())
{
DataView dv = new DataView(dtModel);
dv.RowFilter = "Code ='" + Convert.ToString(ModelCode) + "'";
DataTable dtModelCode = dv.ToTable();
objUI.Model_Code = Convert.ToString(dtModelCode.Rows[0]["Model_Code"]);
strCause = strCause.Replace(";model", "");
flag++;
}
}
if (flag == 5)
{
objCont.SaveAcr(objUI);
rcount++;
}
else
{
int index = strCause.IndexOf(';');
if (index == 0)
{
strCause = strCause.Remove(0, 1);
}
string strEngine = ((HiddenField)gr.FindControl("hdnEngine")).Value;
string strIsEngine = Convert.ToString(((HiddenField)gr.FindControl("hdnIsEngine")).Value);
int IsEngine = 0;
if (strIsEngine == "False")
{
IsEngine = 0;
}
else
{
IsEngine = 1;
}
string strDescription = ((TextBox)gr.FindControl("txtDescription")).Text.Replace("'", "");
string strQuery = "Insert into AcrTemp ([WCDOCNO],[DLR_REF],[TRACTOR NO],[ENGINE NO],[INS DATE],[DEF DATE],[REP DATE],[HMR],[DLR CO],[DEALER NAME],[REG],[CR DATE],[ITEM CODE],[DESCRIPTION],[QTY],[COST],[DEF],[NDP],[VALUE],[CVOICE],[OUTLV],[DT],[CUL CODE],[F24],[CR-AMOUNT],[ AUTH AMT],[ DIFF],FromDate,ToDate,MonthID,YearID,Quarter,Engine,IsEngine) ";
strQuery += "Values ('" + ((TextBox)gr.FindControl("txtWCDOCNO")).Text + "','" + ((TextBox)gr.FindControl("txtDlrRef")).Text + "','" + ((TextBox)gr.FindControl("txtTractorNo")).Text + "','" + ((TextBox)gr.FindControl("txtEngineNo")).Text + "','" + ((TextBox)gr.FindControl("txtINSDATE")).Text + "','" + ((TextBox)gr.FindControl("txtDEFDATE")).Text + "','" + ((TextBox)gr.FindControl("txtREPDATE")).Text + "','" + ((TextBox)gr.FindControl("txtHMR")).Text + "','" + ((TextBox)gr.FindControl("txtDealerCode")).Text + "','" + ((TextBox)gr.FindControl("txtDealerName")).Text + "','" + ((TextBox)gr.FindControl("txtREG")).Text + "','" + ((TextBox)gr.FindControl("txtCRDATE")).Text + "','" + ((TextBox)gr.FindControl("txtItemCode")).Text + "','" + strDescription + "','" + ((TextBox)gr.FindControl("txtQuantity")).Text + "','" + ((TextBox)gr.FindControl("txtCost")).Text + "','" + ((TextBox)gr.FindControl("txtDEF")).Text + "','" + ((TextBox)gr.FindControl("txtNDP")).Text + "','" + ((TextBox)gr.FindControl("txtVALUE")).Text + "','" + ((TextBox)gr.FindControl("txtCVOICE")).Text + "','" + ((TextBox)gr.FindControl("txtOUTLV")).Text + "','" + ((TextBox)gr.FindControl("txtDT")).Text + "','" + ((TextBox)gr.FindControl("txtCulCode")).Text + "','" + ((TextBox)gr.FindControl("txtBlank")).Text + "','" + ((TextBox)gr.FindControl("txtCRAMT")).Text + "','" + ((TextBox)gr.FindControl("txtAUTHAMT")).Text + "','" + ((TextBox)gr.FindControl("txtDIFF")).Text + "','" + ((Label)gr.FindControl("lblFromDate")).Text + "','" + ((Label)gr.FindControl("lblToDate")).Text + "','"+ CurrentMonthID +"','"+ CurrentYearID +"','"+strQuarterYear+"','"+ strEngine +"',"+ IsEngine +")";
objQueryController.ExecuteQuery(strQuery);
}
// lblMessage = "File Acr saved successfully;No of Rows Affected:" + rcount;
}
catch
{
//lnkExceptions.Visible = true;
int index = strCause.IndexOf(';');
if (index == 0)
{
strCause = strCause.Remove(0, 1);
}
string strEngine = ((HiddenField)gr.FindControl("hdnEngine")).Value;
string strIsEngine = Convert.ToString(((HiddenField)gr.FindControl("hdnIsEngine")).Value);
int IsEngine = 0;
if (strIsEngine == "False")
{
IsEngine = 0;
}
else
{
IsEngine = 1;
}
if (strIsEngine != "")
{
string strDescription = ((TextBox)gr.FindControl("txtDescription")).Text.Replace("'", "");
string strQuery = "Insert into AcrTemp ([WCDOCNO],[DLR_REF],[TRACTOR NO],[ENGINE NO],[INS DATE],[DEF DATE],[REP DATE],[HMR],[DLR CO],[DEALER NAME],[REG],[CR DATE],[ITEM CODE],[DESCRIPTION],[QTY],[COST],[DEF],[NDP],[VALUE],[CVOICE],[OUTLV],[DT],[CUL CODE],[F24],[CR-AMOUNT],[ AUTH AMT],[ DIFF],FromDate,ToDate,MonthID,YearID,Quarter,Engine,IsEngine)";
strQuery += "Values ('" + ((TextBox)gr.FindControl("txtWCDOCNO")).Text + "','" + ((TextBox)gr.FindControl("txtDlrRef")).Text + "','" + ((TextBox)gr.FindControl("txtTractorNo")).Text + "','" + ((TextBox)gr.FindControl("txtEngineNo")).Text + "','" + ((TextBox)gr.FindControl("txtINSDATE")).Text + "','" + ((TextBox)gr.FindControl("txtDEFDATE")).Text + "','" + ((TextBox)gr.FindControl("txtREPDATE")).Text + "','" + ((TextBox)gr.FindControl("txtHMR")).Text + "','" + ((TextBox)gr.FindControl("txtDealerCode")).Text + "','" + ((TextBox)gr.FindControl("txtDealerName")).Text + "','" + ((TextBox)gr.FindControl("txtREG")).Text + "','" + ((TextBox)gr.FindControl("txtCRDATE")).Text + "','" + ((TextBox)gr.FindControl("txtItemCode")).Text + "','" + strDescription + "','" + ((TextBox)gr.FindControl("txtQuantity")).Text + "','" + ((TextBox)gr.FindControl("txtCost")).Text + "','" + ((TextBox)gr.FindControl("txtDEF")).Text + "','" + ((TextBox)gr.FindControl("txtNDP")).Text + "','" + ((TextBox)gr.FindControl("txtVALUE")).Text + "','" + ((TextBox)gr.FindControl("txtCVOICE")).Text + "','" + ((TextBox)gr.FindControl("txtOUTLV")).Text + "','" + ((TextBox)gr.FindControl("txtDT")).Text + "','" + ((TextBox)gr.FindControl("txtCulCode")).Text + "','" + ((TextBox)gr.FindControl("txtBlank")).Text + "','" + ((TextBox)gr.FindControl("txtCRAMT")).Text + "','" + ((TextBox)gr.FindControl("txtAUTHAMT")).Text + "','" + ((TextBox)gr.FindControl("txtDIFF")).Text + "','" + ((Label)gr.FindControl("lblFromDate")).Text + "','" + ((Label)gr.FindControl("lblToDate")).Text + "','" + CurrentMonthID + "','" + CurrentYearID + "','" + strQuarterYear + "','" + strEngine + "'," + IsEngine + ")";
objQueryController.ExecuteQuery(strQuery);
}
}
string strDeleteQuery = "Delete from AcrTemp where ID=" + Convert.ToInt32(str);
objQueryController.ExecuteQuery(strDeleteQuery);
grdAcrException.DataBind();
}
}
}
public void SaveAcr(DataTable dt)
{
DataTable dtTemp = new DataTable();
DataTable dtModel = new DataTable();
string strModelQuery = "select * from Model";
dtModel = objQueryController.ExecuteQuery(strModelQuery);
DataTable dtView = new DataTable();
string strViewQuery = "Select distinct * from vwMastersCode";
dtView = objQueryController.ExecuteQuery(strViewQuery);
string sConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["connectionString"].ToString();
AcrController objCont = new AcrController();
int rcount = 0;
foreach (DataRow dr in dt.Rows)
{
string strCause = "item;culprit;cvoice;defect;model";
int itemex = 1;
int modelex = 1;
int culpritex = 1;
int cvoiceex = 1;
int defectex = 1;
AcrUI objUI = new AcrUI();
try
{
int flag = 0;
for (int i = 0; i < dtView.Rows.Count; i++)
{
if ("item" == dtView.Rows[i]["tablename"].ToString() && dr["ITEM CODE"].ToString() == dtView.Rows[i]["code"].ToString())
{
objUI.ITEM_CODE = Convert.ToString(dr["ITEM CODE"]);
strCause = strCause.Replace("item", "");
itemex = 0;
flag++;
}
if ("culprit" == dtView.Rows[i]["tablename"].ToString() && dr["CUL CODE"].ToString() == dtView.Rows[i]["code"].ToString())
{
string strCUL_CODE = Convert.ToString(dr["CUL CODE"]);
if (strCUL_CODE == "")
{
objUI.CUL_CODE = Convert.ToInt32(null);
}
else
{
objUI.CUL_CODE = Convert.ToInt32(dr["CUL CODE"]);
}
strCause = strCause.Replace(";culprit", "");
culpritex = 0;
flag++;
}
if ("customervoice" == dtView.Rows[i]["tablename"].ToString() && dr["CVOICE"].ToString() == dtView.Rows[i]["code"].ToString())
{
string strCVOICE = Convert.ToString(dr["CVOICE"]);
if (strCVOICE == "")
{
objUI.CVOICE = Convert.ToInt16(null);
}
else
{
objUI.CVOICE = Convert.ToInt16(dr["CVOICE"]);
}
strCause = strCause.Replace(";cvoice", "");
cvoiceex = 0;
flag++;
}
if ("defect" == dtView.Rows[i]["tablename"].ToString() && dr["DEF"].ToString() == dtView.Rows[i]["code"].ToString())
{
string strDEF = Convert.ToString(dr["DEF"]);
if (strDEF == "")
{
objUI.DEF = Convert.ToInt16(null);
}
else
{
objUI.DEF = Convert.ToInt16(dr["DEF"]);
}
strCause = strCause.Replace(";defect", "");
defectex = 0;
flag++;
}
if ("model" == dtView.Rows[i]["tablename"].ToString() && dr["Model_Code"].ToString() == dtView.Rows[i]["code"].ToString())
{
DataView dv = new DataView(dtModel);
dv.RowFilter = "Code ='" + dr["Model_Code"].ToString() + "'";
DataTable dtModelCode = dv.ToTable();
objUI.Model_Code = Convert.ToString(dtModelCode.Rows[0]["Model_Code"]);
strCause = strCause.Replace(";model", "");
modelex = 0;
flag++;
}
}
objUI.WCDOCNO = Convert.ToDecimal(dr["WCDOCNO"]);
objUI.DLR_REF = Convert.ToString(dr["DLR_REF"]);
objUI.TRACTOR_NO = Convert.ToInt64(dr["TRACTOR NO"]);
objUI.ENGINE_NO = Convert.ToString(dr["ENGINE NO"]);
//objUI.INS_DATE = Convert.ToString(dr["INS DATE"]);
//objUI.DEF_DATE = Convert.ToString(dr["DEF DATE"]);
//objUI.REP_DATE = Convert.ToString(dr["REP DATE"]);
string strInsdate = Convert.ToString(dr["INS DATE"]);
if (strInsdate == "" || strInsdate == "00.00.0000")
objUI.INS_DATE = Convert.ToDateTime("1/1/2001");
else
objUI.INS_DATE = Convert.ToDateTime(ConvertDateTime(Convert.ToString(dr["INS DATE"])));
if (Convert.ToString(dr["DEF DATE"]) == "" || Convert.ToString(dr["DEF DATE"]) == "00.00.0000")
objUI.DEF_DATE = Convert.ToDateTime("1/1/2001");
else
objUI.DEF_DATE = Convert.ToDateTime(ConvertDateTime(Convert.ToString(dr["DEF DATE"])));
if (Convert.ToString(dr["REP DATE"]) == "" || Convert.ToString(dr["REP DATE"]) == "00.00.0000")
objUI.REP_DATE = Convert.ToDateTime("1/1/2001");
else
objUI.REP_DATE = Convert.ToDateTime(ConvertDateTime(Convert.ToString(dr["REP DATE"])));
objUI.HMR = Convert.ToInt16(dr["HMR"]);
objUI.DLR_CO = Convert.ToString(dr["DLR CO"]);
objUI.DEALER_NAME = Convert.ToString(dr["DEALER NAME"]);
objUI.REG = Convert.ToString(dr["REG"]);
//objUI.CR_DATE = Convert.ToString(dr["CR DATE"]);
if (Convert.ToString(dr["CR DATE"]) == "" || Convert.ToString(dr["CR DATE"]) == "00.00.0000")
objUI.CR_DATE = Convert.ToDateTime("1/1/2001");
else
objUI.CR_DATE = Convert.ToDateTime(ConvertDateTime(Convert.ToString(dr["CR DATE"])));
objUI.DESCRIPTION = Convert.ToString(dr["DESCRIPTION"]);
objUI.QUANTITY = Convert.ToInt16(dr["QTY"]);
objUI.COST = Convert.ToString(dr["COST"]);
objUI.NDP = Convert.ToDecimal(dr["NDP"]);
objUI.VALUE = Convert.ToDecimal(dr["VALUE"]);
objUI.OUTLV = Convert.ToDecimal(dr["OUTLV"]);
objUI.DT = Convert.ToString(dr["DT"]);
string strBlank = Convert.ToString(dr["F24"]);
if (strBlank == "")
{
objUI.BLANK = Convert.ToDouble(null);
}
else
{
objUI.BLANK = Convert.ToDouble(dr["F24"]);
}
string strCR_AMOUNT = Convert.ToString(dr["CR-AMOUNT"]);
if (strCR_AMOUNT == "")
{
objUI.CR_AMOUNT = Convert.ToDouble(null);
}
else
{
objUI.CR_AMOUNT = Convert.ToDouble(dr["CR-AMOUNT"]);
}
string strAUTH_AMOUNT = Convert.ToString(dr[" AUTH AMT"]);
if (strAUTH_AMOUNT == "")
{
objUI.AUTH_AMOUNT = Convert.ToDouble(null);
}
else
{
objUI.AUTH_AMOUNT = Convert.ToDouble(dr[" AUTH AMT"]);
}
string strDIFF = Convert.ToString(dr[" DIFF"]);
if (strDIFF == "")
{
objUI.DIFF = Convert.ToDouble(null);
}
else
{
objUI.DIFF = Convert.ToDouble(dr[" DIFF"]);
}
objUI.Production_Month = Convert.ToInt16(dr["Production_Month"]);
//objUI.Model_Code = Convert.ToString(dr["Model_Code"]);
objUI.Production_Month_Year = Convert.ToString(dr["Production_Month_Year"]);
objUI.HMR_Range = Convert.ToString(dr["HMR_Range"]);
objUI.FromDate = Convert.ToDateTime(dr["FromDate"]);
objUI.ToDate = Convert.ToDateTime(dr["ToDate"]);
objUI.MonthID = Convert.ToInt16(dr["MonthID"]);
objUI.YearID = Convert.ToInt16(dr["YearID"]);
objUI.Quarter = Convert.ToString(dr["Quarter"]);
if (flag == 5)
{
objCont.SaveAcr(objUI);
rcount++;
}
else
{
int index = strCause.IndexOf(';');
if (index == 0)
{
strCause = strCause.Remove(0, 1);
}
string strDescription = dr["DESCRIPTION"].ToString().Replace("'", "");
string strQuery = "Insert into AcrTemp ([WCDOCNO],[DLR_REF],[TRACTOR NO],[ENGINE NO],[INS DATE],[DEF DATE],[REP DATE],[HMR],[DLR CO],[DEALER NAME],[REG],[CR DATE],[ITEM CODE],[DESCRIPTION],[QTY],[COST],[DEF],[NDP],[VALUE],[CVOICE],[OUTLV],[DT],[CUL CODE],[F24],[CR-AMOUNT],[ AUTH AMT],[ DIFF],[Production_Month],[Model_Code],[HMR_Range],[Production_Month_Year],[IsApproved],FromDate,ToDate,Cause,IsItemEx,IsCulpritEx,IsCVoiceEx,IsModelEx,IsDefectEx,MonthID,YearID,Quarter) ";
strQuery += "Values ('" + dr["WCDOCNO"].ToString() + "','" + dr["DLR_REF"].ToString() + "','" + dr["TRACTOR NO"].ToString() + "','" + dr["ENGINE NO"].ToString() + "','" + dr["INS DATE"].ToString() + "','" + dr["DEF DATE"].ToString() + "','" + dr["REP DATE"].ToString() + "','" + dr["HMR"].ToString() + "','" + dr["DLR CO"].ToString() + "','" + dr["DEALER NAME"].ToString() + "','" + dr["REG"].ToString() + "','" + dr["CR DATE"].ToString() + "','" + dr["ITEM CODE"].ToString() + "','" + strDescription + "','" + dr["QTY"].ToString() + "','" + dr["COST"].ToString() + "','" + dr["DEF"].ToString() + "','" + dr["NDP"].ToString() + "','" + dr["VALUE"].ToString() + "','" + dr["CVOICE"].ToString() + "','" + dr["OUTLV"].ToString() + "','" + dr["DT"].ToString() + "','" + dr["CUL CODE"].ToString() + "','" + dr["F24"].ToString() + "','" + dr["CR-AMOUNT"].ToString() + "','" + dr[" AUTH AMT"].ToString() + "','" + dr[" DIFF"].ToString() + "','" + dr["Production_Month"].ToString() + "','" + dr["Model_Code"].ToString() + "','" + dr["HMR_Range"].ToString() + "','" + dr["Production_Month_Year"].ToString() + "',0,'" + dr["FromDate"].ToString() + "','" + dr["ToDate"].ToString() + "','" + strCause + "'," + itemex + "," + culpritex + "," + cvoiceex + "," + modelex + "," + defectex + ",'" + dr["MonthID"].ToString() +"','" + dr["YearID"].ToString() + "','" + dr["Quarter"].ToString() +"')";
objQueryController.ExecuteQuery(strQuery);
}
}
catch
{
string strDescription = dr["DESCRIPTION"].ToString().Replace("'", "");
string strQuery = "Insert into AcrTemp ([WCDOCNO],[DLR_REF],[TRACTOR NO],[ENGINE NO],[INS DATE],[DEF DATE],[REP DATE],[HMR],[DLR CO],[DEALER NAME],[REG],[CR DATE],[ITEM CODE],[DESCRIPTION],[QTY],[COST],[DEF],[NDP],[VALUE],[CVOICE],[OUTLV],[DT],[CUL CODE],[F24],[CR-AMOUNT],[ AUTH AMT],[ DIFF],[Production_Month],[Model_Code],[HMR_Range],[Production_Month_Year],[IsApproved],FromDate,ToDate,Cause,IsItemEx,IsCulpritEx,IsCVoiceEx,IsModelEx,IsDefectEx,MonthID,YearID,Quarter) ";
strQuery += "Values ('" + dr["WCDOCNO"].ToString() + "','" + dr["DLR_REF"].ToString() + "','" + dr["TRACTOR NO"].ToString() + "','" + dr["ENGINE NO"].ToString() + "','" + dr["INS DATE"].ToString() + "','" + dr["DEF DATE"].ToString() + "','" + dr["REP DATE"].ToString() + "','" + dr["HMR"].ToString() + "','" + dr["DLR CO"].ToString() + "','" + dr["DEALER NAME"].ToString() + "','" + dr["REG"].ToString() + "','" + dr["CR DATE"].ToString() + "','" + dr["ITEM CODE"].ToString() + "','" + strDescription + "','" + dr["QTY"].ToString() + "','" + dr["COST"].ToString() + "','" + dr["DEF"].ToString() + "','" + dr["NDP"].ToString() + "','" + dr["VALUE"].ToString() + "','" + dr["CVOICE"].ToString() + "','" + dr["OUTLV"].ToString() + "','" + dr["DT"].ToString() + "','" + dr["CUL CODE"].ToString() + "','" + dr["F24"].ToString() + "','" + dr["CR-AMOUNT"].ToString() + "','" + dr[" AUTH AMT"].ToString() + "','" + dr[" DIFF"].ToString() + "','" + dr["Production_Month"].ToString() + "','" + dr["Model_Code"].ToString() + "','" + dr["HMR_Range"].ToString() + "','" + dr["Production_Month_Year"].ToString() + "',0,'" + dr["FromDate"].ToString() + "','" + dr["ToDate"].ToString() + "','" + strCause + "'," + itemex + "," + culpritex + "," + cvoiceex + "," + modelex + "," + defectex + ",'" + dr["MonthID"].ToString() + "','" + dr["YearID"].ToString() + "','" + dr["Quarter"].ToString() + "')";
objQueryController.ExecuteQuery(strQuery);
}
}
}
/***********************************Function to Save Acr File into Sql Server 2000 ***********************************/
public string SaveAcr(DataTable dt)
{
DataTable dtTemp = new DataTable();
int ID = 0;
DataTable dtModel = new DataTable();
string strModelQuery = "select * from Model";
dtModel = objController.ExecuteQuery(strModelQuery);
DataTable dtView = new DataTable();
string strViewQuery = "Select distinct * from vwMastersCode order by tablename";
dtView = objController.ExecuteQuery(strViewQuery);
DataTable dtMonthOC = new DataTable();
string strMonthOCQuery = "select * from MonthOpenClose";
dtMonthOC = objController.ExecuteQuery(strMonthOCQuery);
DataView dvMonthOC = new DataView(dtMonthOC);
DataTable dtFilter = new DataTable();
//int FromMonth = CalAcrfromDate.SelectedDate.Month;
string[] strFromDt = txtFromDate.Text.Trim().Split('/');
int FromMonth = Convert.ToInt16(strFromDt[1]);
dvMonthOC.RowFilter = "MonthID =" + FromMonth;
dtFilter = dvMonthOC.ToTable();
string lblMessage = "";
if (dtFilter.Rows != null)
{
bool OCStatus = Convert.ToBoolean(dtFilter.Rows[0]["Status"]);
if (OCStatus == false)
{
lblMessage = "Month is Closed, Please open month to enter data";
}
else
{
string[] strToDt = txtToDate.Text.Trim().Split('/');
//int ToMonth = CalAcrtoDate.SelectedDate.Month;
int ToMonth = Convert.ToInt16(strToDt[1]);
int tempIndex = 0;
string sConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["connectionString"].ToString();
AcrController objCont = new AcrController();
int rcount = 0;
foreach (DataRow dr in dt.Rows)
{
string strCause = "item;culprit;cvoice;defect;model";
int itemex = 1;
int modelex = 1;
int culpritex = 1;
int cvoiceex = 1;
int defectex = 1;
AcrUI objUI = new AcrUI();
try
{
int flag = 0;
DataView dvItem = new DataView(dtView);
dvItem.RowFilter = "tablename='item' and code='" + dr["ITEM CODE"].ToString() + "'";
if (dvItem.ToTable() != null)
{
if (dvItem.ToTable().Rows.Count > 0)
{
objUI.ITEM_CODE = Convert.ToString(dr["ITEM CODE"]);
strCause = strCause.Replace("item", "");
itemex = 0;
flag++;
}
}
DataView dvCulprit = new DataView(dtView);
dvCulprit.RowFilter = "tablename='culprit' and code='" + dr["CUL CODE"].ToString() + "'";
if (dvCulprit.ToTable() != null)
{
if (dvCulprit.ToTable().Rows.Count > 0)
{
string strCUL_CODE = Convert.ToString(dr["CUL CODE"]);
if (strCUL_CODE == "")
{
objUI.CUL_CODE = Convert.ToInt32(null);
}
else
{
objUI.CUL_CODE = Convert.ToInt32(dr["CUL CODE"]);
}
strCause = strCause.Replace(";culprit", "");
culpritex = 0;
flag++;
}
}
string strCVOICE = Convert.ToString(dr["CVOICE"]);
if (strCVOICE == "")
{
strCVOICE = "0";
}
DataView dvCVoice = new DataView(dtView);
dvCVoice.RowFilter = "tablename='customervoice' and code='" + strCVOICE + "'";
if (dvCVoice.ToTable() != null)
{
if (dvCVoice.ToTable().Rows.Count > 0)
{
if (strCVOICE == "")
{
objUI.CVOICE = Convert.ToInt32(null);
}
else
{
objUI.CVOICE = Convert.ToInt32(strCVOICE);
}
strCause = strCause.Replace(";cvoice", "");
cvoiceex = 0;
flag++;
}
}
DataView dvDefect = new DataView(dtView);
dvDefect.RowFilter = "tablename='defect' and code='" + dr["DEF"].ToString()+"'";
if (dvDefect.ToTable() != null)
{
if (dvDefect.ToTable().Rows.Count > 0)
{
string strDEF = Convert.ToString(dr["DEF"]);
if (strDEF == "")
{
objUI.DEF = Convert.ToInt32(null);
}
else
{
objUI.DEF = Convert.ToInt32(dr["DEF"]);
}
strCause = strCause.Replace(";defect", "");
defectex = 0;
flag++;
}
}
//for (int i = 0; i < dtView.Rows.Count; i++)
//{
// if ("item" == dtView.Rows[i]["tablename"].ToString() && dr["ITEM CODE"].ToString() == dtView.Rows[i]["code"].ToString())
// {
// objUI.ITEM_CODE = Convert.ToString(dr["ITEM CODE"]);
// strCause = strCause.Replace("item", "");
// itemex = 0;
// flag++;
// }
// if ("culprit" == dtView.Rows[i]["tablename"].ToString() && dr["CUL CODE"].ToString() == dtView.Rows[i]["code"].ToString())
// {
// string strCUL_CODE = Convert.ToString(dr["CUL CODE"]);
// if (strCUL_CODE == "")
// {
// objUI.CUL_CODE = Convert.ToInt32(null);
// }
// else
// {
// objUI.CUL_CODE = Convert.ToInt32(dr["CUL CODE"]);
// }
// strCause = strCause.Replace(";culprit", "");
// culpritex = 0;
// flag++;
// }
// string strCVOICE = Convert.ToString(dr["CVOICE"]);
// if (strCVOICE == "")
// {
// strCVOICE = "0";
// }
// if ("customervoice" == dtView.Rows[i]["tablename"].ToString() && strCVOICE == dtView.Rows[i]["code"].ToString())
// {
// if (strCVOICE == "")
// {
// objUI.CVOICE = Convert.ToInt32(null);
// }
// else
// {
// objUI.CVOICE = Convert.ToInt32(strCVOICE);
// }
// strCause = strCause.Replace(";cvoice", "");
// cvoiceex = 0;
// flag++;
// }
// if ("defect" == dtView.Rows[i]["tablename"].ToString() && dr["DEF"].ToString() == dtView.Rows[i]["code"].ToString())
// {
// string strDEF = Convert.ToString(dr["DEF"]);
// if (strDEF == "")
// {
// objUI.DEF = Convert.ToInt32(null);
// }
// else
// {
// objUI.DEF = Convert.ToInt32(dr["DEF"]);
// }
// strCause = strCause.Replace(";defect", "");
// defectex = 0;
// flag++;
// }
// //if ("model" == dtView.Rows[i]["tablename"].ToString() && dr["Model_Code"].ToString() == dtView.Rows[i]["code"].ToString())
// //{
// // DataView dv = new DataView(dtModel);
// // dv.RowFilter = "Code ='" + dr["Model_Code"].ToString() + "'";
// // DataTable dtModelCode = dv.ToTable();
// // objUI.Model_Code = Convert.ToString(dtModelCode.Rows[0]["Model_Code"]);
// // strCause = strCause.Replace(";model", "");
// // modelex = 0;
// // flag++;
// //}
//}
Int64 TractorNo = Convert.ToInt64(dr["TRACTOR NO"]);
int ModelMappingID = objCont.getModelMapping(TractorNo);
if (ModelMappingID > 0)
{
objUI.ModelMappingID = ModelMappingID;
modelex = 0;
flag++;
}
objUI.WCDOCNO = Convert.ToDecimal(dr["WCDOCNO"]);
objUI.DLR_REF = Convert.ToString(dr["DLR_REF"]);
objUI.TRACTOR_NO = Convert.ToInt64(dr["TRACTOR NO"]);
objUI.ENGINE_NO = Convert.ToString(dr["ENGINE NO"]);
//objUI.INS_DATE = Convert.ToString(dr["INS DATE"]);
//objUI.DEF_DATE = Convert.ToString(dr["DEF DATE"]);
//objUI.REP_DATE = Convert.ToString(dr["REP DATE"]);
string strInsdate = Convert.ToString(dr["INS DATE"]);
if (strInsdate == "" || strInsdate == "00.00.0000")
objUI.INS_DATE = Convert.ToDateTime("1/1/2001");
else
objUI.INS_DATE = Convert.ToDateTime(ConvertDateTime(Convert.ToString(dr["INS DATE"])));
if (Convert.ToString(dr["DEF DATE"]) == "" || Convert.ToString(dr["DEF DATE"]) == "00.00.0000")
objUI.DEF_DATE = Convert.ToDateTime("1/1/2001");
else
objUI.DEF_DATE = Convert.ToDateTime(ConvertDateTime(Convert.ToString(dr["DEF DATE"])));
if (Convert.ToString(dr["REP DATE"]) == "" || Convert.ToString(dr["REP DATE"]) == "00.00.0000")
objUI.REP_DATE = Convert.ToDateTime("1/1/2001");
else
objUI.REP_DATE = Convert.ToDateTime(ConvertDateTime(Convert.ToString(dr["REP DATE"])));
objUI.HMR = Convert.ToInt16(dr["HMR"]);
objUI.DLR_CO = Convert.ToString(dr["DLR CO"]);
objUI.DEALER_NAME = Convert.ToString(dr["DEALER NAME"]);
objUI.REG = Convert.ToString(dr["REG"]);
//objUI.CR_DATE = Convert.ToString(dr["CR DATE"]);
if (Convert.ToString(dr["CR DATE"]) == "" || Convert.ToString(dr["CR DATE"]) == "00.00.0000")
objUI.CR_DATE = Convert.ToDateTime("1/1/2001");
else
objUI.CR_DATE = Convert.ToDateTime(ConvertDateTime(Convert.ToString(dr["CR DATE"])));
objUI.DESCRIPTION = Convert.ToString(dr["DESCRIPTION"]);
objUI.QUANTITY = Convert.ToInt32(dr["QTY"]);
objUI.COST = Convert.ToString(dr["COST"]);
objUI.NDP = Convert.ToDecimal(dr["NDP"]);
objUI.VALUE = Convert.ToDecimal(dr["VALUE"]);
objUI.OUTLV = Convert.ToDecimal(dr["OUTLV"]);
objUI.DT = Convert.ToString(dr["DT"]);
string strBlank = Convert.ToString(dr["Column1"]);
if (strBlank == "")
{
objUI.BLANK = Convert.ToDouble(null);
}
else
{
objUI.BLANK = Convert.ToDouble(dr["Column1"]);
}
string strCR_AMOUNT = Convert.ToString(dr["CR-AMOUNT"]);
if (strCR_AMOUNT == "" )
{
objUI.CR_AMOUNT = Convert.ToDouble(null);
}
else
{
objUI.CR_AMOUNT = Convert.ToDouble(dr["CR-AMOUNT"]);
}
string strAUTH_AMOUNT = Convert.ToString(dr[" AUTH AMT"]);
if (strAUTH_AMOUNT == "")
{
objUI.AUTH_AMOUNT = Convert.ToDouble(null);
}
else
{
objUI.AUTH_AMOUNT = Convert.ToDouble(dr[" AUTH AMT"]);
}
string strDIFF = Convert.ToString(dr[" DIFF"]);
if (strDIFF == "")
{
objUI.DIFF = Convert.ToDouble(null);
}
else
{
objUI.DIFF = Convert.ToDouble(dr[" DIFF"]);
}
objUI.Production_Month = Convert.ToInt16(dr["Production_Month"]);
//objUI.Model_Code = Convert.ToString(dr["Model_Code"]);
objUI.Production_Month_Year = Convert.ToString(dr["Production_Month_Year"]);
objUI.HMR_Range = Convert.ToString(dr["HMR_Range"]);
//objUI.FromDate = CalAcrfromDate.SelectedDate;
objUI.FromDate = Convert.ToDateTime(objUtility.ConvertDateTime(txtFromDate.Text.Trim()));
//objUI.ToDate = CalAcrtoDate.SelectedDate;
objUI.ToDate = Convert.ToDateTime(objUtility.ConvertDateTime(txtToDate.Text.Trim()));
objUI.MonthID = Convert.ToInt16(dr["MonthID"]);
objUI.YearID = Convert.ToInt16(dr["YearID"]);
objUI.Quarter = Convert.ToString(dr["Quarter"]);
objUI.Engine = Convert.ToString(dr["Engine"]);
objUI.IsEngine = Convert.ToInt16(dr["IsEngine"].ToString());
if (flag == 5)
{
ID = objCont.SaveAcr(objUI);
rcount++;
}
else
{
int index = strCause.IndexOf(';');
if (index == 0)
{
strCause = strCause.Remove(0,1);
}
lnkExceptions.Visible = true;
string strDescription = dr["DESCRIPTION"].ToString().Replace("'", "");
string strIsEngine = dr["IsEngine"].ToString();
int IsEngine = 0;
if (strIsEngine == "")
{
IsEngine = 0;
}
else
{
IsEngine = Convert.ToInt16(strIsEngine);
}
string strCvoice = dr["CVOICE"].ToString();
if (strCvoice == "")
{
strCvoice = "0";
}
string strQuery = "Insert into AcrTemp ([WCDOCNO],[DLR_REF],[TRACTOR NO],[ENGINE NO],[INS DATE],[DEF DATE],[REP DATE],[HMR],[DLR CO],[DEALER NAME],[REG],[CR DATE],[ITEM CODE],[DESCRIPTION],[QTY],[COST],[DEF],[NDP],[VALUE],[CVOICE],[OUTLV],[DT],[CUL CODE],[F24],[CR-AMOUNT],[ AUTH AMT],[ DIFF],[Production_Month],[Model_Code],[HMR_Range],[Production_Month_Year],MonthID,YearID,[Quarter],[IsApproved],FromDate,ToDate,Cause,IsItemEx,IsCulpritEx,IsCVoiceEx,IsModelEx,IsDefectEx,Engine,IsEngine) ";
strQuery += "Values ('" + dr["WCDOCNO"].ToString() + "','" + dr["DLR_REF"].ToString() + "','" + dr["TRACTOR NO"].ToString() + "','" + dr["ENGINE NO"].ToString() + "','" + dr["INS DATE"].ToString() + "','" + dr["DEF DATE"].ToString() + "','" + dr["REP DATE"].ToString() + "','" + dr["HMR"].ToString() + "','" + dr["DLR CO"].ToString() + "','" + dr["DEALER NAME"].ToString() + "','" + dr["REG"].ToString() + "','" + dr["CR DATE"].ToString() + "','" + dr["ITEM CODE"].ToString() + "','" + strDescription + "','" + dr["QTY"].ToString() + "','" + dr["COST"].ToString() + "','" + dr["DEF"].ToString() + "','" + dr["NDP"].ToString() + "','" + dr["VALUE"].ToString() + "','" + strCvoice + "','" + dr["OUTLV"].ToString() + "','" + dr["DT"].ToString() + "','" + dr["CUL CODE"].ToString() + "','" + dr["Column1"].ToString() + "','" + dr["CR-AMOUNT"].ToString() + "','" + dr[" AUTH AMT"].ToString() + "','" + dr[" DIFF"].ToString() + "','" + dr["Production_Month"].ToString() + "','" + dr["Model_Code"].ToString() + "','" + dr["HMR_Range"].ToString() + "','" + dr["Production_Month_Year"].ToString() + "','" + dr["MonthID"].ToString() + "','" + dr["YearID"].ToString() + "','" + dr["Quarter"].ToString() + "',0,'" + objUtility.ConvertDateTime(txtFromDate.Text.Trim()) + "','" + objUtility.ConvertDateTime(txtToDate.Text.Trim()) + "','" + strCause + "'," + itemex + "," + culpritex + "," + cvoiceex + "," + modelex + "," + defectex + ",'" + dr["Engine"].ToString() + "'," + IsEngine + ")";
objController.ExecuteQuery(strQuery);
}
lblMessage = "File Acr saved successfully;No of Rows Affected:" + rcount;
}
catch
{
lnkExceptions.Visible = true;
string strDescription = dr["DESCRIPTION"].ToString().Replace("'", "");
string strIsEngine = dr["IsEngine"].ToString();
int IsEngine = 0;
if (strIsEngine == "")
{
IsEngine = 0;
}
else
{
IsEngine = Convert.ToInt16(strIsEngine);
}
string strCvoice = dr["CVOICE"].ToString();
if (strCvoice == "")
{
strCvoice = "0";
}
string strQuery = "Insert into AcrTemp ([WCDOCNO],[DLR_REF],[TRACTOR NO],[ENGINE NO],[INS DATE],[DEF DATE],[REP DATE],[HMR],[DLR CO],[DEALER NAME],[REG],[CR DATE],[ITEM CODE],[DESCRIPTION],[QTY],[COST],[DEF],[NDP],[VALUE],[CVOICE],[OUTLV],[DT],[CUL CODE],[F24],[CR-AMOUNT],[ AUTH AMT],[ DIFF],[Production_Month],[Model_Code],[HMR_Range],[Production_Month_Year],MonthID,YearID,[Quarter],[IsApproved],FromDate,ToDate,Cause,IsItemEx,IsCulpritEx,IsCVoiceEx,IsModelEx,IsDefectEx,Engine,IsEngine) ";
strQuery += "Values ('" + dr["WCDOCNO"].ToString() + "','" + dr["DLR_REF"].ToString() + "','" + dr["TRACTOR NO"].ToString() + "','" + dr["ENGINE NO"].ToString() + "','" + dr["INS DATE"].ToString() + "','" + dr["DEF DATE"].ToString() + "','" + dr["REP DATE"].ToString() + "','" + dr["HMR"].ToString() + "','" + dr["DLR CO"].ToString() + "','" + dr["DEALER NAME"].ToString() + "','" + dr["REG"].ToString() + "','" + dr["CR DATE"].ToString() + "','" + dr["ITEM CODE"].ToString() + "','" + strDescription + "','" + dr["QTY"].ToString() + "','" + dr["COST"].ToString() + "','" + dr["DEF"].ToString() + "','" + dr["NDP"].ToString() + "','" + dr["VALUE"].ToString() + "','" + strCvoice + "','" + dr["OUTLV"].ToString() + "','" + dr["DT"].ToString() + "','" + dr["CUL CODE"].ToString() + "','" + dr["Column1"].ToString() + "','" + dr["CR-AMOUNT"].ToString() + "','" + dr[" AUTH AMT"].ToString() + "','" + dr[" DIFF"].ToString() + "','" + dr["Production_Month"].ToString() + "','" + dr["Model_Code"].ToString() + "','" + dr["HMR_Range"].ToString() + "','" + dr["Production_Month_Year"].ToString() + "','" + dr["MonthID"].ToString() + "','" + dr["YearID"].ToString() + "','" + dr["Quarter"].ToString() + "',0,'" + objUtility.ConvertDateTime(txtFromDate.Text.Trim()) + "','" + objUtility.ConvertDateTime(txtToDate.Text.Trim()) + "','" + strCause + "'," + itemex + "," + culpritex + "," + cvoiceex + "," + modelex + "," + defectex + ",'" + dr["Engine"].ToString() + "'," + IsEngine + ")";
objController.ExecuteQuery(strQuery);
}
}
}
}
return lblMessage;
}
public string SaveBulkAcr(DataTable dt)
{
AcrController objAcrController = new AcrController();
string sConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["connectionString"].ToString();
string lblMessage = "";
try
{
SqlConnection sqlconn = new SqlConnection(sConnectionString);
sqlconn.Open();
SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlconn);
bulkCopy.DestinationTableName = "AcrBulkTemp";
bulkCopy.WriteToServer(dt);
int Status = objAcrController.SaveBulkAcr();
//string strQuery = "UPDATE AcrBulk SET ModelMappingID =( SELECT Production.ModelMappingID FROM Production WHERE Production.SerialNo = Convert(varchar,AcrBulk.Tractor_No)) WHERE EXISTS ( SELECT Production.ModelMappingID FROM Production WHERE Production.SerialNo = Convert(varchar,AcrBulk.Tractor_No))";
string strQuery = "Update AcrBulk set ModelMappingID = Production.ModelMappingID from AcrBulk inner join Production on Convert(varchar,AcrBulk.Tractor_No) = Production.SerialNo ";
objController.ExecuteQuery(strQuery);
if (Status == 0)
{
lblMessage = "File Acr saved successfully";
}
else
{
lnkExceptions.Visible = true;
lblMessage = "File Acr could not be saved successfully";
}
}
catch
{
lnkExceptions.Visible = true;
lblMessage = "File Acr could not be saved successfully";
}
return lblMessage;
}
public string SaveBulkAcr()
{
AcrController objAcrController = new AcrController();
string sConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["connectionString"].ToString();
string lblMessage = "";
try
{
int Status = objAcrController.SaveBulkAcr();
string strQuery = "Update AcrBulk set ModelMappingID = Production.ModelMappingID from AcrBulk inner join Production on Convert(varchar,AcrBulk.Tractor_No) = Production.SerialNo";
//string strQuery = "UPDATE AcrBulk SET ModelMappingID =( SELECT Production.ModelMappingID FROM Production WHERE Production.SerialNo = Convert(varchar,AcrBulk.Tractor_No)) WHERE EXISTS ( SELECT Production.ModelMappingID FROM Production WHERE Production.SerialNo = Convert(varchar,AcrBulk.Tractor_No))";
objQuerycontroller.ExecuteQuery(strQuery);
if (Status == 0)
{
lblMessage = "File Acr saved successfully";
}
else
{
lblMessage = "File Acr could not be saved successfully";
}
}
catch
{
lblMessage = "File Acr could not be saved successfully";
}
return lblMessage;
}
