protected void btnUpdate_Click(object sender, EventArgs e) { if (checkName() && Page.IsValid) { Branch _Branch = new Branch(); _Branch.ID = branchID; _Branch.Name = txtBranchName.Text; _Branch.Email = txtBranchEmail.Text; _Branch.Phone = txtPhone.Text; _Branch.Address = txtAddress.Text; _Branch.Description = txtDescription.Text; bool result = BranchBLL.UpdateBranch(_Branch); if (result) { lblStatusUpdate.Text = "Update branch Successful!"; Response.AddHeader("REFRESH", "2;URL=BranchManagement.aspx"); } else { lblStatusUpdate.Text = "Can not update branch !"; return; } } }
public void LoadBranch() { branch = new Branch(); branch = BranchBLL.GetBranchByID(branchID)[0]; txtBranchName.Text = branch.Name; txtBranchEmail.Text = branch.Email; txtPhone.Text = branch.Phone; txtAddress.Text = branch.Address; txtDescription.Text = branch.Description; }
public Branch BranchIDatareader(IDataReader dr) { Branch obj = new Branch(); obj.ID = (dr["ID"] is DBNull) ? string.Empty : dr["ID"].ToString(); obj.Name = (dr["Name"] is DBNull) ? string.Empty : dr["Name"].ToString(); obj.Email = (dr["Email"] is DBNull) ? string.Empty : dr["Email"].ToString(); obj.Phone = (dr["Phone"] is DBNull) ? string.Empty : dr["Phone"].ToString(); obj.Address = (dr["Address"] is DBNull) ? string.Empty : dr["Address"].ToString(); obj.Description = (dr["Description"] is DBNull) ? string.Empty : dr["Description"].ToString(); return obj; }
public List<Branch> GetAllBranch() { List<Branch> list = new List<Branch>(); using (SqlCommand cmd = GetCommand("getAllBranch", CommandType.StoredProcedure)) { Branch branch = new Branch(); using (SqlDataReader dr = ExeDataReader(cmd)) { if (dr.HasRows) { while (dr.Read()) { list.Add(branch.BranchIDatareader(dr)); } } } branch = null; } return list; }
public List<Branch> GetBranchByID(string id) { List<Branch> list = new List<Branch>(); using (SqlCommand cmd = GetCommand("getBranchByID", CommandType.StoredProcedure)) { AddParameter(cmd, "@ID", Convert.ToInt32(id)); Branch branch = new Branch(); using (SqlDataReader dr = ExeDataReader(cmd)) { if (dr.HasRows) { while (dr.Read()) { list.Add(branch.BranchIDatareader(dr)); } } } branch = null; } return list; }
public bool UpdateBranch(Branch branch) { using (SqlCommand cmd = GetCommand("updateBranch", CommandType.StoredProcedure)) { AddParameter(cmd, "@ID", branch.ID); AddParameter(cmd, "@Name", branch.Name); AddParameter(cmd, "@Email", branch.Email); AddParameter(cmd, "@Phone", branch.Phone); AddParameter(cmd, "@Address", branch.Address); AddParameter(cmd, "@Description", branch.Description); int result = ExeNonQuery(cmd); return result > 0; } }
public List<Branch> SearchBranchByName(string name) { List<Branch> list = new List<Branch>(); using (SqlCommand cmd = GetCommand("searchBranchByName", CommandType.StoredProcedure)) { AddParameter(cmd, "@Name", name); Branch branch = new Branch(); using (SqlDataReader dr = ExeDataReader(cmd)) { if (dr.HasRows) { while (dr.Read()) { list.Add(branch.BranchIDatareader(dr)); } } } branch = null; } return list; }
public static bool UpdateBranch(Branch branch) { return db.UpdateBranch(branch); }
public static bool InsertBranch(Branch branch) { return db.InsertBranch(branch); }