public Boolean Update(OccasionallyOrderENT entOccasionallyOrder) { OccasionallyOrderDAL occasionallyOrderDAL = new OccasionallyOrderDAL(); if (occasionallyOrderDAL.Update(entOccasionallyOrder)) { return(true); } else { this.Message = occasionallyOrderDAL.Message; return(false); } }
public Boolean Update(OccasionallyOrderENT entOccasionallyOrder) { using (SqlConnection objConn = new SqlConnection(ConnectionString)) { objConn.Open(); using (SqlCommand objCmd = objConn.CreateCommand()) try { #region Prepare Command objCmd.CommandType = CommandType.StoredProcedure; objCmd.CommandText = "PR_OccasionallyOrder_UpdateByPK"; objCmd.Parameters.AddWithValue("@OccasionallyOrderID", entOccasionallyOrder.OccasionallyOrderID); objCmd.Parameters.AddWithValue("@BranchID", entOccasionallyOrder.BranchID); objCmd.Parameters.AddWithValue("@DistributorID", entOccasionallyOrder.DistributorID); objCmd.Parameters.AddWithValue("@ProductID", entOccasionallyOrder.ProductID); objCmd.Parameters.AddWithValue("@CustomerName", entOccasionallyOrder.CustomerName); objCmd.Parameters.AddWithValue("@MobileNo", entOccasionallyOrder.MobileNo); objCmd.Parameters.AddWithValue("@Address", entOccasionallyOrder.Address); objCmd.Parameters.AddWithValue("@Quantity", entOccasionallyOrder.Quantity); objCmd.Parameters.AddWithValue("@TotalAmount", entOccasionallyOrder.TotalAmount); objCmd.Parameters.AddWithValue("@OrderDate", entOccasionallyOrder.OrderDate); objCmd.Parameters.AddWithValue("@BottleIn", entOccasionallyOrder.BottleIn); objCmd.Parameters.AddWithValue("@Status", entOccasionallyOrder.Status); objCmd.Parameters.AddWithValue("@UserID", entOccasionallyOrder.UserID); #endregion Prepare Command objCmd.ExecuteNonQuery(); return(true); } catch (SqlException sqlex) { Message = sqlex.InnerException.Message.ToString(); return(false); } catch (Exception ex) { Message = ex.InnerException.Message.ToString(); return(false); } finally { if (objConn.State == ConnectionState.Open) { objConn.Close(); } } } }
private void LoadControls(SqlInt32 OccasionallyOrderID) { OccasionallyOrderENT entOccasionallyOrder = new OccasionallyOrderENT(); OccasionallyOrderBAL balOccasionallyOrder = new OccasionallyOrderBAL(); entOccasionallyOrder = balOccasionallyOrder.SelectByPK(OccasionallyOrderID); if (!entOccasionallyOrder.CustomerName.IsNull) { txtCustomerName.Text = entOccasionallyOrder.CustomerName.Value.ToString(); } if (!entOccasionallyOrder.MobileNo.IsNull) { txtMobileNo.Text = entOccasionallyOrder.MobileNo.Value.ToString(); } if (!entOccasionallyOrder.Address.IsNull) { txtCustomerAddress.Text = entOccasionallyOrder.Address.Value.ToString(); } if (!entOccasionallyOrder.BranchID.IsNull) { ddlBranchID.SelectedValue = entOccasionallyOrder.BranchID.Value.ToString(); } if (!entOccasionallyOrder.DistributorID.IsNull) { ddlDistributorID.SelectedValue = entOccasionallyOrder.DistributorID.Value.ToString(); } if (!entOccasionallyOrder.ProductID.IsNull) { ddlProductID.SelectedValue = entOccasionallyOrder.ProductID.Value.ToString(); } if (!entOccasionallyOrder.Quantity.IsNull) { txtQuantity.Text = entOccasionallyOrder.Quantity.Value.ToString(); } if (!entOccasionallyOrder.TotalAmount.IsNull) { txtTotalAmount.Text = entOccasionallyOrder.TotalAmount.Value.ToString(); } if (!entOccasionallyOrder.OrderDate.IsNull) { txtOrderDate.Text = entOccasionallyOrder.OrderDate.Value.ToString("yyyy-MM-dd"); } if (!entOccasionallyOrder.BottleIn.IsNull) { txtBottleIn.Text = entOccasionallyOrder.BottleIn.Value.ToString(); } if (!entOccasionallyOrder.Status.IsNull) { ckbStatus.Checked = entOccasionallyOrder.Status.Value; } }
public OccasionallyOrderENT SelectByPK(SqlInt32 OccasionallyOrderID) { using (SqlConnection objConn = new SqlConnection(ConnectionString)) { objConn.Open(); using (SqlCommand objcmd = objConn.CreateCommand()) try { #region Prepar Command objcmd.CommandType = CommandType.StoredProcedure; objcmd.CommandText = "PR_OccasionallyOrder_SelectByPK"; objcmd.Parameters.AddWithValue("@OccasionallyOrderID", OccasionallyOrderID); #endregion Prepar Command #region ReadData and Set Controls OccasionallyOrderENT entOccasionallyOrder = new OccasionallyOrderENT(); using (SqlDataReader objSDR = objcmd.ExecuteReader()) { while (objSDR.Read()) { if (!objSDR["OccasionallyOrderID"].Equals(DBNull.Value)) { entOccasionallyOrder.OccasionallyOrderID = Convert.ToInt32(objSDR["OccasionallyOrderID"]); } if (!objSDR["BranchID"].Equals(DBNull.Value)) { entOccasionallyOrder.BranchID = Convert.ToInt32(objSDR["BranchID"]); } if (!objSDR["DistributorID"].Equals(DBNull.Value)) { entOccasionallyOrder.DistributorID = Convert.ToInt32(objSDR["DistributorID"]); } if (!objSDR["ProductID"].Equals(DBNull.Value)) { entOccasionallyOrder.ProductID = Convert.ToInt32(objSDR["ProductID"]); } if (!objSDR["CustomerName"].Equals(DBNull.Value)) { entOccasionallyOrder.CustomerName = Convert.ToString(objSDR["CustomerName"]); } if (!objSDR["MobileNo"].Equals(DBNull.Value)) { entOccasionallyOrder.MobileNo = Convert.ToString(objSDR["MobileNo"]); } if (!objSDR["Address"].Equals(DBNull.Value)) { entOccasionallyOrder.Address = Convert.ToString(objSDR["Address"]); } if (!objSDR["Quantity"].Equals(DBNull.Value)) { entOccasionallyOrder.Quantity = Convert.ToInt32(objSDR["Quantity"]); } if (!objSDR["TotalAmount"].Equals(DBNull.Value)) { entOccasionallyOrder.TotalAmount = Convert.ToDecimal(objSDR["TotalAmount"]); } if (!objSDR["OrderDate"].Equals(DBNull.Value)) { entOccasionallyOrder.OrderDate = Convert.ToDateTime(objSDR["OrderDate"]); } if (!objSDR["BottleIn"].Equals(DBNull.Value)) { entOccasionallyOrder.BottleIn = Convert.ToInt32(objSDR["BottleIn"]); } if (!objSDR["Status"].Equals(DBNull.Value)) { entOccasionallyOrder.Status = Convert.ToBoolean(objSDR["Status"]); } if (!objSDR["UserID"].Equals(DBNull.Value)) { entOccasionallyOrder.UserID = Convert.ToInt32(objSDR["UserID"]); } } } return(entOccasionallyOrder); #endregion ReadData and Set Controls } catch (SqlException sqlex) { Message = sqlex.InnerException.Message.ToString(); return(null); } catch (Exception ex) { Message = ex.InnerException.Message.ToString(); return(null); } finally { if (objConn.State == ConnectionState.Open) { objConn.Close(); } } } }
protected void btnSave_Click(object sender, EventArgs e) { try { #region Server Side Validation String strError = String.Empty; if (txtCustomerName.Text.Trim() == String.Empty) { strError += "- Enter Customer Name<br />"; } if (txtMobileNo.Text.Trim() == String.Empty) { strError += "- Enter Mobile No<br />"; } if (txtCustomerAddress.Text.Trim() == String.Empty) { strError += "- Enter Customer Address<br />"; } if (ddlBranchID.SelectedIndex == 0) { strError += "- Select Branch<br />"; } if (ddlDistributorID.SelectedIndex == 0) { strError += "- Select Distributor<br />"; } if (ddlProductID.SelectedIndex == 0) { strError += "- Select Product<br />"; } if (txtQuantity.Text.Trim() == String.Empty) { strError += "- Enter Quantity<br />"; } if (txtTotalAmount.Text.Trim() == String.Empty) { strError += "- Enter Total Amount<br />"; } if (txtOrderDate.Text.Trim() == String.Empty) { strError += "- Enter Order Date<br />"; } if (txtBottleIn.Text.Trim() == String.Empty) { strError += "- Enter In Bottle<br />"; } #endregion Server Side Validation OccasionallyOrderENT entOccasionallyOrder = new OccasionallyOrderENT(); OccasionallyOrderBAL balOccasionallyOrder = new OccasionallyOrderBAL(); #region Gather Data if (txtCustomerName.Text.Trim() != String.Empty) { entOccasionallyOrder.CustomerName = txtCustomerName.Text.Trim(); } if (txtMobileNo.Text.Trim() != String.Empty) { entOccasionallyOrder.MobileNo = txtMobileNo.Text.Trim(); } if (txtCustomerAddress.Text.Trim() != String.Empty) { entOccasionallyOrder.Address = txtCustomerAddress.Text.Trim(); } if (ddlBranchID.SelectedIndex > 0) { entOccasionallyOrder.BranchID = Convert.ToInt32(ddlBranchID.SelectedValue); } if (ddlDistributorID.SelectedIndex > 0) { entOccasionallyOrder.DistributorID = Convert.ToInt32(ddlDistributorID.SelectedValue); } if (ddlProductID.SelectedIndex > 0) { entOccasionallyOrder.ProductID = Convert.ToInt32(ddlProductID.SelectedValue); } if (txtQuantity.Text.Trim() != String.Empty) { entOccasionallyOrder.Quantity = Convert.ToInt32(txtQuantity.Text.Trim()); } if (txtTotalAmount.Text.Trim() != String.Empty) { entOccasionallyOrder.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text.Trim()); } if (txtOrderDate.Text.Trim() != String.Empty) { entOccasionallyOrder.OrderDate = Convert.ToDateTime(txtOrderDate.Text.Trim()); } if (txtBottleIn.Text.Trim() != String.Empty) { entOccasionallyOrder.BottleIn = Convert.ToInt32(txtBottleIn.Text.Trim()); } entOccasionallyOrder.Status = Convert.ToBoolean(ckbStatus.Checked); entOccasionallyOrder.UserID = Convert.ToInt32(Session["UserID"]); if (Request.QueryString["OccasionallyOrderID"] == null) { balOccasionallyOrder.Insert(entOccasionallyOrder); lblMessage.Text = "Data Inserted Successfully"; ClearControls(); } else { entOccasionallyOrder.OccasionallyOrderID = Convert.ToInt32(Request.QueryString["OccasionallyOrderID"]); balOccasionallyOrder.Update(entOccasionallyOrder); Response.Redirect("~/AdminPanel/OccasionallyOrder/OccasionallyOrderList.aspx"); } #endregion Gather Data } catch (Exception ex) { lblErrorMessage.Text = ex.Message.ToString(); } }