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);
}
