public void GetAllListProduct <T>(T objFilter, ref List <T> listData) where T : class, IModel, new()
{
string sQuery = "sprocGetAllListProduct";
ProductMaster objData = objFilter as ProductMaster;
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("ProductCode", "ProductCode", 8, GenericDataType.Long, ParameterDirection.Input, objData.ProductCode));
SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillProductMasterDataFromReader, ref listData);
}
public void GetListXDetail <T>(T objFilter, ref List <T> listData) where T : class, IModel, new()
{
string sQuery = "GetListXDetail";
XDetail objData = objFilter as XDetail;
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, objData.RecNo));
SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillXDetailDataFromReader, ref listData);
}
public void GetListT_ErrorDesc <T>(T objFilter, ref List <T> listData) where T : class, IModel, new()
{
string sQuery = "GetListT_ErrorDesc";
T_ErrorDesc objData = objFilter as T_ErrorDesc;
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("ErrorId", "ErrorId", 8, GenericDataType.Long, ParameterDirection.Input, objData.ErrorId));
SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillDataFromReader, ref listData);
}
public void GetListT_MstAccount <T>(T objFilter, ref List <T> listData) where T : class, IModel, new()
{
string sQuery = "GetListT_MstAccount";
T_MstAccount objData = objFilter as T_MstAccount;
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("", "", 0, GenericDataType.Int, ParameterDirection.Input, objData.AccountId));
SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillDataFromReader, ref listData);
}
public void GetListT_PrimKeyValues <T>(T objFilter, ref List <T> listData) where T : class, IModel, new()
{
string sQuery = "GetListT_PrimKeyValues";
T_PrimKeyValues objData = objFilter as T_PrimKeyValues;
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("PrimKeyId", "PrimKeyId", 4, GenericDataType.Int, ParameterDirection.Input, objData.PrimKeyTable));
SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillDataFromReader, ref listData);
}
public void GetListMiscRcptPmt <T>(T objFilter, ref List <T> listData) where T : class, IModel, new()
{
string sQuery = "GetListMiscRcptPmt";
MiscRcptPmt objData = objFilter as MiscRcptPmt;
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("RcptCode", "RcptCode", 8, GenericDataType.Long, ParameterDirection.Input, objData.RcptCode));
SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillMiscRcptPmtDataFromReader, ref listData);
}
public void GetListT_MstQuality <T>(T objFilter, ref List <T> listData) where T : class, IModel, new()
{
string sQuery = "GetListT_MstQuality";
T_MstQuality objData = objFilter as T_MstQuality;
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("QualityCode", "QualityCode", 4, GenericDataType.Int, ParameterDirection.Input, objData.QualityCode));
list.Add(SqlConnManager.GetConnParameters("CompanyId", "CompanyId", 4, GenericDataType.Long, ParameterDirection.Input, objData.CompanyId));
SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillDataFromReader, ref listData);
}
public void GetListT_TranPurchaseOrder <T>(T objFilter, ref List <T> listData) where T : class, IModel, new()
{
string sQuery = "GetListT_TranPurchaseOrder";
T_TranPurchaseOrder objData = objFilter as T_TranPurchaseOrder;
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("TranPurchaseOrderId", "TranPurchaseOrderId", 10, GenericDataType.String, ParameterDirection.Input, objData.TranPurchaseOrderId));
list.Add(SqlConnManager.GetConnParameters("CompanyId", "CompanyId", 4, GenericDataType.Long, ParameterDirection.Input, objData.CompanyId));
SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillDataFromReader, ref listData);
}
public void GetListT_MstCompanyForDropDown <T>(T objFilter, ref List <T> listData) where T : class, IModel, new()
{
string sQuery = "GetListT_MstCompanyDropDown";
T_MstCompany objData = objFilter as T_MstCompany;
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("CompanyId", "CompanyId", 4, GenericDataType.Int, ParameterDirection.Input, objData.CompanyId));
list.Add(SqlConnManager.GetConnParameters("FinancialYearId", "FinancialYearId", 4, GenericDataType.Int, ParameterDirection.Input, objData.FinancialYearId));
SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillMstCompanyDropDownDataFromReader, ref listData);
}
