private void RetrieveMasterData() { DataSet ds = new DataSet(); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@FPBillNo", SqlDbType.Char, 8), //1 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = ddlBillingNo.SelectedValue.Trim().ToString(); //ObjMainBll.ExecuteSP_NonQuery("sp_2W_Service_GetMasterData", param); ds = ObjGenral.FillDataSet("sp_2W_Service_GetMasterData", param); if (ds.Tables[0].Rows[0]["BillDate"].ToString() == "") { txtRemarks.Text = ""; } else { txtRemarks.Text = ds.Tables[0].Rows[0]["Remarks"].ToString(); } //txtCode.Text = ds.Tables[0].Rows[0]["SSTNo"].ToString(); // ddlTypes.SelectedValue = ds.Tables[0].Rows[0]["BillType"].ToString(); txtBillDate.Text = Convert.ToDateTime(ds.Tables[0].Rows[0]["BillDate"].ToString()).ToString("dd/MM/yyyy"); txtTotalAmount.Text = ds.Tables[0].Rows[0]["BillAmount"].ToString(); //txtPerc.Text = ds.Tables[0].Rows[0]["SSTAge"].ToString(); //txtPstAmt.Text = ds.Tables[0].Rows[0]["SSTAmount"].ToString(); lblLastBillNo.Text = ""; }
public void GetRefundDetail(string item) { SqlParameter[] dsMasterParam = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), new SqlParameter("@RefundNo", SqlDbType.Char, 8), }; dsMasterParam[0].Value = Session["DealerCode"].ToString(); dsMasterParam[1].Value = item; DataSet dsJobCardMaster = new DataSet(); dsJobCardMaster = SysFunc.FillDataSet("sp_AdvanceInsurance_Detail", dsMasterParam); if (dsJobCardMaster.Tables[0].Rows.Count > 0) { txtVoucherNo.Text = dsJobCardMaster.Tables[0].Rows[0]["VoucherNo"].ToString(); txtRefundDate.Text = dsJobCardMaster.Tables[0].Rows[0]["AdvanceDate"].ToString(); txtins_amount.Text = dsJobCardMaster.Tables[0].Rows[0]["InsAmount"].ToString(); ddlpayment_mode.SelectedValue = dsJobCardMaster.Tables[0].Rows[0]["PayModeCode"].ToString(); txtinstrument_no.Text = dsJobCardMaster.Tables[0].Rows[0]["InsNo"].ToString(); txtinstrument_date.Text = SysFuncs.GetDate(dsJobCardMaster.Tables[0].Rows[0]["InsDate"].ToString()); ddlbank.SelectedValue = dsJobCardMaster.Tables[0].Rows[0]["BankCode"].ToString().Trim(); txtbranch.Text = dsJobCardMaster.Tables[0].Rows[0]["Branch"].ToString(); ddlInsCo.SelectedValue = dsJobCardMaster.Tables[0].Rows[0]["InsCompCode"].ToString().Trim(); ddlInsCo_SelectedIndexChanged(null, null); ddlInsBranch.SelectedValue = dsJobCardMaster.Tables[0].Rows[0]["BranchCode"].ToString().Trim(); btn_save.Enabled = false; } }
private void CalcTotals() { DataSet ds = new DataSet(); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), new SqlParameter("@GRNNo", SqlDbType.Char), }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = ddlGRN.SelectedValue.ToString().Trim(); //Load_Detail("sp_Select_GRNDetail_on_PayableInvForm", ddlGRN.SelectedValue.ToString().Trim(), "@GRNNo"); ds = SysFunc.FillDataSet("sp_Select_GRNDetail_on_PayableInvForm", param); decimal SumOfGSTAmt = 0; decimal SumOfFurTaxAmt = 0; decimal SumOfExTaxAmt = 0; foreach (GridViewRow gvr in gvPurInvDetail.Rows) { CheckBox chkSelect = (CheckBox)gvr.Cells[0].FindControl("chkSelect"); Label lblGrossAmt = (Label)gvr.Cells[10].FindControl("lblGrossAmt"); foreach (DataRow dr in ds.Tables[0].Rows) { if (chkSelect.Checked == true) { if (dr["ItemCode"].ToString() == gvr.Cells[1].Text) { SumOfGSTAmt = SumOfGSTAmt + ((Convert.ToDecimal(lblGrossAmt.Text) * Convert.ToDecimal(dr["GSTPercent"].ToString())) / 100); SumOfExTaxAmt = SumOfExTaxAmt + ((Convert.ToDecimal(lblGrossAmt.Text) * Convert.ToDecimal(dr["ExTaxPercent"].ToString())) / 100); SumOfFurTaxAmt = SumOfFurTaxAmt + ((Convert.ToDecimal(lblGrossAmt.Text) * Convert.ToDecimal(dr["FurTaxPercent"].ToString())) / 100); } } } } lblGstPerc.Text = ds.Tables[0].Rows[0]["GSTPercent"].ToString() + "%"; lblFurTaxPerc.Text = ds.Tables[0].Rows[0]["FurTaxPercent"].ToString() + "%"; lblExTaxPerc.Text = ds.Tables[0].Rows[0]["ExTaxPercent"].ToString() + "%"; txtGstAmt.Text = SumOfGSTAmt.ToString(("#.##")); txtExTaxAmt.Text = SumOfExTaxAmt.ToString(("#.##")); txtFurTaxAmt.Text = SumOfFurTaxAmt.ToString(("#.##")); Label lblFooterGrossAmt = (Label)gvPurInvDetail.FooterRow.Cells[10].FindControl("lblFooterGrossAmt"); txtTotalAmt.Text = (SumOfGSTAmt + SumOfExTaxAmt + SumOfFurTaxAmt + Convert.ToDecimal(lblFooterGrossAmt.Text)).ToString(); }
protected void ddlVinNo_SelectedIndexChanged(object sender, EventArgs e) { DataSet dsVehInfo = new DataSet(); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.VarChar, 5), new SqlParameter("@ChassisNo", SqlDbType.VarChar, 30) }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = ddlVinNo.SelectedValue.ToString().Trim(); // ddlRegNo.Text.Trim();//(HFRegNo.Value == "" ? null : HFRegNo.Value); dsVehInfo = sysfuncs.FillDataSet("sp_W2_CustomerVehicleDTR_Select", param); if (dsVehInfo.Tables[0].Rows.Count > 0) { setVehcileInfo(dsVehInfo); } }
private void PopulateGrid() { SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), new SqlParameter("@FromDate", SqlDbType.DateTime), }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = Calendar1.SelectedDate.ToString("yyyy-MM-dd"); DataSet ds = new DataSet(); ds = myFunc.FillDataSet("SP_NDM_LetterSendDate", param); if (ds.Tables[0].Rows.Count > 0) { grdNextDueMaintenance.DataSource = ds; grdNextDueMaintenance.DataBind(); Session["NextDueMaintenance"] = ds; } ds.Dispose(); ds = myFunc.FillDataSet("SP_NDM_CallDate", param); if (ds.Tables[0].Rows.Count > 0) { gvCallSend.DataSource = ds; gvCallSend.DataBind(); Session["CallDate"] = ds; } ds.Dispose(); ds = myFunc.FillDataSet("SP_NDM_SMSDate", param); if (ds.Tables[0].Rows.Count > 0) { gvSMSSend.DataSource = ds; gvSMSSend.DataBind(); Session["SMSDate"] = ds; } }
protected void ddlRegNo_SelectedIndexChanged(object sender, EventArgs e) { DataSet ds = new DataSet(); string RegNo = ddlRegNo.SelectedValue.ToString(); SqlParameter[] RegNo_param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), /*0*/ new SqlParameter("@RegNo", SqlDbType.VarChar, 100) }; RegNo_param[0].Value = Session["DealerCode"].ToString(); RegNo_param[1].Value = RegNo; ds = myFunc.FillDataSet("sp_2W_LoadChassisEngineRegNo_RegNoParameter_History", RegNo_param); ddlEngineNo.SelectedValue = ds.Tables[0].Rows[0]["EngineNo"].ToString(); ddlChassisNo.SelectedValue = ds.Tables[0].Rows[0]["ChassisNo"].ToString(); txtCusCode.Text = ds.Tables[0].Rows[0]["CusCode"].ToString(); txtCustomer.Text = ds.Tables[0].Rows[0]["CusDesc"].ToString().ToUpper(); txtProduct.Text = ds.Tables[0].Rows[0]["ProdCode"].ToString(); txtVersionCode.Text = ds.Tables[0].Rows[0]["VersionCode"].ToString(); txtVerDesc.Text = ds.Tables[0].Rows[0]["ProdTitle"].ToString(); lblMSG.Text = ""; }
public void GetGatePassDetail() { DataSet dsGatePassInfo = new DataSet(); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.VarChar, 5), new SqlParameter("@GatePassCode", SqlDbType.Char, 8) }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = txtGatePassCode.Text; dsGatePassInfo = myFunc.FillDataSet("sp_W2_GatePass_Select", param); if (dsGatePassInfo.Tables[0].Rows.Count > 0) { setGatePassInfo(dsGatePassInfo); } DataSet dsVeh = new DataSet(); dsVeh = myFunc.FillDataSet("sp_W2_GatePass_VehicleDetail_Select", param); //if (dsJobCardParts.Tables[0].Rows.Count == 0) dsJobCardParts.Tables[0].Rows.Add(dsJobCardParts.Tables[0].NewRow()); ViewState["Veh"] = dsVeh.Tables[0]; gvVehicle.DataSource = dsVeh.Tables[0]; gvVehicle.DataBind(); }
private void PopulateGrid() { SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), new SqlParameter("@FromDate", SqlDbType.DateTime), }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = Calendar1.SelectedDate.ToString("yyyy-MM-dd"); DataSet ds = new DataSet(); ds = myFunc.FillDataSet("sp_2W_Post_PostServiceFollowup", param); grdPostServiceFollowup.DataSource = ds; grdPostServiceFollowup.DataBind(); Session["PostServiceFollowup"] = ds; lbltotalCustomer.Text = ds.Tables[0].Rows.Count.ToString(); }
// ddlWFPolicyMasterCode protected void ddlWFPolicyMasterCode_SelectedIndexChanged(object sender, EventArgs e) { DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlDataReader dr = null; // Data load in ddlchargoutNo SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@WFPolicyMasterCode", SqlDbType.Char, 8), //1 }; param[0].Value = Session["DealerCode"].ToString(); // 0 param[1].Value = ddlWFPolicyMasterCode.SelectedValue.Trim(); ds = sysFuncs.FillDataSet("SP_WFPolicyMaster_WFSelect", param); // Showing Data in Text Field through DropDownLIST if (ds.Tables[0].Rows.Count > 0) { txtPolicyDesc.Text = ds.Tables[0].Rows[0]["WFPolicyMasterDesc"].ToString().Trim(); ddlSolution.SelectedValue = ds.Tables[0].Rows[0]["Solution_Code"].ToString().Trim(); ddlPolicyType.SelectedValue = ds.Tables[0].Rows[0]["PolicyType"].ToString().Trim(); ddlStatus.SelectedValue = ds.Tables[0].Rows[0]["Status"].ToString().Trim(); txtStartDate.Text = ds.Tables[0].Rows[0]["PolicyStartDate"].ToString().Trim(); txtEndDate.Text = ds.Tables[0].Rows[0]["PolicyEndDate"].ToString().Trim(); txtComment.Text = ds.Tables[0].Rows[0]["Comments"].ToString().Trim(); gv_WFPolicy.DataSource = ds.Tables[0]; gv_WFPolicy.DataBind(); } else { Create_Grid(); return; } Session["WFPolicyDS"] = ds; }
public void GetRefundDetail(string item) { SqlParameter[] dsMasterParam = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), new SqlParameter("@RefundNo", SqlDbType.Char, 8), }; dsMasterParam[0].Value = Session["DealerCode"].ToString(); dsMasterParam[1].Value = item; DataSet dsJobCardMaster = new DataSet(); dsJobCardMaster = SysFunc.FillDataSet("sp_PaymentRefund_Detail", dsMasterParam); if (dsJobCardMaster.Tables[0].Rows.Count > 0) { if (dsJobCardMaster.Tables[0].Rows[0]["RefundType"].ToString() == "Customer") { RbtnType.SelectedValue = "Customer"; lblType.Text = "Customer"; } else { RbtnType.SelectedValue = "Vendor"; lblType.Text = "Vendor"; } txtCusVenCode.Text = dsJobCardMaster.Tables[0].Rows[0]["VoucherNo"].ToString(); txtCusVenCode.Text = dsJobCardMaster.Tables[0].Rows[0]["CusCode"].ToString(); txtCUSVen.Text = dsJobCardMaster.Tables[0].Rows[0]["CusDesc"].ToString(); txtRefundDate.Text = dsJobCardMaster.Tables[0].Rows[0]["RDate"].ToString(); txtins_amount.Text = dsJobCardMaster.Tables[0].Rows[0]["InsAmount"].ToString(); ddlpayment_mode.SelectedValue = dsJobCardMaster.Tables[0].Rows[0]["PayModeCode"].ToString(); txtinstrument_no.Text = dsJobCardMaster.Tables[0].Rows[0]["InsNo"].ToString(); txtinstrument_date.Text = SysFuncs.GetDate(dsJobCardMaster.Tables[0].Rows[0]["InsDate"].ToString()); ddlbank.SelectedValue = dsJobCardMaster.Tables[0].Rows[0]["BankCode"].ToString().Trim(); txtbranch.Text = dsJobCardMaster.Tables[0].Rows[0]["Branch"].ToString(); txtInvType.Text = dsJobCardMaster.Tables[0].Rows[0]["ReceiptType"].ToString(); txtBalance.Text = dsJobCardMaster.Tables[0].Rows[0]["AdvanceBalanceAmount"].ToString(); txtAdvReceiptNo.Text = dsJobCardMaster.Tables[0].Rows[0]["AdvanceCode"].ToString(); ddlReceiptNo.Visible = false; txtAdvReceiptNo.Visible = true; btnAdjAmt.Enabled = false; btn_save.Enabled = false; } }
private void DisplayItem() { DataSet ds = new DataSet(); try { SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), new SqlParameter("@ItemCode", SqlDbType.Char), new SqlParameter("@IssueNo", SqlDbType.Char) }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = ddlPartsNo.SelectedValue.ToString(); param[2].Value = ddlIssueNo.SelectedValue.ToString(); ds = SysFunc.FillDataSet("sp_StockReturn_Part_Select", param); txtPartItemDesc.Text = ds.Tables[0].Rows[0]["ItemDesc"].ToString(); txtPartItemNo.Text = ds.Tables[0].Rows[0]["PartItemNo"].ToString(); txtLocCode.Text = ds.Tables[0].Rows[0]["PartsTransLocCode"].ToString(); txtLocDesc.Text = ds.Tables[0].Rows[0]["PartsTransLocDesc"].ToString(); txtUnitCode.Text = ds.Tables[0].Rows[0]["UnitCode"].ToString(); txtUnit.Text = ds.Tables[0].Rows[0]["UnitDesc"].ToString(); txtIssueQty.Text = ds.Tables[0].Rows[0]["IssueQty"].ToString(); txtIssueRate.Text = ds.Tables[0].Rows[0]["Rate"].ToString(); txtRemaining.Text = (Convert.ToDouble(txtIssueQty.Text) - Convert.ToDouble(ds.Tables[0].Rows[0]["RetQty"].ToString())).ToString(); ds = SysFunc.PartStock(ddlPartsNo.SelectedValue.ToString().Trim(), Session["DealerCode"].ToString(), txtLocCode.Text); txtTotalStock.Text = ds.Tables[0].Rows[0]["Balance"].ToString(); ds = SysFunc.PartStockAtLoaction(ddlPartsNo.SelectedValue.ToString().Trim(), Session["DealerCode"].ToString(), txtLocCode.Text); txtStockLoc.Text = ds.Tables[0].Rows[0]["Balance"].ToString(); } catch (Exception ex) { LbErr.Text = ex.Message; } }
protected void btnCheck_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); // Data load in ddlchargoutNo SqlParameter[] param = { new SqlParameter("@PartNo", SqlDbType.VarChar, 50), //0 new SqlParameter("@PartDesc", SqlDbType.VarChar, 100), //1 new SqlParameter("@Source", SqlDbType.VarChar, 10), //2 new SqlParameter("@qty", SqlDbType.Int), //3 }; param[0].Value = txtPartNo.Text; // 0 param[1].Value = txtPartDesc.Text; param[2].Value = txtSource.Text; // 0 param[3].Value = txtQty.Text; DataSet ds = new DataSet(); ds = sysFuncs.FillDataSet("SP_OnlinePartCheck", param); gv_DC.DataSource = ds; gv_DC.DataBind(); }
private void LoadGrid(string DCNumber, string PONumber, string DealerCode) { DataTable dtParts = new DataTable(); DataTable dt = new DataTable(); DataSet dsParts = new DataSet(); SqlDataReader dr = null; string mPONo = ""; string mDCNo = ""; if (PONumber == "") { mPONo = Session["PONumber"].ToString(); } else { mPONo = PONumber; } if (DCNumber == "") { mDCNo = Session["DCNumber"].ToString(); } else { mDCNo = DCNumber; } try { SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 10), new SqlParameter("@PONO", SqlDbType.Char, 10) }; param[0].Value = this.Session["DealerCode"].ToString(); param[1].Value = mPONo; myFunc.ExecuteSP("Sp_2W_GetPO_ForDC", param, ref dr); dtParts.Load(dr); //ds = (DataSet)ViewState["ObjPOds"]; dt = (DataTable)this.Session["DCTable"]; dt.Rows.Clear(); if (dtParts.Rows.Count != 0) { foreach (DataRow dRow in dtParts.Rows) { SqlParameter[] paramPO_Parts = { new SqlParameter("@PONO", SqlDbType.Char, 10), new SqlParameter("@DealerCode", SqlDbType.Char, 10), new SqlParameter("@ItemCode", SqlDbType.Char, 10) }; paramPO_Parts[0].Value = mPONo; paramPO_Parts[1].Value = this.Session["DealerCode"].ToString(); paramPO_Parts[2].Value = dRow["ItemCode"].ToString(); dsParts = myFunc.FillDataSet("SP_Spare_Get_PartPOInfo_New", paramPO_Parts); DataRow row = dt.NewRow(); row["Sno"] = dt.Rows.Count + 1; row["PartItemNo"] = dsParts.Tables[0].Rows[0]["PartItemNo"].ToString(); row["PartItemName"] = dsParts.Tables[0].Rows[0]["ItemDesc"].ToString(); row["unit"] = dsParts.Tables[0].Rows[0]["Unit"].ToString(); row["POQuantity"] = dsParts.Tables[0].Rows[0]["POQty"].ToString(); row["BalanceQuantity"] = dsParts.Tables[0].Rows[0]["BalanceQty"].ToString(); row["DCQuantity"] = dsParts.Tables[0].Rows[0]["BalanceQty"].ToString(); //row["Selected"] = true; dt.Rows.Add(row); } } Session["DCTable"] = dt; gv_DC.DataSource = dt; gv_DC.DataSourceID = null; gv_DC.DataBind(); } catch (Exception ex) { //ObjGeneral.UserMsg(LbErr, Color.Red, "Error: " + ex.Message, txtDCNo); } }
public void ViewData() { DataSet ds = new DataSet(); DataTable dt = new DataTable(); string sql = "exec SP_Select_PPRMaster '" + Session["DealerCode"].ToString() + "','" + ddlPRNo.SelectedValue + "'"; dt = sysFunc.GetData(sql); txtJobCode.Text = dt.Rows[0]["JobCardCode"].ToString(); txtJobCardDate.Text = dt.Rows[0]["PPRDate"].ToString(); //Convert.ToDateTime(sysFuncs.GetStringValuesAgainstCodes("JobCardCode", ddljob_code.SelectedValue, "RecDate", "JobCardMaster")).ToString("dd/MM/yyyy"); txtPPRTotalAmount.Text = dt.Rows[0]["TotalAmount"].ToString(); txtRegNo.Text = dt.Rows[0]["VehRegNo"].ToString(); txtChasisNo.Text = dt.Rows[0]["VehChassisNo"].ToString(); txtEngNo.Text = dt.Rows[0]["VehEngineNo"].ToString(); txtVehModel.Text = Convert.ToDateTime(dt.Rows[0]["InvoiceDate"].ToString()).ToString("yyyy"); txtInvoiceNo.Text = dt.Rows[0]["InvoiceNo"].ToString(); txtInvDate.Text = Convert.ToDateTime(dt.Rows[0]["InvoiceDate"].ToString()).ToString("dd/MM/yyyy"); //txtDealerCode.Text = dt.Rows[0]["SaleDealerCode"].ToString(); //txtDealerName.Text = dt.Rows[0]["SaleDealerName"].ToString(); txtProdCode.Text = dt.Rows[0]["ProdCode"].ToString(); txtVehColor.Text = dt.Rows[0]["Color"].ToString(); txtKM.Text = dt.Rows[0]["MeterReadingKM"].ToString(); if (dt.Rows[0]["CompletionDate"].ToString() != "") { dtComplitionDate.Text = sysFunc.GetDate(dt.Rows[0]["CompletionDate"]); //Convert.ToDateTime(Convert.ToDateTime(dt.Rows[0]["CompletionDate"].ToString()).ToString("dd/MM/yyyy").Substring(6, 4) + "/" + Convert.ToDateTime(dt.Rows[0]["CompletionDate"].ToString()).ToString("dd/MM/yyyy").Substring(3, 2) + "/" + Convert.ToDateTime(dt.Rows[0]["CompletionDate"].ToString()).ToString("dd/MM/yyyy").Substring(0, 2)); //Convert.ToDateTime(Convert.ToDateTime(gvr.Cells[4].Text).ToString("yyyy-MM-dd")); } dtProblemDate.Text = sysFunc.GetDate(dt.Rows[0]["DateOfProblem"]); //Convert.ToDateTime(Convert.ToDateTime(dt.Rows[0]["DateOfProblem"].ToString()).ToString("dd/MM/yyyy").Substring(6, 4) + "/" + Convert.ToDateTime(dt.Rows[0]["DateOfProblem"].ToString()).ToString("dd/MM/yyyy").Substring(3, 2) + "/" + Convert.ToDateTime(dt.Rows[0]["DateOfProblem"].ToString()).ToString("dd/MM/yyyy").Substring(0, 2)); //Convert.ToDateTime(Convert.ToDateTime(gvr.Cells[4].Text).ToString("yyyy-MM-dd")); txtCustCode.Text = dt.Rows[0]["CusCode"].ToString(); txtCustName.Text = dt.Rows[0]["UserName"].ToString(); txtUserName.Text = dt.Rows[0]["UserName"].ToString().Trim(); txtUserAddress.Text = dt.Rows[0]["UserAddress1"].ToString(); txtPhoneNo.Text = dt.Rows[0]["UserPhoneNo"].ToString(); ddlRoadCond.SelectedValue = dt.Rows[0]["RoadCondition"].ToString().Trim(); txtAprovalDate.Text = dt.Rows[0]["ApprovalDate"].ToString(); txtAprovalNo.Text = dt.Rows[0]["ApprovalNo"].ToString(); txtComplainRemarks.Text = dt.Rows[0]["ComplainRemarks"].ToString(); txtTRDate.Text = dt.Rows[0]["TRDate"].ToString(); txtTRNo.Text = dt.Rows[0]["TRNo"].ToString(); if (dt.Rows[0]["ApprovalStatus"].ToString() == "") { ddlAppSt.SelectedIndex = 0; } else { ddlAppSt.SelectedValue = dt.Rows[0]["ApprovalStatus"].ToString().Trim(); } DataSet dsPPRDetail = new DataSet(); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), new SqlParameter("@PPRCode", SqlDbType.Char, 8), }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = ddlPRNo.SelectedValue; dsPPRDetail = sysFuncs.FillDataSet("sp_2W_Service_Select_PPRDetail", param); ddlComplains.SelectedValue = dsPPRDetail.Tables[0].Rows[0]["ComplainCode"].ToString(); txtCompletionDesc.Text = dsPPRDetail.Tables[0].Rows[0]["ComplaintDesc"].ToString(); ddlDefect.SelectedValue = dsPPRDetail.Tables[0].Rows[0]["DefectCode"].ToString(); txtLaborDesc.Text = dsPPRDetail.Tables[0].Rows[0]["LabourDesc"].ToString(); txtLaborAmount.Text = dsPPRDetail.Tables[0].Rows[0]["LabourRate"].ToString(); txtRootCauseFailure.Text = dsPPRDetail.Tables[0].Rows[0]["RootCauseFailure"].ToString(); txtCorrectiveAction.Text = dsPPRDetail.Tables[0].Rows[0]["CorrectiveAction"].ToString(); dsParts = new DataSet(); SqlParameter[] param1 = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), new SqlParameter("@PPRCode", SqlDbType.Char, 8), }; param1[0].Value = Session["DealerCode"].ToString(); param1[1].Value = ddlPRNo.SelectedValue; sql = "SELECT VendorCode FROM PPRPartsDetail WHERE PPRCode = '" + ddlPRNo.SelectedValue + "' AND DealerCode = '" + Session["DealerCode"].ToString() + "'"; dt = sysFunc.GetData(sql); if (dt.Rows.Count > 0) { ddlVendor.SelectedValue = dt.Rows[0]["VendorCode"].ToString().Trim(); } dsParts = sysFuncs.FillDataSet("sp_2W_Service_Select_PPRPartsDetail", param1); if (dsParts.Tables[0].Rows.Count > 0) { LoadGrid(); } }
private void LoadGrid(string DCNumber, string PONumber, string DealerCode) { DataTable dtParts = new DataTable(); DataSet ds = new DataSet(); DataSet dsParts = new DataSet(); SqlDataReader dr = null; string mPONo = ""; string mDCNo = ""; if (PONumber == "") { mPONo = this.Session["PONumber"].ToString(); } else { mPONo = PONumber; } //if (DCNumber == "") //{ // mDCNo = this.Session["DCNumber"].ToString(); //} //else //{ // mDCNo = DCNumber; //} try { SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 10), new SqlParameter("@PONO", SqlDbType.Char, 10) }; param[0].Value = this.Session["DealerCode"].ToString(); param[1].Value = mPONo; myFunc.ExecuteSP("Sp_2W_GetPO_ForDC", param, ref dr); dtParts.Load(dr); //ds = (DataSet)ViewState["ObjPOds"]; ds = (DataSet)this.Session["DCDataSet"]; ds.Tables["DCItems"].Rows.Clear(); if (dtParts.Rows.Count != 0) { foreach (DataRow dRow in dtParts.Rows) { SqlParameter[] paramPO_Parts = { new SqlParameter("@PONO", SqlDbType.Char, 10), new SqlParameter("@DealerCode", SqlDbType.Char, 10), new SqlParameter("@ItemCode", SqlDbType.Char, 10) }; paramPO_Parts[0].Value = mPONo; paramPO_Parts[1].Value = this.Session["DealerCode"].ToString(); paramPO_Parts[2].Value = dRow["ItemCode"].ToString(); dsParts = myFunc.FillDataSet("SP_Spare_Get_PartPOInfo", paramPO_Parts); DataRow row = ds.Tables["DCItems"].NewRow(); row["Sno"] = ds.Tables["DCItems"].Rows.Count + 1; row["PartItemNo"] = myFunc.GetStringValuesAgainstCodes("ItemCode", paramPO_Parts[2].Value.ToString(), "PartItemNo", "Item"); row["PartItemName"] = myFunc.GetStringValuesAgainstCodes("ItemCode", paramPO_Parts[2].Value.ToString(), "ItemDesc", "Item"); row["unit"] = myFunc.GetStringValuesAgainstCodes("UnitCode='" + dRow["UnitCode"].ToString() + "'", "unit", "UnitDesc"); row["POQuantity"] = dsParts.Tables[0].Rows[0]["POQty"].ToString(); row["BalanceQuantity"] = dsParts.Tables[0].Rows[0]["BalanceQty"].ToString(); if (DCNumber == "") { row["DCQuantity"] = dsParts.Tables[0].Rows[0]["BalanceQty"].ToString(); } else { row["DCQuantity"] = myFunc.GetDCQty(DCNumber, dRow["ItemCode"].ToString()); } row["Selected"] = true; ds.Tables["DCItems"].Rows.Add(row); } //if (GridViewDC.VisibleRowCount > 0) //{ // CheckBox chkSelect; // TextBox txtDCQty; // Label lblBalQty; // foreach (GridViewRow gvr in GridViewDC.Rows) // { // chkSelect = (CheckBox)gvr.Cells[0].FindControl("ChkSelect"); // txtDCQty = (TextBox)gvr.Cells[6].FindControl("txtDCQuantity"); // lblBalQty = (Label)gvr.Cells[5].FindControl("LbBalanceQuantity"); // chkSelect.Checked = true; // txtDCQty.Text = lblBalQty.Text; // //chkSelect.Enabled = false; // } //} //txtVendorNo.Text = dsVendorInfo.Tables[0].Rows[0]["vendorCode"].ToString(); //txtVendorDesc.Text = dsVendorInfo.Tables[0].Rows[0]["vendorDesc"].ToString(); } Session["DCDataSet"] = ds; GridViewDC.DataSource = ds.Tables["DCItems"]; GridViewDC.DataSourceID = null; GridViewDC.DataBind(); } catch (Exception ex) { //ObjGeneral.UserMsg(LbErr, Color.Red, "Error: " + ex.Message, txtDCNo); } }
protected void txtCustomer_TextChanged(object sender, EventArgs e) { if (txtCustomer.Text == "" && txtCellNo.Text == "" && txtCNIC.Text == "" && txtNTN.Text == "" && txtChasisNo.Text == "" && txtEngineNo.Text == "" && txtRegno.Text == "" && txtProduct.Text == "") { sysfun.UserMsg(lblMsg, Color.Red, "Type Something For Search", txtCustomer); return; } SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@CusCode", SqlDbType.VarChar, 50), //1 new SqlParameter("@CellNo", SqlDbType.VarChar, 15), //2 new SqlParameter("@NIC", SqlDbType.VarChar, 15), //3 new SqlParameter("@ChassisNo", SqlDbType.VarChar, 50), //4 new SqlParameter("@EngineNo", SqlDbType.VarChar, 50), //5 new SqlParameter("@Regno", SqlDbType.VarChar, 20), //6 new SqlParameter("@Product", SqlDbType.VarChar, 20) //7 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = txtCustomer.Text.Trim(); param[2].Value = txtCellNo.Text.Trim(); param[3].Value = txtCNIC.Text.Trim(); param[4].Value = txtChasisNo.Text.Trim(); param[5].Value = txtEngineNo.Text.Trim(); param[6].Value = txtRegno.Text.Trim(); param[7].Value = txtProduct.Text.Trim(); #region Comment //sQuery = "Select B.CusDesc Customer , B.CellNo ,A.ChassisNo , A.EngineNo , A.RegNo , V.ProdDesc ProdCode from Customer B " + // "inner join CustomerVehicle A on A.CusCode = B.CusCode and A.DealerCode = B.DealerCode " + // "inner join Vehicle V on A.DealerCode = V.DealerCode and A.ProdCode = V.ProdCode " + // " where B.DealerCode = '" + Session["DealerCode"].ToString() + "' "; //if (txtCellNo.Text.Trim() != string.Empty) //{ // param[0].Value = txtCellNo.Text.Trim(); // //sQuery = sQuery + " and CellNo like '%" + txtCellNo.Text.Trim() + "%'"; //} //else //{ // param[1].Value = ""; //} //if (txtCustomer.Text.Trim() != string.Empty) //{ // //sQuery = sQuery + " and (B.CusDesc like '%" + txtCustomer.Text.Trim() + "%' or B.CusCode like '%" + txtCustomer.Text.Trim() + "%' )"; //} //if (txtCNIC.Text.Trim() != string.Empty) //{ // //sQuery = sQuery + " and B.NIC like '%" + txtCNIC.Text.Trim() + "%' "; //} //if (txtNTN.Text.Trim() != string.Empty) //{ // //sQuery = sQuery + " and B.NTNNo like '%" + txtNTN.Text.Trim() + "%' "; //} //if (txtChasisNo.Text.Trim() != string.Empty) //{ // //sQuery = sQuery + " and A.ChassisNo like '%" + txtChasisNo.Text.Trim() + "%' "; //} //if (txtEngineNo.Text.Trim() != string.Empty) //{ // //sQuery = sQuery + " and A.EngineNo like '%" + txtEngineNo.Text.Trim() + "%' "; //} //if (txtRegno.Text.Trim() != string.Empty) //{ // //sQuery = sQuery + " and A.RegNo like '%" + txtRegno.Text.Trim() + "%' "; //} //if (txtProduct.Text.Trim() != string.Empty) //{ // //sQuery = sQuery + " and (V.ProdDesc like '%" + txtProduct.Text.Trim() + "%' or V.ProdCode like '%" + txtProduct.Text.Trim() + "%') "; //} #endregion DataSet ds = new DataSet(); try { ds = sysfuns.FillDataSet("SP_CustomerVehicleSearch", param); gvCusVeh.DataSource = ds.Tables[0]; gvCusVeh.DataBind(); ViewState["Cusveh"] = ds.Tables[0]; ds = sysfuns.FillDataSet("SP_JobCardSearch", param); gvJobCard.DataSource = ds.Tables[0]; gvJobCard.DataBind(); ViewState["JobCard"] = ds.Tables[0]; if (txtChasisNo.Text == "" && txtEngineNo.Text == "" && txtRegno.Text == "" && txtProduct.Text == "") { ds = sysfuns.FillDataSet("SP_CounterSaleSearch", param); gvCounterSale.DataSource = ds.Tables[0]; gvCounterSale.DataBind(); ViewState["CounterSale"] = ds.Tables[0]; ds = sysfuns.FillDataSet("SP_PaymentReceiptSearch", param); gvPaymentReceipt.DataSource = ds.Tables[0]; gvPaymentReceipt.DataBind(); ViewState["PaymentReceipt"] = ds.Tables[0]; ds = sysfuns.FillDataSet("SP_BalanceAmountSearch", param); gvBalanceAmount.DataSource = ds.Tables[0]; gvBalanceAmount.DataBind(); ViewState["BalAmt"] = ds.Tables[0]; if (ds.Tables[0].Rows.Count < 1) { return; } if (ds.Tables[0].Rows[0]["CustomerOustanding"].ToString() != "" && ds.Tables[0].Rows[0]["InsuranceOustanding"].ToString() != "" && ds.Tables[0].Rows[0]["DirectSale"].ToString() != "") { object sumCustOut, sumInsOut, sumDirectSale; sumCustOut = ds.Tables[0].Compute("Sum(CustomerOustanding)", string.Empty); sumInsOut = ds.Tables[0].Compute("Sum(InsuranceOustanding)", string.Empty); sumDirectSale = ds.Tables[0].Compute("Sum(DirectSale)", string.Empty); double sum = Convert.ToDouble(sumCustOut) + Convert.ToDouble(sumInsOut) + Convert.ToDouble(sumDirectSale); lblCusOut.Text = sumCustOut.ToString(); lblInsOut.Text = sumInsOut.ToString(); lblDirectSales.Text = sumDirectSale.ToString(); lblTotalAmount.Text = sum.ToString(); } } } catch (Exception ex) { sysfun.UserMsg(lblMsg, Color.Red, ex.Message); return; } }