public static DataTable ClaimApprovalDetails_GetAll(Entity.ClaimManagement.ClaimApprovalConfiguration ClaimApprovalConfiguration) { 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_ClaimApprovalConfig_GetAll"; if (ClaimApprovalConfiguration.ClaimApprovalConfigurationId == 0) { cmd.Parameters.AddWithValue("@ClaimApprovalConfigId", DBNull.Value); } else { cmd.Parameters.AddWithValue("@ClaimApprovalConfigId", ClaimApprovalConfiguration.ClaimApprovalConfigurationId); } using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dt); } con.Close(); } } return(dt); } }
public static int ClaimEmployeeWiseApprovalConfiguration_Save(Entity.ClaimManagement.ClaimApprovalConfiguration ClaimApprovalConfiguration) { int retValue = 0; 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_ClaimEmployeeWiseApprovalConfiguration_Save"; cmd.Parameters.AddWithValue("@ClaimEmployeeWiseApprovalConfigId", ClaimApprovalConfiguration.ClaimEmployeeWiseApprovalConfigurationId); cmd.Parameters.AddWithValue("@EmployeeId", ClaimApprovalConfiguration.EmployeeId); cmd.Parameters.AddWithValue("@ApproverId", ClaimApprovalConfiguration.ApproverId); cmd.Parameters.AddWithValue("@ApproverLevel", ClaimApprovalConfiguration.ApprovalLevel); cmd.Parameters.AddWithValue("@CreatedBy", ClaimApprovalConfiguration.CreatedBy); if (con.State == ConnectionState.Closed) { con.Open(); } retValue = cmd.ExecuteNonQuery(); con.Close(); } } return(retValue); }
protected void btnSave_Click(object sender, EventArgs e) { try { Business.ClaimManagement.ClaimApprovalConfiguration objClaimApprovalConfiguration = new Business.ClaimManagement.ClaimApprovalConfiguration(); Entity.ClaimManagement.ClaimApprovalConfiguration ClaimApprovalConfiguration = new Entity.ClaimManagement.ClaimApprovalConfiguration(); ClaimApprovalConfiguration.ClaimApprovalConfigurationId = ClaimApprovalConfigurationId; ClaimApprovalConfiguration.ApproverDesignationId = Convert.ToInt32(ddlApproverDesignation.SelectedValue); ClaimApprovalConfiguration.ClaimDesignationConfigurationId = Convert.ToInt32(ddlRequestorDesignation.SelectedValue); ClaimApprovalConfiguration.ApprovalLevel = Convert.ToInt32(ddlApprovalLevel.SelectedValue); int response = objClaimApprovalConfiguration.ClaimApprovalConfig_Save(ClaimApprovalConfiguration); if (response > 0) { Clear(); ClaimApprovalConfig_GetAll(); Message.IsSuccess = true; Message.Text = "Saved Successfully"; } else { Message.IsSuccess = false; Message.Text = "Exists"; } Message.Show = true; } catch (Exception ex) { ex.WriteException(); Message.IsSuccess = false; Message.Text = ex.Message; Message.Show = true; } }
public DataTable ClaimEmployeeWiseApprovalConfiguration_GetAll(Entity.ClaimManagement.ClaimApprovalConfiguration ClaimApprovalConfiguration) { return(DataAccess.ClaimManagement.ClaimApprovalConfiguration.ClaimEmployeeWiseApprovalConfiguration_GetAll(ClaimApprovalConfiguration)); }
public int ClaimEmployeeWiseApprovalConfiguration_Save(Entity.ClaimManagement.ClaimApprovalConfiguration ClaimApprovalConfiguration) { return(DataAccess.ClaimManagement.ClaimApprovalConfiguration.ClaimEmployeeWiseApprovalConfiguration_Save(ClaimApprovalConfiguration)); }