public static Entity.HR.LoyaltyPointReasonMaster GetById(int loyaltyPointReasonId) { Entity.HR.LoyaltyPointReasonMaster loyaltyPointReasonMaster = new Entity.HR.LoyaltyPointReasonMaster(); using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { using (SqlCommand cmd = new SqlCommand()) { cmd.Parameters.AddWithValue("@LoyaltyPointReasonId", loyaltyPointReasonId); cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "usp_HR_LoyaltyPointReason_GetById"; if (con.State == ConnectionState.Closed) { con.Open(); } SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { if (dr.HasRows) { loyaltyPointReasonMaster.LoyaltyPointReasonId = loyaltyPointReasonId; loyaltyPointReasonMaster.Reason = dr["Reason"].ToString(); loyaltyPointReasonMaster.Description = dr["Description"].ToString(); loyaltyPointReasonMaster.DesignationId = int.Parse(dr["DesignationMasterId"].ToString()); } } con.Close(); } } return(loyaltyPointReasonMaster); }
public static DataTable GetAll(Entity.HR.LoyaltyPointReasonMaster loyaltyPointReasonMaster) { using (DataTable dt = new DataTable()) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "usp_HR_LoyaltyPointReason_GetAll"; if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dt); } con.Close(); } } return(dt); } }
public static int Save(Entity.HR.LoyaltyPointReasonMaster loyaltyPointReasonMaster) { int rowsAffacted = 0; using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandText = "usp_HR_LoyaltyPointReason_Save"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@LoyaltyPointReasonId", loyaltyPointReasonMaster.LoyaltyPointReasonId); cmd.Parameters.AddWithValue("@DesignationId", loyaltyPointReasonMaster.DesignationId); cmd.Parameters.AddWithValue("@Reason", loyaltyPointReasonMaster.Reason); cmd.Parameters.AddWithValue("@Description", loyaltyPointReasonMaster.Description); if (con.State == ConnectionState.Closed) { con.Open(); } rowsAffacted = cmd.ExecuteNonQuery(); con.Close(); } } return(rowsAffacted); }
protected void gvLoyaltyReason_RowCommand(object sender, GridViewCommandEventArgs e) { try { Business.HR.LoyaltyPointReasonMaster objLoyaltyPointReasonMaster = new Business.HR.LoyaltyPointReasonMaster(); Entity.HR.LoyaltyPointReasonMaster loyaltyPointReasonMaster = new Entity.HR.LoyaltyPointReasonMaster(); if (e.CommandName == "Ed") { int reasonId = int.Parse(e.CommandArgument.ToString()); loyaltyPointReasonMaster = objLoyaltyPointReasonMaster.GetById(reasonId); LoyaltyPointReasonId = loyaltyPointReasonMaster.LoyaltyPointReasonId; txtDescription.Text = loyaltyPointReasonMaster.Description; txtReason.Text = loyaltyPointReasonMaster.Reason; ddlDesignation.SelectedValue = Convert.ToString(loyaltyPointReasonMaster.DesignationId); } else if (e.CommandName == "Del") { int cityId = int.Parse(e.CommandArgument.ToString()); int i = objLoyaltyPointReasonMaster.Delete(cityId); if (i > 0) { GlobalCache.RemoveAll(); ClearControls(); LoadLoyaltyPointReasonMaster(); Message.IsSuccess = true; Message.Text = "Reason deleted successfully..."; } else { Message.IsSuccess = false; Message.Text = "Sorry!! data not delete."; } Message.Show = true; } } catch (Exception ex) { ex.WriteException(); Message.IsSuccess = false; Message.Text = ex.Message; Message.Show = true; } }
protected void btnSave_Click(object sender, EventArgs e) { try { Business.HR.LoyaltyPointReasonMaster objLoyaltyPointReasonMaster = new Business.HR.LoyaltyPointReasonMaster(); Entity.HR.LoyaltyPointReasonMaster loyaltyPointReasonMaster = new Entity.HR.LoyaltyPointReasonMaster(); loyaltyPointReasonMaster.LoyaltyPointReasonId = LoyaltyPointReasonId; loyaltyPointReasonMaster.Reason = txtReason.Text.Trim(); loyaltyPointReasonMaster.Description = txtDescription.Text.Trim(); loyaltyPointReasonMaster.DesignationId = int.Parse(ddlDesignation.SelectedValue); int response = objLoyaltyPointReasonMaster.Save(loyaltyPointReasonMaster); if (response > 0) { GlobalCache.RemoveAll(); ClearControls(); LoadLoyaltyPointReasonMaster(); Message.IsSuccess = true; Message.Text = "Reason saved successfully..."; } else { Message.IsSuccess = false; Message.Text = "Sorry!! data not saved."; } Message.Show = true; } catch (Exception ex) { ex.WriteException(); Message.IsSuccess = false; Message.Text = ex.Message; Message.Show = true; } }
public static DataTable GetAll(Entity.HR.LoyaltyPointReasonMaster city) { return(DataAccess.HR.LoyaltyPointReasonMaster.GetAll(city)); }
public int Save(Entity.HR.LoyaltyPointReasonMaster city) { return(DataAccess.HR.LoyaltyPointReasonMaster.Save(city)); }