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