public Boolean Insert(AddressENT entAddress) { using (SqlConnection objConn = new SqlConnection(ConnectionString)) { objConn.Open(); using (SqlCommand objCmd = objConn.CreateCommand()) { try { #region Prepare Command objCmd.CommandType = CommandType.StoredProcedure; objCmd.CommandText = "PR_Address_Insert"; objCmd.Parameters.Add("@AddressID", SqlDbType.Int, 4).Direction = ParameterDirection.Output; objCmd.Parameters.Add("@UserID", SqlDbType.Int).Value = entAddress.UserID; objCmd.Parameters.Add("@FullName", SqlDbType.VarChar).Value = entAddress.FullName; objCmd.Parameters.Add("@StateID", SqlDbType.Int).Value = entAddress.StateID; objCmd.Parameters.Add("@CityID", SqlDbType.Int).Value = entAddress.CityID; objCmd.Parameters.Add("@Address1", SqlDbType.VarChar).Value = entAddress.Address1; objCmd.Parameters.Add("@Address2", SqlDbType.VarChar).Value = entAddress.Address2; objCmd.Parameters.Add("@Postcode", SqlDbType.Int).Value = entAddress.Postcode; objCmd.Parameters.Add("@MobileNo", SqlDbType.VarChar).Value = entAddress.MobileNo; #endregion Prepare Command objCmd.ExecuteNonQuery(); if (objCmd.Parameters["@AddressID"] != null) { entAddress.AddressID = Convert.ToInt32(objCmd.Parameters["@AddressID"].Value); } 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(); } } } } }
public AddressENT GetAddressIDByUserID(SqlInt32 UserID) { using (SqlConnection objConn = new SqlConnection(ConnectionString)) { objConn.Open(); using (SqlCommand objCmd = objConn.CreateCommand()) { try { #region Prepare Command objCmd.CommandType = CommandType.StoredProcedure; objCmd.CommandText = "PR_Address_GetAddressIDByUserID"; objCmd.Parameters.AddWithValue("@UserID", UserID); #endregion Prepare Command #region ReadData and Set Controls AddressENT entAddress = new AddressENT(); using (SqlDataReader objSDR = objCmd.ExecuteReader()) { while (objSDR.Read()) { if (!objSDR["AddressID"].Equals(DBNull.Value)) { entAddress.AddressID = Convert.ToInt32(objSDR["AddressID"]); } } } return(entAddress); #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(); } } } } }
public Boolean Update(AddressENT entAddress, SqlInt32 AddressID, SqlInt32 UserID) { AddressDAL dalAddress = new AddressDAL(); if (dalAddress.Update(entAddress, AddressID, UserID)) { return(true); } else { Message = dalAddress.Message; return(false); } }
public Boolean Insert(AddressENT entAddress) { AddressDAL dalAddress = new AddressDAL(); if (dalAddress.Insert(entAddress)) { return(true); } else { Message = dalAddress.Message; return(false); } }
public Boolean Update(AddressENT entAddress, SqlInt32 AddressID, SqlInt32 UserID) { using (SqlConnection objConn = new SqlConnection(ConnectionString)) { objConn.Open(); using (SqlCommand objCmd = objConn.CreateCommand()) { try { #region Prepare Command objCmd.CommandType = CommandType.StoredProcedure; objCmd.CommandText = "PR_Address_Update"; objCmd.Parameters.AddWithValue("@AddressID", AddressID); objCmd.Parameters.AddWithValue("@UserID", UserID); objCmd.Parameters.AddWithValue("@FullName", entAddress.FullName); objCmd.Parameters.AddWithValue("@StateID", entAddress.StateID); objCmd.Parameters.AddWithValue("@CityID", entAddress.CityID); objCmd.Parameters.AddWithValue("@Address1", entAddress.Address1); objCmd.Parameters.AddWithValue("@Address2", entAddress.Address2); objCmd.Parameters.AddWithValue("@Postcode", entAddress.Postcode); objCmd.Parameters.AddWithValue("@MobileNo", entAddress.MobileNo); #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 FilAddressDetails() { AddressBAL balAddress = new AddressBAL(); AddressENT entAddress = new AddressENT(); entAddress = balAddress.SelectByPK(Convert.ToInt32(Session["AddressID"]), Convert.ToInt32(Session["UserID"])); if (!entAddress.FullName.IsNull) { txtFullName.Text = entAddress.FullName.Value; } if (!entAddress.StateID.IsNull) { ddlState.SelectedValue = entAddress.StateID.Value.ToString(); } if (!entAddress.CityID.IsNull) { ddlCity.SelectedValue = entAddress.CityID.Value.ToString(); CommonFillMethods.FillDropDownListCityByStateID(ddlCity, entAddress.StateID); } if (!entAddress.Address1.IsNull) { txtAddressLine1.Text = entAddress.Address1.Value; } if (!entAddress.Address2.IsNull) { txtAddressLine2.Text = entAddress.Address2.Value; } if (!entAddress.Postcode.IsNull) { txtPostCode.Text = entAddress.Postcode.Value.ToString(); } if (!entAddress.MobileNo.IsNull) { txtMobileNo.Text = entAddress.MobileNo.Value; } }
protected void btnNext_Click(object sender, EventArgs e) { #region ServerSide Validation String strErrorMessage = ""; if (txtFullName.Text == "") { strErrorMessage += "Enter Full Name<br/>"; } if (ddlState.SelectedIndex <= 0) { strErrorMessage += "Select State<br/>"; } if (ddlCity.SelectedIndex <= 0) { strErrorMessage += "Select City<br/>"; } if (txtAddressLine1.Text == "") { strErrorMessage += "Enter AddressLine 1<br/>"; } if (txtMobileNo.Text == "") { strErrorMessage += "Enter Mobile No.<br/>"; } if (strErrorMessage != "") { lblMessage.Text = strErrorMessage; divMessage.Visible = true; return; } #endregion ServerSide Validation #region Collect Form Data AddressENT entAddress = new AddressENT(); if (Session["UserID"] != null) { entAddress.UserID = Convert.ToInt32(Session["UserID"]); } if (txtFullName.Text != "") { entAddress.FullName = txtFullName.Text.Trim(); } if (ddlState.SelectedIndex > 0) { entAddress.StateID = Convert.ToInt32(ddlState.SelectedValue.ToString()); } if (ddlCity.SelectedIndex > 0) { entAddress.CityID = Convert.ToInt32(ddlCity.SelectedValue.ToString()); } if (txtAddressLine1.Text != "") { entAddress.Address1 = txtAddressLine1.Text.Trim(); } if (txtAddressLine2.Text != "") { entAddress.Address2 = txtAddressLine2.Text.Trim(); } if (txtPostCode.Text != "") { entAddress.Postcode = Convert.ToInt32(txtPostCode.Text.Trim()); } if (txtMobileNo.Text != "") { entAddress.MobileNo = txtMobileNo.Text.Trim(); } #endregion Collect Form Data AddressBAL balAddress = new AddressBAL(); if (Session["AddressID"] == null) { if (balAddress.Insert(entAddress)) { Session["AddressID"] = entAddress.AddressID.Value; ClearControls(); } else { lblMessage.Text = balAddress.Message; divMessage.Visible = true; } } else { entAddress.AddressID = Convert.ToInt32(Session["AddressID"]); if (balAddress.Update(entAddress, entAddress.AddressID, entAddress.UserID)) { ClearControls(); Response.Redirect("~/User/Order.aspx"); } else { lblMessage.Text = balAddress.Message; divMessage.Visible = true; } } }
protected void btnLogin_Click(object sender, EventArgs e) { #region ServerSide Validatiion String strErrorMessage = ""; if (txtUserName.Text == "") { strErrorMessage += "Enter User Name<br/>"; } if (txtPassword.Text == "") { strErrorMessage += "Enter Password<br/>"; } if (strErrorMessage != "") { lblMessage.Text = strErrorMessage; divMessage.Visible = true; return; } #endregion ServerSide Validatiion #region Collect Data String UserName = txtUserName.Text.ToString(); String Password = txtPassword.Text.ToString(); UserENT entUser = new UserENT(); UserBAL balUser = new UserBAL(); entUser = balUser.SelectByUserPassword(UserName, Password); if (!entUser.UserID.IsNull) { Session["UserID"] = entUser.UserID.Value.ToString(); } if (!entUser.UserName.IsNull) { Session["UserName"] = entUser.UserName.Value.ToString(); } if (!entUser.UserID.IsNull) { #region Get AddressID AddressENT entAddress = new AddressENT(); AddressBAL balAddress = new AddressBAL(); entAddress = balAddress.GetAddressIDByUserID(entUser.UserID.Value); if (!entAddress.AddressID.IsNull) { Session["AddressID"] = entAddress.AddressID.Value; } #endregion Get AddressID } if (!entUser.UserID.IsNull) { if (entUser.UserType == "user") { Response.Redirect("~/User/Home.aspx"); } else { Response.Redirect("~/AdminPanel/Product/ProductList.aspx"); } } else { lblMessage.Text = "Enter Valid Name or Password"; divMessage.Visible = true; } #endregion Collect Data }