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);
}
