public bool Delete(DamageProductProvider provider) { bool IsDelete = false; try { SqlCommand command = new SqlCommand(); this.ConnectionOpen(); command.Connection = Connection; this.BeginTransaction(true); command.Transaction = this.Transaction; command.CommandType = CommandType.StoredProcedure; command.CommandText = StoredProcedureNames.RequisitionSet; command.Parameters.Add("@ID", SqlDbType.Int).Value = provider.ID; command.Parameters.Add("@Option", SqlDbType.Int).Value = DBConstants.DataModificationOption.Delete; command.ExecuteNonQuery(); this.CommitTransaction(); this.ConnectionClosed(); IsDelete = true; } catch (Exception exp) { this.RollbackTransaction(); throw new Exception(exp.Message); } finally { this.ConnectionClosed(); } return(IsDelete); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { AddBlankRowTogvPurchaseProduct(); btnSave.Enabled = true; txtEntryDate.Text = string.Format("{0:dd/MM/yyyy}", DateTime.Now); } else { Page.ClientScript.GetPostBackEventReference(this, String.Empty); String eventTarget = Request["__EVENTTARGET"].IsNullOrEmpty() ? String.Empty : Request["__EVENTTARGET"]; if (Request["__EVENTTARGET"] == "SearchPriceSetup") { var requisitionProvider = new DamageProductProvider(); string code = Request["__EVENTARGUMENT"]; DataTable dt = requisitionProvider.GetByID(code); if (dt.IsNotNull()) { try { for (int k = 0; k < dt.Rows.Count; k++) { txtEntryDate.Text = Convert.ToDateTime(dt.Rows[k][3]).ToString("dd/MM/yyyy"); txtRefNo.Text = dt.Rows[k][2].ToString(); ddlProductDivision.SelectedValue = dt.Rows[k][1].ToString(); } } catch (Exception ex) { throw (ex); } } gvRequisition.DataSource = dt; gvRequisition.DataBind(); btnSave.Visible = false; btnUpdate.Visible = true; } } //if (ckbOption.SelectedValue.Toint() == 3) //{ // txtRefNo.Enabled = false; // txtRequisitionDate.Enabled = false; // ddlRequisitionDivision.Enabled = false; // gvRequisition.Enabled = false; // btnAdd.Enabled = false; // btnUpdate.Enabled = false; //} Session["Value"] = ddlProductDivision.SelectedValue; }
private DamageProductProvider RequisitionInfoEntity() { DamageProductProvider entity = null; entity = new DamageProductProvider { ReferenceNo = txtRefNo.Text, TransactionDate = DateTime.ParseExact(txtEntryDate.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture), RequisitionDate = DateTime.ParseExact(txtEntryDate.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture), DivisionID = int.Parse(ddlProductDivision.SelectedValue), EntryUserID = Convert.ToInt16(Session["ID"]), UpdateUserID = Convert.ToInt16(Session["ID"]) }; return(entity); }
private SqlCommand ProcedureFunction(DamageProductProvider provider) { SqlCommand command = new SqlCommand(); this.ConnectionOpen(); command.Connection = Connection; this.BeginTransaction(true); command.Transaction = this.Transaction; command.CommandType = CommandType.StoredProcedure; command.CommandText = StoredProcedureNames.RequisitionSet; command.Parameters.Add("@TransactionNo", SqlDbType.VarChar).Value = provider.TransactionNo; command.Parameters.Add("@ReferenceNo", SqlDbType.VarChar).Value = provider.ReferenceNo; command.Parameters.Add("@RequisitionDate", SqlDbType.DateTime).Value = provider.RequisitionDate; command.Parameters.Add("@DivisionID", SqlDbType.VarChar).Value = provider.DivisionID; return(command); }
protected void btnSave_Click(object sender, EventArgs e) { mode = "Save"; string permisionMessage = CheckUserAuthentication(mode); if (String.IsNullOrEmpty(permisionMessage) && string.IsNullOrEmpty(statusMessage)) { bool msg = false; string message = string.Empty; string transactionNo = string.Empty; try { DamageProductProvider requisitionProvider = RequisitionInfoEntity(); List <DamageProductDetailProvider> requisitionDetailList = requisitionDetailEntityList(); if ((requisitionDetailList == null) || (requisitionDetailList.Count == 0)) { MessageHelper.ShowAlertMessage("Please select at least one product for purchase"); return; } msg = requisitionProvider.Save(requisitionDetailList, out transactionNo); } catch (Exception ex) { message = ex.Message; } if (msg) { Clear(); txtRefNo.Text = transactionNo; this.AlertSuccess(lblMsg, MessageConstants.Saved); } else { MessageHelper.ShowAlertMessage(message); } } else { MessageHelper.ShowAlertMessage(permisionMessage + statusMessage); } }
public bool Save(DamageProductProvider RequisitionProvider, List <DamageProductDetailProvider> RequisitionDetailProviderList, out string transactionNo) { bool IsSave = false; try { SqlCommand command = new SqlCommand(); this.ConnectionOpen(); command.Connection = Connection; this.BeginTransaction(true); command.Transaction = this.Transaction; command.CommandType = CommandType.StoredProcedure; command.CommandText = StoredProcedureNames.DamagedProductSet; SqlParameter t = new SqlParameter("@TransactionNo", SqlDbType.VarChar); t.Direction = ParameterDirection.Output; t.Size = 16; command.Parameters.Add(t); SqlParameter id = new SqlParameter("@ID", SqlDbType.Int); id.Direction = ParameterDirection.Output; command.Parameters.Add(id); command.Parameters.Add("@RequisitionDate", SqlDbType.DateTime).Value = RequisitionProvider.RequisitionDate; command.Parameters.Add("@DivisionID", SqlDbType.VarChar).Value = RequisitionProvider.DivisionID; command.Parameters.Add("@EntryUserID", SqlDbType.Int).Value = RequisitionProvider.EntryUserID; command.Parameters.Add("@StatusID", SqlDbType.Int).Value = RequisitionProvider.StatusID; command.Parameters.Add("@Option", SqlDbType.Int).Value = DBConstants.DataModificationOption.Insert; command.ExecuteNonQuery(); transactionNo = (string)command.Parameters["@TransactionNo"].Value; int RequisitionID = (int)command.Parameters["@ID"].Value; foreach (DamageProductDetailProvider RequisitionDetailsProvider in RequisitionDetailProviderList) { command = new SqlCommand(); command.Connection = Connection; command.Transaction = this.Transaction; command.CommandType = CommandType.StoredProcedure; command.CommandText = StoredProcedureNames.DamagedProductDetailSet; command.Parameters.Add("@RequisitionID", SqlDbType.Int).Value = RequisitionID; command.Parameters.Add("@ProductID", SqlDbType.Int).Value = RequisitionDetailsProvider.ProductID; command.Parameters.Add("@RequiredQuantity", SqlDbType.Decimal).Value = RequisitionDetailsProvider.DamageQuantity; command.Parameters.Add("@Remarks", SqlDbType.VarChar).Value = RequisitionDetailsProvider.Remarks; command.Parameters.Add("@Option", SqlDbType.Int).Value = DBConstants.DataModificationOption.Insert; command.ExecuteNonQuery(); } ///////////////////////////////////////////// For stock in and out ///////////////////////////////////////////// command = new SqlCommand(); command.Connection = Connection; command.Transaction = this.Transaction; command.CommandType = CommandType.StoredProcedure; command.CommandText = StoredProcedureNames.ProductRetRejDamageSet; SqlParameter id1 = new SqlParameter("@ID", SqlDbType.Int); id1.Direction = ParameterDirection.Output; command.Parameters.Add(id1); command.Parameters.Add("@TransactionNo", SqlDbType.VarChar, 16).Value = transactionNo; command.Parameters.Add("@TransactionTypeID", SqlDbType.Int).Value = 38; // For ProductDamage command.Parameters.Add("@EntryUserID", SqlDbType.Int).Value = RequisitionProvider.EntryUserID; command.Parameters.Add("@Option", SqlDbType.Int).Value = DBConstants.DataModificationOption.Insert; command.ExecuteNonQuery(); int ParentID = (int)command.Parameters["@ID"].Value; command = new SqlCommand(); command.Connection = Connection; command.Transaction = this.Transaction; command.CommandText = "DELETE FROM Inventory.ProductRetRejDamageDetail WHERE ParentID = " + ParentID + " "; command.ExecuteNonQuery(); foreach (DamageProductDetailProvider productionRequisitionDetailProvider in RequisitionDetailProviderList) { command = new SqlCommand(); command.Connection = Connection; command.Transaction = this.Transaction; command.CommandType = CommandType.StoredProcedure; command.CommandText = StoredProcedureNames.ProductRetRejDamageDetailSet; command.Parameters.Add("@ParentID", SqlDbType.Int).Value = ParentID; command.Parameters.Add("@ProductID", SqlDbType.Int).Value = productionRequisitionDetailProvider.ProductID; command.Parameters.Add("@ReceivedQuantity", SqlDbType.Decimal).Value = 0; command.Parameters.Add("@SentQuantity", SqlDbType.Decimal).Value = productionRequisitionDetailProvider.DamageQuantity; command.Parameters.Add("@Option", SqlDbType.Int).Value = DBConstants.DataModificationOption.Insert; command.ExecuteNonQuery(); } this.CommitTransaction(); this.ConnectionClosed(); IsSave = true; } catch (Exception exp) { this.RollbackTransaction(); throw new Exception(exp.Message); } finally { this.ConnectionClosed(); } return(IsSave); }