public static COMN_JobExperience GetCOMN_JobExperienceByJobExperienceID(int JobExperienceID)
{
COMN_JobExperience cOMN_JobExperience = new COMN_JobExperience();
SqlCOMN_JobExperienceProvider sqlCOMN_JobExperienceProvider = new SqlCOMN_JobExperienceProvider();
cOMN_JobExperience = sqlCOMN_JobExperienceProvider.GetCOMN_JobExperienceByJobExperienceID(JobExperienceID);
return cOMN_JobExperience;
}
public static List<COMN_JobExperience> GetCOMN_JobExperiencesByUserID(string UserID)
{
List<COMN_JobExperience> cOMN_JobExperience = new List<COMN_JobExperience>();
SqlCOMN_JobExperienceProvider sqlCOMN_JobExperienceProvider = new SqlCOMN_JobExperienceProvider();
cOMN_JobExperience = sqlCOMN_JobExperienceProvider.GetCOMN_JobExperiencesByUserID(UserID);
return cOMN_JobExperience;
}
public static DataSet GetAllCOMN_JobExperiences()
{
DataSet cOMN_JobExperiences = new DataSet();
SqlCOMN_JobExperienceProvider sqlCOMN_JobExperienceProvider = new SqlCOMN_JobExperienceProvider();
cOMN_JobExperiences = sqlCOMN_JobExperienceProvider.GetAllCOMN_JobExperiences();
return cOMN_JobExperiences;
}
public static COMN_JobExperience GetCOMN_DesignationByDesignationID(int DesignationID)
{
COMN_JobExperience cOMN_JobExperience = new COMN_JobExperience();
SqlCOMN_JobExperienceProvider sqlCOMN_JobExperienceProvider = new SqlCOMN_JobExperienceProvider();
cOMN_JobExperience = sqlCOMN_JobExperienceProvider.GetCOMN_JobExperienceByDesignationID(DesignationID);
return cOMN_JobExperience;
}
public static DataSet GetCOMN_UserByUserID(string UserID,bool isDataset)
{
DataSet cOMN_JobExperience = new DataSet();
SqlCOMN_JobExperienceProvider sqlCOMN_JobExperienceProvider = new SqlCOMN_JobExperienceProvider();
cOMN_JobExperience = sqlCOMN_JobExperienceProvider.GetCOMN_JobExperienceByUserID(UserID,isDataset);
return cOMN_JobExperience;
}
public static COMN_JobExperience GetCOMN_UserByUserID(string UserID)
{
COMN_JobExperience cOMN_JobExperience = new COMN_JobExperience();
SqlCOMN_JobExperienceProvider sqlCOMN_JobExperienceProvider = new SqlCOMN_JobExperienceProvider();
cOMN_JobExperience = sqlCOMN_JobExperienceProvider.GetCOMN_JobExperienceByUserID(UserID);
return cOMN_JobExperience;
}
public static bool DeleteCOMN_JobExperienceByUserID(string userID)
{
SqlCOMN_JobExperienceProvider sqlCOMN_JobExperienceProvider = new SqlCOMN_JobExperienceProvider();
return sqlCOMN_JobExperienceProvider.DeleteCOMN_JobExperienceByUserID(userID);
}
public static bool DeleteCOMN_JobExperience(int cOMN_JobExperienceID)
{
SqlCOMN_JobExperienceProvider sqlCOMN_JobExperienceProvider = new SqlCOMN_JobExperienceProvider();
return sqlCOMN_JobExperienceProvider.DeleteCOMN_JobExperience(cOMN_JobExperienceID);
}
public static bool UpdateCOMN_JobExperience(COMN_JobExperience cOMN_JobExperience)
{
SqlCOMN_JobExperienceProvider sqlCOMN_JobExperienceProvider = new SqlCOMN_JobExperienceProvider();
return sqlCOMN_JobExperienceProvider.UpdateCOMN_JobExperience(cOMN_JobExperience);
}
public static void LoadCOMN_JobExperiencePage(System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize)
{
int recordCount=0;
int PageSize = int.Parse(ddlPageSize.SelectedValue);
SqlCOMN_JobExperienceProvider sqlCOMN_JobExperienceProvider = new SqlCOMN_JobExperienceProvider();
DataSet ds = sqlCOMN_JobExperienceProvider.GetCOMN_JobExperiencePageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
cOMN_JobExperiencesPaggination(rptPager,recordCount, pageIndex, PageSize);
}
public static int InsertCOMN_JobExperience(COMN_JobExperience cOMN_JobExperience)
{
SqlCOMN_JobExperienceProvider sqlCOMN_JobExperienceProvider = new SqlCOMN_JobExperienceProvider();
return sqlCOMN_JobExperienceProvider.InsertCOMN_JobExperience(cOMN_JobExperience);
}