public static DataSet GetDropDownListAllCOMN_Remark()
{
DataSet cOMN_Remarks = new DataSet();
SqlCOMN_RemarkProvider sqlCOMN_RemarkProvider = new SqlCOMN_RemarkProvider();
cOMN_Remarks = sqlCOMN_RemarkProvider.GetDropDownLisAllCOMN_Remark();
return cOMN_Remarks;
}
public static COMN_Remark GetCOMN_RowStatusByRowStatusID(int RowStatusID)
{
COMN_Remark cOMN_Remark = new COMN_Remark();
SqlCOMN_RemarkProvider sqlCOMN_RemarkProvider = new SqlCOMN_RemarkProvider();
cOMN_Remark = sqlCOMN_RemarkProvider.GetCOMN_RemarkByRowStatusID(RowStatusID);
return cOMN_Remark;
}
public static void LoadCOMN_RemarkPageByID(System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize,string id)
{
int recordCount = 0;
int PageSize = int.Parse(ddlPageSize.SelectedValue);
SqlCOMN_RemarkProvider sqlCOMN_RemarkProvider = new SqlCOMN_RemarkProvider();
DataSet ds = sqlCOMN_RemarkProvider.GetCOMN_RemarkPageWiseByID(pageIndex, PageSize, out recordCount,id);
gv.DataSource = ds;
gv.DataBind();
//COMN_CommonManager common = new COMN_CommonManager();
COMN_CommonManager.Paggination(rptPager, recordCount, pageIndex, PageSize);
}
public static int InsertCOMN_Remark(COMN_Remark cOMN_Remark)
{
SqlCOMN_RemarkProvider sqlCOMN_RemarkProvider = new SqlCOMN_RemarkProvider();
return sqlCOMN_RemarkProvider.InsertCOMN_Remark(cOMN_Remark);
}
public static bool DeleteCOMN_Remark(int cOMN_RemarkID)
{
SqlCOMN_RemarkProvider sqlCOMN_RemarkProvider = new SqlCOMN_RemarkProvider();
return sqlCOMN_RemarkProvider.DeleteCOMN_Remark(cOMN_RemarkID);
}
public static bool UpdateCOMN_Remark(COMN_Remark cOMN_Remark)
{
SqlCOMN_RemarkProvider sqlCOMN_RemarkProvider = new SqlCOMN_RemarkProvider();
return sqlCOMN_RemarkProvider.UpdateCOMN_Remark(cOMN_Remark);
}