protected void btnSave_Click(object sender, EventArgs e) { TblClientAccount obj = new TblClientAccount(); string msg = "Client detail has been added!"; obj.IsNew = true; if (!String.IsNullOrEmpty(hfSerialNo.Value)) { obj.IsNew = false; obj = new TblClientAccount(hfSerialNo.Value); msg = "Client detail has been updated!"; } obj.Clientid = Convert.ToInt32(ddlClientName.SelectedValue); obj.ReciptNo = Convert.ToInt32(txtRecieptNo.Text); obj.DateX = Convert.ToDateTime(Convert.ToDateTime(txtPetrolDate.SelectedDate).ToShortDateString() + " " + getDateTime().ToString("h:mm:ss")); obj.VehicleNo = txtVehicleNo.Text; obj.Liters = Convert.ToDouble(txtLiters.Text); obj.Rate = Convert.ToDecimal(txtRate.Text); obj.Amount = Convert.ToDecimal(Convert.ToDouble(txtLiters.Text) * Convert.ToDouble(txtRate.Text)); obj.Received = null; obj.Dsicount = Convert.ToDecimal(txtDiscount.Text); obj.Description = txtPetrolDescription.Text; obj.Save(); lblmsg.Text = MessageBox.Show(msgDiv, msg, "alert alert-success alert-icon alert-dismissible", icon, "glyphicon glyphicon-ok-sign"); string id = ddlClientName.SelectedValue; ClearInputs(Page.Controls); ddlClientName.SelectedValue = id; hfSerialNo.Value = null; BindGrid(Convert.ToInt32(ddlClientName.SelectedValue)); txtPetrolDate.SelectedDate = null; txtTotalAmount.Text = string.Empty; }
protected void lnkFrwdDelete_Click(object sender, EventArgs e) { int CompanyID = Convert.ToInt32(Session["FrCompanyID"]); LinkButton btn = (LinkButton)sender; TblCompanyAccountDetail objCmpAc = new TblCompanyAccountDetail(CompanyID); ScriptManager.GetCurrent(this).RegisterAsyncPostBackControl(btn); TblClientAccount.Delete(TblClientAccount.Columns.Fid, btn.CommandArgument); TblFarwordAmount.Delete(btn.CommandArgument); lblmsg2.Text = MessageBox.Show(msgDiv2, "Record has been deleted!", "alert alert-success alert-icon alert-dismissible", icon, "glyphicon glyphicon-ok-sign"); LoadFrwdAmount(objCmpAc.SerialNo); }
protected void lnkDelete_Click(object sender, EventArgs e) { LinkButton btn = (LinkButton)sender; TblClientAccount obj = new TblClientAccount(btn.CommandArgument); if (obj.Fid != null) { TblFarwordAmount.Delete(obj.Fid); } TblClientAccount.Delete(btn.CommandArgument); lblmsg.Text = MessageBox.Show(msgDiv, "Record has been deleted!", "alert alert-success alert-icon alert-dismissible", icon, "glyphicon glyphicon-ok-sign"); string id = ddlClientName.SelectedValue; ClearInputs(Page.Controls); ddlClientName.SelectedValue = id; BindGrid(Convert.ToInt32(ddlClientName.SelectedValue)); }
protected void lnkEdit_Click(object sender, EventArgs e) { LinkButton btn = (LinkButton)sender; TblClientAccount obj = new TblClientAccount(btn.CommandArgument); if (String.IsNullOrEmpty(obj.Liters.ToString()) && !String.IsNullOrEmpty(obj.Amount.ToString())) //ShowPaidPopUp { txtPaidDescription.Text = obj.Description; txtPaidAmmount.Text = obj.Amount.ToString(); txtPaidReciept.Text = obj.ReciptNo.ToString(); ddlPaidClientName.SelectedValue = obj.Clientid.ToString(); txtVehiclePaid.Text = Convert.ToString(obj.VehicleNo); txtPaidDate.SelectedDate = obj.DateX; ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "openModal('#PaidformPopUp');", true); } else if (!String.IsNullOrEmpty(obj.Liters.ToString()) && !String.IsNullOrEmpty(obj.Amount.ToString())) //MainForm { txtTotalAmount.Text = obj.Amount.ToString(); txtDiscount.Text = obj.Dsicount.ToString(); txtVehicleNo.Text = obj.VehicleNo; txtPetrolDescription.Text = obj.Description; txtRate.Text = obj.Rate.ToString(); txtRecieptNo.Text = obj.ReciptNo.ToString(); txtLiters.Text = obj.Liters.ToString(); ddlClientName.SelectedValue = obj.Clientid.ToString(); txtPetrolDate.SelectedDate = obj.DateX; } else if (!String.IsNullOrEmpty(obj.Received.ToString())) //ShowRecievedPopUp { ddlRecievedClientName.SelectedValue = obj.Clientid.ToString(); txtRecievdReceiptNo.Text = obj.ReciptNo.ToString(); txtRecivedAmmount.Text = obj.Received.ToString(); txtRecivedDescription.Text = obj.Description; txtRecivedDate.SelectedDate = obj.DateX; ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "openModal('#RecivedformPopUp');", true); } hfSerialNo.Value = btn.CommandArgument; }
protected void btnFrwrdAmount_Click(object sender, EventArgs e) { #region //TblFarwordAmount obj = new TblFarwordAmount(); //TblClientAccount objClientAcount = new TblClientAccount(); //obj.IsNew = true; //objClientAcount.IsNew = true; //DataTable dt = ExecutePlainQuery("select * from tbl_FarwordAmount where SerialNo=" + hfCompanyID.Value); //if (dt.Rows.Count > 0) //{ // obj.IsNew = false; // objClientAcount.IsNew = false; // obj = new TblFarwordAmount(TblFarwordAmount.Columns.SerialNo, hfCompanyID.Value); //} //obj.Rate = Convert.ToDouble(txtfrwrdRate.Text); //obj.Quantity = Convert.ToDouble(txtfrwrdQuantity.Text); //obj.SerialNo = Convert.ToInt32(hfCompanyID.Value); //obj.ClientID = Convert.ToInt32(ddlCLient.SelectedValue); //obj.Save(); //TblCompanyAccountDetail objCmpAc = new TblCompanyAccountDetail(hfCompanyID.Value); //objClientAcount.Liters = Convert.ToDouble(obj.Quantity); //objClientAcount.Clientid = Convert.ToInt32(ddlCLient.SelectedValue); //objClientAcount.Rate = Convert.ToDecimal(txtfrwrdRate.Text); //objClientAcount.Description = objCmpAc.CategoryID == 1 ? "Forwaded PMG" : "Forwaded HSD"; //objClientAcount.Amount = Convert.ToDecimal(obj.Quantity * obj.Rate); //objClientAcount.Fid = obj.Fid; //objClientAcount.DateX = objCmpAc.DateX; //objClientAcount.Save(); //TblClient objClientName = new TblClient(ddlCLient.SelectedValue); #endregion int CompanyID = Convert.ToInt32(Session["FrCompanyID"]); int FrwdID = Convert.ToInt32(Session["FID"]); TblCompanyAccountDetail objCmpAc = new TblCompanyAccountDetail(CompanyID); TblFarwordAmount obj = new TblFarwordAmount(); TblClientAccount objClientAcount = new TblClientAccount(); string msg = "Amount has been forwaded to " + ddlCLient.SelectedItem.Text; if (Session["FID"] != null) { obj = new TblFarwordAmount(FrwdID); obj.IsNew = false; objClientAcount = new TblClientAccount(TblClientAccount.Columns.Fid, FrwdID); objClientAcount.IsNew = false; msg = "Farwaded amount detail has been updated!"; } obj.Rate = Convert.ToDouble(txtfrwrdRate.Text); obj.Quantity = Convert.ToDouble(txtfrwrdQuantity.Text); obj.SerialNo = Convert.ToInt32(CompanyID); obj.ClientID = Convert.ToInt32(ddlCLient.SelectedValue); obj.CategoryID = objCmpAc.CategoryID; obj.Save(); objClientAcount.Liters = Convert.ToDouble(txtfrwrdQuantity.Text); objClientAcount.Clientid = Convert.ToInt32(ddlCLient.SelectedValue); objClientAcount.Rate = Convert.ToDecimal(txtfrwrdRate.Text); objClientAcount.Description = objCmpAc.CategoryID == 1 ? "Forwaded PMG" : "Forwaded HSD"; objClientAcount.Amount = Convert.ToDecimal(obj.Quantity * obj.Rate); objClientAcount.Fid = obj.Fid; objClientAcount.DateX = Convert.ToDateTime(Convert.ToDateTime(objCmpAc.DateX).ToShortDateString() + " " + getDateTime().ToString("h:mm:ss")); objClientAcount.Save(); lblmsg2.Text = MessageBox.Show(msgDiv2, msg, "alert alert-success alert-icon alert-dismissible", icon, "glyphicon glyphicon-ok-sign"); LoadFrwdAmount(objCmpAc.SerialNo); Session["FID"] = null; //Session["CompanyID"] = null; ClearInputs(Controls); }