public static DataTable HolidayProfile_GetAll(Entity.HR.HolidayProfile holidayProfile) { 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_HolidayProfile_GetAll"; if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dt); } con.Close(); } } return(dt); } }
protected void btnSave_Click(object sender, EventArgs e) { try { Business.HR.HolidayProfile objHolidayProfile = new Business.HR.HolidayProfile(); Entity.HR.HolidayProfile holidayProfile = new Entity.HR.HolidayProfile(); holidayProfile.HolidayProfileId = HolidayProfileId; holidayProfile.HolidayProfileName = txtHolidayProfile.Text.Trim(); holidayProfile.HolidayProfileDescription = txtDescription.Text.Trim(); int RowsAffected = objHolidayProfile.HolidayProfile_Save(holidayProfile); if (RowsAffected > 0) { ClearControls(); LoadHolidayProfileList(); Message.IsSuccess = true; Message.Text = "Saved Successfully"; } else { Message.IsSuccess = false; Message.Text = "Holiday Profile Name Exists"; } Message.Show = true; } catch (Exception ex) { ex.WriteException(); Message.IsSuccess = false; Message.Text = ex.Message; Message.Show = true; } }
public static int HolidayProfile_Save(Entity.HR.HolidayProfile holidayProfile) { int rowsAffacted = 0; using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandText = "usp_HR_HolidayProfile_Save"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HolidayProfileId", holidayProfile.HolidayProfileId); cmd.Parameters.AddWithValue("@HolidayProfileName", holidayProfile.HolidayProfileName); cmd.Parameters.AddWithValue("@HolidayProfileDescription", holidayProfile.HolidayProfileDescription); if (con.State == ConnectionState.Closed) { con.Open(); } rowsAffacted = cmd.ExecuteNonQuery(); con.Close(); } } return(rowsAffacted); }
public int HolidayProfile_Save(Entity.HR.HolidayProfile holidayProfile) { return(DataAccess.HR.HolidayProfile.HolidayProfile_Save(holidayProfile)); }
public DataTable HolidayProfile_GetAll(Entity.HR.HolidayProfile holidayProfile) { return(DataAccess.HR.HolidayProfile.HolidayProfile_GetAll(holidayProfile)); }