public static int Purchase_RequisitionDetails_Save(Entity.Purchase.PurchaseRequisition purchase)
{
int rowsAffacted = 0;
foreach (Entity.Purchase.PurchaseRequisitionDetails purchasedetails in purchase.PurchaseRequisitionDetailsCollection)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "usp_Purchase_RequisitionDetails_Save";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PurchaseRequisitionDetailsId", purchasedetails.PurchaseRequisitionDetailsId);
cmd.Parameters.AddWithValue("@PurchaseRequisitionId", purchasedetails.PurchaseRequisitionId);
cmd.Parameters.AddWithValue("@ItemId", purchasedetails.ItemId);
cmd.Parameters.AddWithValue("@ItemType", purchasedetails.ItemType);
cmd.Parameters.AddWithValue("@Quantity", purchasedetails.Quantity);
cmd.Parameters.AddWithValue("@UOM", purchasedetails.UOM);
cmd.Parameters.AddWithValue("@Description", purchasedetails.Description);
cmd.Parameters.AddWithValue("@ApprovalStatus", purchasedetails.ApprovalStatus);
cmd.Parameters.AddWithValue("@Error", string.Empty).Direction = ParameterDirection.InputOutput;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
rowsAffacted += cmd.ExecuteNonQuery();
con.Close();
}
}
}
return(rowsAffacted);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (Validation())
{
Entity.Purchase.PurchaseRequisition purchase = new Entity.Purchase.PurchaseRequisition();
Business.Purchase.PurchaseRequisition objPurchase = new Business.Purchase.PurchaseRequisition();
Entity.Purchase.PurchaseDetails purchaseDetails = new Entity.Purchase.PurchaseDetails();
purchase.PurchaseRequisitionNo = (!string.IsNullOrEmpty(txtPurchaseRequisitionNo.Text.Trim())) ? txtPurchaseRequisitionNo.Text.Trim() : string.Empty;
purchase.RequisitionDate = Convert.ToDateTime(txtPurchaseRequisitionDate.Text.Trim());
purchase.PurchaseDepartment = txtPurchaseDepartment.Text.Trim();
purchase.VendorId = Convert.ToInt32(ddlVendor.SelectedValue);
purchase.WhenNeeded = Convert.ToDateTime(txtPurchaseRequisitionDate.Text.Trim());
purchase.PurposeOfRequisition = txtPurposeOfRequisition.Text.Trim();
purchase.CreatedBy = Convert.ToInt32(HttpContext.Current.User.Identity.Name);
Int64 purchaseRequisitionId = objPurchase.PurchaseRequisition_Save(purchase);
foreach (DataRow drItem in _ItemsList.Rows)
{
purchase.PurchaseRequisitionDetailsCollection.Add(
new Entity.Purchase.PurchaseRequisitionDetails()
{
PurchaseRequisitionId = purchaseRequisitionId,
ItemId = Convert.ToInt32(drItem["ItemIdType"].ToString().Split('|')[0]),
ItemType = Convert.ToInt32(drItem["ItemIdType"].ToString().Split('|')[1]),
Quantity = (drItem["Quantity"] != null && !string.IsNullOrEmpty(drItem["Quantity"].ToString())) ? Convert.ToDecimal(drItem["Quantity"].ToString()) : 0,
UOM = 1,
Description = (drItem["Description"] != null && !string.IsNullOrEmpty(drItem["Description"].ToString())) ? drItem["Description"].ToString() : string.Empty,
ApprovalStatus = (int)ApprovalStatus.None
});
}
int purchaseDetailsResponse = objPurchase.Purchase_RequisitionDetails_Save(purchase);
if (purchaseDetailsResponse > 0)
{
ClearMasterControls();
ClearItemControls();
LoadItemList();
Message.IsSuccess = true;
Message.Text = "Purchase requisition saved";
}
else
{
Message.IsSuccess = false;
Message.Text = "Purchase requisition not saved";
}
Message.Show = true;
}
}
catch (Exception ex)
{
ex.WriteException();
Message.IsSuccess = false;
Message.Text = ex.Message;
Message.Show = true;
}
}
public int Purchase_RequisitionDetails_Save(Entity.Purchase.PurchaseRequisition purchase)
{
return(DataAccess.Purchase.PurchaseRequisition.Purchase_RequisitionDetails_Save(purchase));
}
public Int64 PurchaseRequisition_Save(Entity.Purchase.PurchaseRequisition purchase)
{
return(DataAccess.Purchase.PurchaseRequisition.PurchaseRequisition_Save(purchase));
}
public static Int64 PurchaseRequisition_Save(Entity.Purchase.PurchaseRequisition purchase)
{
Int64 purchaseId = 0;
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "usp_Purchase_RequisitionMaster_Save";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PurchaseRequisitionId", purchase.PurchaseRequisitionId).Direction = ParameterDirection.InputOutput;
if (purchase.@PurchaseRequisitionNo != string.Empty)
{
cmd.Parameters.AddWithValue("@PurchaseRequisitionNo", purchase.@PurchaseRequisitionNo);
}
else
{
cmd.Parameters.AddWithValue("@PurchaseRequisitionNo", DBNull.Value);
}
if (purchase.RequisitionDate != DateTime.MinValue)
{
cmd.Parameters.AddWithValue("@RequisitionDate", purchase.RequisitionDate);
}
else
{
cmd.Parameters.AddWithValue("@RequisitionDate", DBNull.Value);
}
cmd.Parameters.AddWithValue("@PurchaseDepartment", purchase.PurchaseDepartment);
cmd.Parameters.AddWithValue("@VendorId", purchase.VendorId);
if (purchase.WhenNeeded != DateTime.MinValue)
{
cmd.Parameters.AddWithValue("@WhenNeeded", purchase.WhenNeeded);
}
else
{
cmd.Parameters.AddWithValue("@WhenNeeded", DBNull.Value);
}
if (purchase.PurposeOfRequisition != string.Empty)
{
cmd.Parameters.AddWithValue("@PurposeOfRequisition", purchase.PurposeOfRequisition);
}
else
{
cmd.Parameters.AddWithValue("@PurposeOfRequisition", DBNull.Value);
}
cmd.Parameters.AddWithValue("@CreatedBy", purchase.CreatedBy);
cmd.Parameters.AddWithValue("@Error", string.Empty).Direction = ParameterDirection.InputOutput;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.ExecuteNonQuery();
purchaseId = Convert.ToInt64(cmd.Parameters["@PurchaseRequisitionId"].Value);
con.Close();
}
}
return(purchaseId);
}
