protected void BinDAgentInfo() { AgentInfoData agent = new AgentInfoData(); DS = agent.GetAllAgentDetails(); if (!Comman.Comman.IsDataSetEmpty(DS)) { int count = Convert.ToInt32(DS.Tables[1].Rows[0]["id"]); count = count + 1; //txtAgentCode.Text = string.Format("A{0:0000}", count++); rpAgentINfo.DataSource = DS; rpAgentINfo.DataBind(); } }
public void AddAgentShemeDetails(int dbagentinfo) { AgentInfoData agentInfoData = new AgentInfoData(); DataSet DS = new DataSet(); DS = agentInfoData.GetAgentbyID(dbagentinfo); if (!Comman.Comman.IsDataSetEmpty(DS)) { //txtSchemeAmount.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["SchemeAmount"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["SchemeAmount"].ToString(); Invoice invocie = new Invoice(); InvoiceData invicedata = new InvoiceData(); invocie.TokanId = hftokanno.Value; invocie.UserID = GlobalInfo.Userid; invocie.TypeID = 0; invocie.ProductID = 0; invocie.qty = 0; invocie.totalCoast = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["SchemeAmount"].ToString()) ? 0 : Convert.ToDouble(DS.Tables[0].Rows[0]["SchemeAmount"]); invocie.SchemeAmount = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["SchemeAmount"].ToString()) ? 0 : Convert.ToDouble(DS.Tables[0].Rows[0]["SchemeAmount"]); invocie.TotalSchemeAmount = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["TotalSchemeAmount"].ToString()) ? 0 : Convert.ToDouble(DS.Tables[0].Rows[0]["TotalSchemeAmount"]); invocie.TotalSchemeAmount = invocie.TotalSchemeAmount + invocie.SchemeAmount; schemeTemp = invocie.TotalSchemeAmount; if (invocie.SchemeAmount > 0) { schemeApplied = true; invicedata.Booth_InsertTempInvoiceItam(invocie); BindAgntTempItam(invocie); } else { schemeApplied = false; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Scheme not available')", true); dpAgentShemeApplied.ClearSelection(); } } }
public void GetAgentbyID(int dbagentinfo) { txtAgentCode.Enabled = true; AgentInfoData agentInfoData = new AgentInfoData(); DataSet DS = new DataSet(); DS = agentInfoData.GetAgentbyID(dbagentinfo); if (!Comman.Comman.IsDataSetEmpty(DS)) { txtAgentCode.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["AgentCode"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["AgentCode"].ToString(); dpRoute.ClearSelection(); if (dpRoute.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["RouteID"]).ToString()) != null) { dpRoute.Items.FindByValue(Convert.ToInt32(DS.Tables[0].Rows[0]["RouteID"]).ToString()).Selected = true; } txtAgentName.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["AgentName"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["AgentName"].ToString(); //string DateofJoining = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["DateofJoining"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["DateofJoining"].ToString(); //if (!string.IsNullOrEmpty(DateofJoining)) //{ // txtDateOfJoing.Text = (Convert.ToDateTime(DateofJoining).ToString("yyyy-MM-dd")); //} string DateofJoiningstring = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["DateofJoining"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["DateofJoining"].ToString(); //sky DateTime date1 = Convert.ToDateTime(DateofJoiningstring, System.Globalization.CultureInfo.GetCultureInfo("ur-PK").DateTimeFormat); txtDateOfJoing.Text = (Convert.ToDateTime(date1).ToString("yyyy-MM-dd")); txtApprovedBy.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["AppriveBy"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["AppriveBy"].ToString(); dpStatus.ClearSelection(); if (DS.Tables[0].Rows[0]["Isactive"].ToString() == "True") { dpStatus.Items.FindByValue("1").Selected = true; } if (DS.Tables[0].Rows[0]["Isactive"].ToString() == "False") { dpStatus.Items.FindByValue("2").Selected = true; } //dpEmployeeID.ClearSelection(); //if (dpEmployeeID.Items.FindByValue(DS.Tables[0].Rows[0]["EmployeeID"].ToString()) != null) //{ // dpEmployeeID.Items.FindByValue(DS.Tables[0].Rows[0]["EmployeeID"].ToString()).Selected = true; //} dpAgencyType.ClearSelection(); if (dpAgencyType.Items.FindByText(DS.Tables[0].Rows[0]["Agensytype"].ToString()) != null) { dpAgencyType.Items.FindByText(DS.Tables[0].Rows[0]["Agensytype"].ToString()).Selected = true; } txtAddress1.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Address1"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Address1"].ToString(); txtAddress2.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Address2"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Address2"].ToString(); txtAddress3.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Address2"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Address2"].ToString(); txtEmail.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Email"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Email"].ToString(); txtTelephone.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["TelephoneNo"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["TelephoneNo"].ToString(); txtMobile.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["MobileNo"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["MobileNo"].ToString(); //dpDistrict.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Districk"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Districk"].ToString(); //txtCity.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["City"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["City"].ToString(); dpDistric.ClearSelection(); if (dpDistric.Items.FindByText(DS.Tables[0].Rows[0]["Districk"].ToString()) != null) { dpDistric.Items.FindByText(DS.Tables[0].Rows[0]["Districk"].ToString()).Selected = true; } dpCity.ClearSelection(); if (dpCity.Items.FindByText(DS.Tables[0].Rows[0]["City"].ToString()) != null) { dpCity.Items.FindByText(DS.Tables[0].Rows[0]["City"].ToString()).Selected = true; } dpState.ClearSelection(); if (dpState.Items.FindByText(DS.Tables[0].Rows[0]["State"].ToString()) != null) { dpState.Items.FindByText(DS.Tables[0].Rows[0]["State"].ToString()).Selected = true; } dpCountry.ClearSelection(); if (dpCountry.Items.FindByText(DS.Tables[0].Rows[0]["Country"].ToString()) != null) { dpCountry.Items.FindByText(DS.Tables[0].Rows[0]["Country"].ToString()).Selected = true; } dpbillingtype.ClearSelection(); if (dpbillingtype.Items.FindByText(DS.Tables[0].Rows[0]["BillingMethod"].ToString()) != null) { dpbillingtype.Items.FindByText(DS.Tables[0].Rows[0]["BillingMethod"].ToString()).Selected = true; } dppaymenttype.ClearSelection(); if (dppaymenttype.Items.FindByText(DS.Tables[0].Rows[0]["PaymentMode"].ToString()) != null) { dppaymenttype.Items.FindByText(DS.Tables[0].Rows[0]["PaymentMode"].ToString()).Selected = true; } txtDepositeAmount.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["DepositeAmount"].ToString()) ? string.Empty : string.Format("{0:0.#####}", DS.Tables[0].Rows[0]["DepositeAmount"].ToString()); dpBankName.ClearSelection(); if (dpBankName.Items.FindByText(DS.Tables[0].Rows[0]["BankName"].ToString()) != null) { dpBankName.Items.FindByText(DS.Tables[0].Rows[0]["BankName"].ToString()).Selected = true; } //txtBankName.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Bankname"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Bankname"].ToString(); txtAccountNo.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["AccountNo"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["AccountNo"].ToString(); dpAccountType.ClearSelection(); if (dpAccountType.Items.FindByText(DS.Tables[0].Rows[0]["AccountType"].ToString()) != null) { dpAccountType.Items.FindByText(DS.Tables[0].Rows[0]["AccountType"].ToString()).Selected = true; } // txtIfscCode.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["IFScode"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["IFScode"].ToString(); dpIfscCode.ClearSelection(); if (dpIfscCode.Items.FindByText(DS.Tables[0].Rows[0]["IFScode"].ToString()) != null) { dpIfscCode.Items.FindByText(DS.Tables[0].Rows[0]["IFScode"].ToString()).Selected = true; } txtValoume.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Volume"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Volume"].ToString(); txtNoOfTrays.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["NoTrays"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["NoTrays"].ToString(); dpDoorToDoor.ClearSelection(); if (DS.Tables[0].Rows[0]["DoorToDoor"].ToString() == "True") { dpDoorToDoor.Items.FindByValue("1").Selected = true; } if (DS.Tables[0].Rows[0]["DoorToDoor"].ToString() == "False") { dpDoorToDoor.Items.FindByValue("2").Selected = true; } if (DS.Tables[0].Rows[0]["FreezerAvailable"].ToString() == "True") { rbcFreezerYes.Checked = true; } if (DS.Tables[0].Rows[0]["FreezerAvailable"].ToString() == "False") { rbcFreezerNo.Checked = true; } if (DS.Tables[0].Rows[0]["FreezerRetrun"].ToString() == "True") { rbFreezerRestrunYes.Checked = true; } if (DS.Tables[0].Rows[0]["FreezerRetrun"].ToString() == "False") { rbFreezerRestrunNo.Checked = true; } // string Deactivedate = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Deactivedate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Deactivedate"].ToString(); if (DS.Tables[0].Rows[0]["Deactivedate"].ToString() == "") { txtDeactivedate.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Deactivedate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Deactivedate"].ToString(); } else { string DateofDeactivation = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Deactivedate"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["Deactivedate"].ToString(); //sky DateTime date2 = Convert.ToDateTime(DateofDeactivation, System.Globalization.CultureInfo.GetCultureInfo("ur-PK").DateTimeFormat); txtDeactivedate.Text = (Convert.ToDateTime(date2).ToString("yyyy-MM-dd")); } txtDeactiveRession.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["DeactiveReason"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["DeactiveReason"].ToString(); txtAmountRetrun.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["AmountReturned"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["AmountReturned"].ToString(); txtTraysReturned.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["TraysReturned"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["TraysReturned"].ToString(); txtSchemeAmount.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["SchemeAmount"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["SchemeAmount"].ToString(); txtSchemeTotalAmount.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["TotalSchemeAmount"].ToString()) ? string.Empty : DS.Tables[0].Rows[0]["TotalSchemeAmount"].ToString(); } }
public void DeleteAgentbyID(int AgentId) { AgentInfo agentInfo = new AgentInfo(); AgentInfoData agentData = new AgentInfoData(); int Result = 0; agentInfo.AgentID = Convert.ToInt32(hfAgentID.Value); agentInfo.AgentCode = string.Empty; agentInfo.RouteID = 0; agentInfo.AgentName = string.Empty; agentInfo.DateofJoining = string.Empty; agentInfo.AppriveBy = string.Empty; if (dpStatus.SelectedItem.Value == "1") { agentInfo.Status = true; } if (dpStatus.SelectedItem.Value == "2") { agentInfo.Status = true; } //agentInfo.EmployeeID = 0; agentInfo.Agensytype = string.Empty; agentInfo.Address1 = string.Empty; agentInfo.Address2 = string.Empty; agentInfo.Address3 = string.Empty; agentInfo.Email = string.Empty; agentInfo.TelephoneNo = string.Empty; agentInfo.MobileNo = string.Empty; agentInfo.Districk = string.Empty; agentInfo.City = string.Empty; agentInfo.State = string.Empty; agentInfo.Country = string.Empty; agentInfo.BillingMethod = string.Empty; agentInfo.PaymentType = string.Empty; agentInfo.DepositAmount = 0; agentInfo.BankName = string.Empty; agentInfo.AccounNo = string.Empty; agentInfo.AccountType = string.Empty; agentInfo.IFSCCode = string.Empty; agentInfo.Volume = string.Empty; agentInfo.NoofTrays = 0; agentInfo.DoortoDoor = false; agentInfo.FreezerAvailable = false; agentInfo.Deactivedate = string.Empty; agentInfo.DeactiveReason = string.Empty; agentInfo.AmountReturned = 0; agentInfo.TraysReturned = 0; agentInfo.SchemeAmount = 0; // string.IsNullOrEmpty(txtAmountRetrun.Text) ? 0 : Convert.ToDouble(txtSchemeAmount.Text); agentInfo.SchemeTotalAmount = 0; // string.IsNullOrEmpty(txtAmountRetrun.Text) ? 0 : Convert.ToDouble(txtSchemeAmountShemeTotalAmount.Text); agentInfo.IsArchive = true; agentInfo.CreatedBy = GlobalInfo.Userid; agentInfo.Createddate = DateTime.Now.ToString("dd-MM-yyyy"); agentInfo.ModifiedBy = GlobalInfo.Userid; agentInfo.ModifiedDate = DateTime.Now.ToString("dd-MM-yyyy"); agentInfo.flag = "Delete"; Result = agentData.InsertAgentInfo(agentInfo); if (Result > 0) { divDanger.Visible = false; divwarning.Visible = false; divSusccess.Visible = true; lblSuccess.Text = "Agent Delete Successfully"; btnAddagent.Visible = true; btnupdateagent.Visible = false; BinDAgentInfo(); pnlError.Update(); } else { divDanger.Visible = false; divwarning.Visible = true; divSusccess.Visible = false; lblwarning.Text = "Please Contact to Site Admin"; pnlError.Update(); } }
protected void btnUpdate_click(object sender, EventArgs e) { AgentInfo agentInfo = new AgentInfo(); AgentInfoData agentData = new AgentInfoData(); int Result = 0; agentInfo.AgentID = Convert.ToInt32(hfAgentID.Value); agentInfo.AgentCode = txtAgentCode.Text; agentInfo.RouteID = Convert.ToInt32(dpRoute.SelectedItem.Value); agentInfo.AgentName = txtAgentName.Text; agentInfo.DateofJoining = txtDateOfJoing.Text; agentInfo.AppriveBy = txtApprovedBy.Text; if (dpStatus.SelectedItem.Value == "1") { agentInfo.Status = true; } if (dpStatus.SelectedItem.Value == "2") { agentInfo.Status = false; } //agentInfo.EmployeeID = 1;// Convert.ToInt32(dpEmployeeID.SelectedItem.Value); agentInfo.Agensytype = dpAgencyType.SelectedItem.Text; agentInfo.Address1 = txtAddress1.Text; agentInfo.Address2 = txtAddress2.Text; agentInfo.Address3 = txtAddress3.Text; agentInfo.Email = txtEmail.Text;; agentInfo.TelephoneNo = txtTelephone.Text;; agentInfo.MobileNo = txtMobile.Text; agentInfo.Districk = dpDistric.SelectedItem.Text; agentInfo.City = dpCity.SelectedItem.Text; agentInfo.State = dpState.SelectedItem.Text; agentInfo.Country = dpCountry.SelectedItem.Text; agentInfo.BillingMethod = dpbillingtype.SelectedItem.Text; agentInfo.PaymentType = dppaymenttype.SelectedItem.Text;; agentInfo.DepositAmount = string.IsNullOrEmpty(txtDepositeAmount.Text) ? 0 : Convert.ToDouble(txtDepositeAmount.Text); agentInfo.BankName = dpBankName.SelectedItem.Text; agentInfo.AccounNo = txtAccountNo.Text; agentInfo.AccountType = dpAccountType.SelectedItem.Text; agentInfo.IFSCCode = dpIfscCode.SelectedItem.Text; agentInfo.Volume = txtValoume.Text; agentInfo.NoofTrays = string.IsNullOrEmpty(txtNoOfTrays.Text) ? 0 : Convert.ToInt32(txtNoOfTrays.Text); if (dpDoorToDoor.SelectedItem.Value == "1") { agentInfo.DoortoDoor = true; } if (dpDoorToDoor.SelectedItem.Value == "1") { agentInfo.DoortoDoor = false; } if (rbcFreezerYes.Checked == true) { agentInfo.FreezerAvailable = true; } if (rbcFreezerNo.Checked == true) { agentInfo.FreezerAvailable = false; } if (rbFreezerRestrunYes.Checked == true) { agentInfo.FreezerRestrun = true; } if (rbFreezerRestrunNo.Checked == true) { agentInfo.FreezerRestrun = false; } if (txtDeactivedate.Text == "") { agentInfo.Deactivedate = txtDeactivedate.Text; } else { agentInfo.Deactivedate = (Convert.ToDateTime(txtDeactivedate.Text)).ToString("dd-MM-yyyy"); } agentInfo.DeactiveReason = Convert.ToString(txtDeactiveRession.Text); agentInfo.AmountReturned = string.IsNullOrEmpty(txtAmountRetrun.Text) ? 0 : Convert.ToDouble(txtAmountRetrun.Text); agentInfo.TraysReturned = string.IsNullOrEmpty(txtTraysReturned.Text) ? 0 : Convert.ToInt32(txtTraysReturned.Text); agentInfo.SchemeAmount = string.IsNullOrEmpty(txtSchemeAmount.Text) ? 0 : Convert.ToDouble(txtSchemeAmount.Text); agentInfo.SchemeTotalAmount = string.IsNullOrEmpty(txtSchemeTotalAmount.Text) ? 0 : Convert.ToDouble(txtSchemeTotalAmount.Text); agentInfo.IsArchive = false; agentInfo.CreatedBy = GlobalInfo.Userid; agentInfo.Createddate = DateTime.Now.ToString("dd-MM-yyyy"); agentInfo.ModifiedBy = GlobalInfo.Userid; agentInfo.ModifiedDate = DateTime.Now.ToString("dd-MM-yyyy"); agentInfo.flag = "Update"; Result = agentData.InsertAgentInfo(agentInfo); if (Result > 0) { divDanger.Visible = false; divwarning.Visible = false; divSusccess.Visible = true; lblSuccess.Text = "Agent Updated Successfully"; btnAddagent.Visible = true; btnupdateagent.Visible = false; Clear(); BinDAgentInfo(); upMain.Update(); pnlError.Update(); uprouteList.Update(); //txtAgentCode.Enabled = false; } else { divDanger.Visible = false; divwarning.Visible = true; divSusccess.Visible = false; lblWarningHead.Text = " Please Contact to Site Admin"; lblwarning.Text = Comman.Comman.msg.ToString(); pnlError.Update(); } }