private void SaveGroup() { CommonBLL commonBll = new CommonBLL(); IGroupCompany groupCompany = new GroupCompanyEntity(); string message = string.Empty; BuildGroupCompanyEntity(groupCompany); message = commonBll.SaveGroupCompany(groupCompany, _userId); if (message == string.Empty) { Response.Redirect("~/Security/ManageGroupCompany.aspx"); } else { GeneralFunctions.RegisterAlertScript(this, message); } }
public static IGroupCompany GetGroupCompany(int groupCompanyId, char isActiveOnly, SearchCriteria searchCriteria) { string strExecution = "[common].[uspGetGroupCompany]"; IGroupCompany groupCompany = null; using (DbQuery oDq = new DbQuery(strExecution)) { oDq.AddIntegerParam("@GroupId", groupCompanyId); oDq.AddCharParam("@IsActiveOnly", 1, isActiveOnly); oDq.AddVarcharParam("@SortExpression", 50, searchCriteria.SortExpression); oDq.AddVarcharParam("@SortDirection", 4, searchCriteria.SortDirection); DataTableReader reader = oDq.GetTableReader(); while (reader.Read()) { groupCompany = new GroupCompanyEntity(reader); } reader.Close(); } return(groupCompany); }
public static List <IGroupCompany> GetGroupCompany(char isActiveOnly, SearchCriteria searchCriteria) { string strExecution = "[common].[uspGetGroupCompany]"; List <IGroupCompany> lstGroupCompany = new List <IGroupCompany>(); using (DbQuery oDq = new DbQuery(strExecution)) { oDq.AddCharParam("@IsActiveOnly", 1, isActiveOnly); oDq.AddVarcharParam("@SchGroupName", 50, searchCriteria.GroupName); oDq.AddVarcharParam("@SortExpression", 50, searchCriteria.SortExpression); oDq.AddVarcharParam("@SortDirection", 4, searchCriteria.SortDirection); DataTableReader reader = oDq.GetTableReader(); while (reader.Read()) { IGroupCompany groupCompany = new GroupCompanyEntity(reader); lstGroupCompany.Add(groupCompany); } reader.Close(); } return(lstGroupCompany); }