public static HR_BloodGroup GetHR_BloodGroupByBloodGroupID(int BloodGroupID) { HR_BloodGroup hR_BloodGroup = new HR_BloodGroup(); SqlHR_BloodGroupProvider sqlHR_BloodGroupProvider = new SqlHR_BloodGroupProvider(); hR_BloodGroup = sqlHR_BloodGroupProvider.GetHR_BloodGroupByBloodGroupID(BloodGroupID); return hR_BloodGroup; }
protected void btnUpdate_Click(object sender, EventArgs e) { HR_BloodGroup hR_BloodGroup = new HR_BloodGroup(); hR_BloodGroup.BloodGroupID = int.Parse(Request.QueryString["ID"].ToString()); hR_BloodGroup.BloodGroupName = txtBloodGroupName.Text; string userID = Profile.card_id; hR_BloodGroup.AddedBy = userID; hR_BloodGroup.AddedDate = DateTime.Now; hR_BloodGroup.ModifiedBy = userID; hR_BloodGroup.ModifiedDate = DateTime.Now; bool resutl = HR_BloodGroupManager.UpdateHR_BloodGroup(hR_BloodGroup); Response.Redirect("AdminDisplayCOMN_BloodGroup.aspx"); }
protected void btnAdd_Click(object sender, EventArgs e) { HR_BloodGroup hR_BloodGroup = new HR_BloodGroup(); // hR_BloodGroup.BloodGroupID= int.Parse(ddlBloodGroupID.SelectedValue); hR_BloodGroup.BloodGroupName = txtBloodGroupName.Text; string userID = Profile.card_id; hR_BloodGroup.AddedBy = userID; hR_BloodGroup.AddedDate = DateTime.Now; hR_BloodGroup.ModifiedBy = userID; hR_BloodGroup.ModifiedDate = DateTime.Now; int resutl = HR_BloodGroupManager.InsertHR_BloodGroup(hR_BloodGroup); Response.Redirect("AdminDisplayCOMN_BloodGroup.aspx"); }
private void showHR_BloodGroupData() { HR_BloodGroup hR_BloodGroup = new HR_BloodGroup(); hR_BloodGroup = HR_BloodGroupManager.GetHR_BloodGroupByBloodGroupID(Int32.Parse(Request.QueryString["ID"])); txtBloodGroupName.Text = hR_BloodGroup.BloodGroupName.ToString(); }
public static bool UpdateHR_BloodGroup(HR_BloodGroup hR_BloodGroup) { SqlHR_BloodGroupProvider sqlHR_BloodGroupProvider = new SqlHR_BloodGroupProvider(); return sqlHR_BloodGroupProvider.UpdateHR_BloodGroup(hR_BloodGroup); }
public static int InsertHR_BloodGroup(HR_BloodGroup hR_BloodGroup) { SqlHR_BloodGroupProvider sqlHR_BloodGroupProvider = new SqlHR_BloodGroupProvider(); return sqlHR_BloodGroupProvider.InsertHR_BloodGroup(hR_BloodGroup); }
public bool UpdateHR_BloodGroup(HR_BloodGroup hR_BloodGroup) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateCOMN_BloodGroup", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@BloodGroupID", SqlDbType.Int).Value = hR_BloodGroup.BloodGroupID; cmd.Parameters.Add("@BloodGroupName", SqlDbType.NVarChar).Value = hR_BloodGroup.BloodGroupName; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_BloodGroup.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_BloodGroup.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public int InsertHR_BloodGroup(HR_BloodGroup hR_BloodGroup) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("InsertCOMN_BloodGroup", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@BloodGroupID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@BloodGroupName", SqlDbType.NVarChar).Value = hR_BloodGroup.BloodGroupName; cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = hR_BloodGroup.AddedBy; cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = hR_BloodGroup.AddedDate; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_BloodGroup.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_BloodGroup.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return (int)cmd.Parameters["@BloodGroupID"].Value; } }
public HR_BloodGroup GetHR_BloodGroupFromReader(IDataReader reader) { try { HR_BloodGroup hR_BloodGroup = new HR_BloodGroup ( DataAccessObject.IsNULL<int>(reader["BloodGroupID"]), DataAccessObject.IsNULL<string>(reader["BloodGroupName"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"]) ); return hR_BloodGroup; } catch(Exception ex) { return null; } }