public DataBaseResultSet SaveT_MstAccountMaster <T>(T objData) where T : class, IModel, new()
{
T_MstAccountMaster obj = objData as T_MstAccountMaster;
string sQuery = "sprocT_MstAccountMasterInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("AccountCode", "AccountCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.AccountCode));
list.Add(SqlConnManager.GetConnParameters("AccountName", "AccountName", 100, GenericDataType.String, ParameterDirection.Input, obj.AccountName));
list.Add(SqlConnManager.GetConnParameters("Address", "Address", 100, GenericDataType.String, ParameterDirection.Input, obj.Address));
list.Add(SqlConnManager.GetConnParameters("Place", "Place", 100, GenericDataType.String, ParameterDirection.Input, obj.Place));
list.Add(SqlConnManager.GetConnParameters("OpeningBalance", "OpeningBalance", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.OpeningBalance));
list.Add(SqlConnManager.GetConnParameters("TypeDrCr", "TypeDrCr", 10, GenericDataType.String, ParameterDirection.Input, obj.TypeDrCr));
list.Add(SqlConnManager.GetConnParameters("GroupId", "GroupId", 10, GenericDataType.String, ParameterDirection.Input, obj.GroupId));
list.Add(SqlConnManager.GetConnParameters("GroupCode", "GroupCode", 20, GenericDataType.String, ParameterDirection.Input, obj.GroupCode));
list.Add(SqlConnManager.GetConnParameters("PanCardNo", "PanCardNo", 10, GenericDataType.String, ParameterDirection.Input, obj.PanCardNo));
list.Add(SqlConnManager.GetConnParameters("FCC", "FCC", 50, GenericDataType.String, ParameterDirection.Input, obj.FCC));
list.Add(SqlConnManager.GetConnParameters("Range", "Range", 50, GenericDataType.String, ParameterDirection.Input, obj.Range));
list.Add(SqlConnManager.GetConnParameters("DivI", "DivI", 50, GenericDataType.String, ParameterDirection.Input, obj.DivI));
list.Add(SqlConnManager.GetConnParameters("CommI", "CommI", 50, GenericDataType.String, ParameterDirection.Input, obj.CommI));
list.Add(SqlConnManager.GetConnParameters("BST", "BST", 50, GenericDataType.String, ParameterDirection.Input, obj.BST));
list.Add(SqlConnManager.GetConnParameters("CST", "CST", 50, GenericDataType.String, ParameterDirection.Input, obj.CST));
list.Add(SqlConnManager.GetConnParameters("Packing", "Packing", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Packing));
list.Add(SqlConnManager.GetConnParameters("Checking", "Checking", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Checking));
list.Add(SqlConnManager.GetConnParameters("Other", "Other", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Other));
list.Add(SqlConnManager.GetConnParameters("Insurance", "Insurance", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Insurance));
list.Add(SqlConnManager.GetConnParameters("ADath", "ADath", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.ADath));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 10, GenericDataType.String, ParameterDirection.Input, DateTime.Now));
list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag));
list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null));
list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null));
return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray()));
}
public void GetListT_MstAccountMaster <T>(T objFilter, ref List <T> listData) where T : class, IModel, new()
{
string sQuery = "GetListT_MstAccountMaster";
T_MstAccountMaster objData = objFilter as T_MstAccountMaster;
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("AccountCode", "AccountCode", 8, GenericDataType.Long, ParameterDirection.Input, objData.AccountCode));
SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillDataFromReader, ref listData);
}
