private void Save()
{
if (ClaimControlValidation())
{
Business.ClaimManagement.ClaimCategory objClaimCategory = new Business.ClaimManagement.ClaimCategory();
Entity.ClaimManagement.ClaimCategory Model = new Entity.ClaimManagement.ClaimCategory
{
ClaimCategoryTypeId = int.Parse(ddlCategoryType.SelectedValue),
ClaimCategoryId = ClaimCategoryId,
ClaimCategoryName = txtName.Text,
ClaimCategoryDescription = txtDescription.Text,
};
int rows = objClaimCategory.ClaimCategorySave(Model);
if (rows > 0)
{
ClearControls();
ClaimCategoryGetAll();
ClaimCategoryId = 0;
Message.IsSuccess = true;
Message.Text = "Saved Successfully";
}
else
{
Message.IsSuccess = false;
Message.Text = "Unable to save data.";
}
Message.Show = true;
}
}
public static int ClaimCategory_Save(Entity.ClaimManagement.ClaimCategory objClaimCategory)
{
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_ClaimCategory_Save";
cmd.Parameters.AddWithValue("@CategoryId", objClaimCategory.ClaimCategoryId);
cmd.Parameters.AddWithValue("@ClaimCategoryTypeId", objClaimCategory.ClaimCategoryTypeId);
cmd.Parameters.AddWithValue("@CategoryName", objClaimCategory.ClaimCategoryName);
cmd.Parameters.AddWithValue("@Description", objClaimCategory.ClaimCategoryDescription);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
retValue = cmd.ExecuteNonQuery();
con.Close();
}
}
return(retValue);
}
public int ClaimCategoryDelete(Entity.ClaimManagement.ClaimCategory objClaimCategory)
{
return(DataAccess.ClaimManagement.ClaimCategory.ClaimCategory_Delete(objClaimCategory));
}
public DataTable ClaimCategoryGetAll(Entity.ClaimManagement.ClaimCategory objClaimCategory)
{
return(DataAccess.ClaimManagement.ClaimCategory.ClaimCategory_GetAll());
}
