public DataBaseResultSet SaveAutoSetup <T>(T objData) where T : class, IModel, new()
{
AutoSetup obj = objData as AutoSetup;
string sQuery = "sprocAutoSetupInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo));
list.Add(SqlConnManager.GetConnParameters("EntryTag", "EntryTag", 10, GenericDataType.String, ParameterDirection.Input, obj.EntryTag));
list.Add(SqlConnManager.GetConnParameters("ReportName", "ReportName", 100, GenericDataType.String, ParameterDirection.Input, obj.ReportName));
list.Add(SqlConnManager.GetConnParameters("MailTime", "MailTime", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.MailTime));
list.Add(SqlConnManager.GetConnParameters("MailToID", "MailToID", 200, GenericDataType.String, ParameterDirection.Input, obj.MailToID));
list.Add(SqlConnManager.GetConnParameters("MailCCID", "MailCCID", 200, GenericDataType.String, ParameterDirection.Input, obj.MailCCID));
list.Add(SqlConnManager.GetConnParameters("MailBCCID", "MailBCCID", 200, GenericDataType.String, ParameterDirection.Input, obj.MailBCCID));
list.Add(SqlConnManager.GetConnParameters("SName", "SName", 10, GenericDataType.String, ParameterDirection.Input, obj.SName));
list.Add(SqlConnManager.GetConnParameters("Phone1", "Phone1", 10, GenericDataType.String, ParameterDirection.Input, obj.Phone1));
list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser));
list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime));
list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser));
list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime));
list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy));
list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy));
list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT));
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 DataBaseResultSet SaveCompanyDetail <T>(T objData) where T : class, IModel, new()
{
CompanyDetail obj = objData as CompanyDetail;
string sQuery = "sprocCompanyDetailInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo));
list.Add(SqlConnManager.GetConnParameters("CompanyCode", "CompanyCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.CompanyCode));
list.Add(SqlConnManager.GetConnParameters("AccountCode", "AccountCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.AccountCode));
list.Add(SqlConnManager.GetConnParameters("CashDiscount", "CashDiscount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.CashDiscount));
list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser));
list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime));
list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser));
list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime));
list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy));
list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy));
list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT));
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 DataBaseResultSet SaveT_TranPurchaseOrder <T>(T objData) where T : class, IModel, new()
{
T_TranPurchaseOrder obj = objData as T_TranPurchaseOrder;
string sQuery = "sprocT_TranPurchaseOrderInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("TranPurchaseOrderId", "TranPurchaseOrderId", 10, GenericDataType.String, ParameterDirection.Input, obj.TranPurchaseOrderId));
list.Add(SqlConnManager.GetConnParameters("ConfirmationNo", "ConfirmationNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.ConfirmationNo));
list.Add(SqlConnManager.GetConnParameters("CompanyId", "CompanyId", 4, GenericDataType.Int, ParameterDirection.Input, obj.CompanyId));
list.Add(SqlConnManager.GetConnParameters("CurrDate", "CurrDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CurrDate));
list.Add(SqlConnManager.GetConnParameters("PartyId", "PartyId", 8, GenericDataType.Long, ParameterDirection.Input, obj.PartyId));
list.Add(SqlConnManager.GetConnParameters("WeaverCode", "WeaverCode", 4, GenericDataType.Int, ParameterDirection.Input, obj.WeaverCode));
list.Add(SqlConnManager.GetConnParameters("QualityCode", "QualityCode", 4, GenericDataType.Int, ParameterDirection.Input, obj.QualityCode));
list.Add(SqlConnManager.GetConnParameters("BrokerCode", "BrokerCode", 4, GenericDataType.Int, ParameterDirection.Input, obj.BrokerCode));
list.Add(SqlConnManager.GetConnParameters("ThanCount", "ThanCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.ThanCount));
list.Add(SqlConnManager.GetConnParameters("Rate", "Rate", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Rate));
list.Add(SqlConnManager.GetConnParameters("CD", "CD", 50, GenericDataType.String, ParameterDirection.Input, obj.CD));
list.Add(SqlConnManager.GetConnParameters("Side", "Side", 50, GenericDataType.String, ParameterDirection.Input, obj.Side));
list.Add(SqlConnManager.GetConnParameters("Packing", "Packing", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Packing));
list.Add(SqlConnManager.GetConnParameters("PendingThan", "PendingThan", 4, GenericDataType.Int, ParameterDirection.Input, obj.PendingThan));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, DateTime.Now));
list.Add(SqlConnManager.GetConnParameters("PrimKeyId", "PrimKeyId", 4, GenericDataType.Int, ParameterDirection.Input, obj.PrimKeyTableId));
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 DataBaseResultSet SaveAdjDetail <T>(T objData) where T : class, IModel, new()
{
AdjDetail obj = objData as AdjDetail;
string sQuery = "sprocAdjDetailInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo));
list.Add(SqlConnManager.GetConnParameters("CodeName", "CodeName", 30, GenericDataType.String, ParameterDirection.Input, obj.CodeName));
list.Add(SqlConnManager.GetConnParameters("CodeRef", "CodeRef", 8, GenericDataType.Long, ParameterDirection.Input, obj.CodeRef));
list.Add(SqlConnManager.GetConnParameters("BillTag", "BillTag", 20, GenericDataType.String, ParameterDirection.Input, obj.BillTag));
list.Add(SqlConnManager.GetConnParameters("BillType", "BillType", 20, GenericDataType.String, ParameterDirection.Input, obj.BillType));
list.Add(SqlConnManager.GetConnParameters("BillCredit", "BillCredit", 10, GenericDataType.String, ParameterDirection.Input, obj.BillCredit));
list.Add(SqlConnManager.GetConnParameters("BillSeries", "BillSeries", 1, GenericDataType.String, ParameterDirection.Input, obj.BillSeries));
list.Add(SqlConnManager.GetConnParameters("BillNo", "BillNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.BillNo));
list.Add(SqlConnManager.GetConnParameters("BillDate", "BillDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.BillDate));
list.Add(SqlConnManager.GetConnParameters("PurBillNo", "PurBillNo", 10, GenericDataType.String, ParameterDirection.Input, obj.PurBillNo));
list.Add(SqlConnManager.GetConnParameters("AccountCode", "AccountCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.AccountCode));
list.Add(SqlConnManager.GetConnParameters("Amount", "Amount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Amount));
list.Add(SqlConnManager.GetConnParameters("RcptAmount", "RcptAmount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.RcptAmount));
list.Add(SqlConnManager.GetConnParameters("ShiftNo", "ShiftNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.ShiftNo));
list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser));
list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime));
list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser));
list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime));
list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy));
list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy));
list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT));
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 DataBaseResultSet SaveDiseaseMaster <T>(T objData) where T : class, IModel, new()
{
DiseaseMaster obj = objData as DiseaseMaster;
string sQuery = "sprocDiseaseMasterInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("DiseaseCode", "DiseaseCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.DiseaseCode));
list.Add(SqlConnManager.GetConnParameters("ICode", "ICode", 13, GenericDataType.String, ParameterDirection.Input, obj.ICode));
list.Add(SqlConnManager.GetConnParameters("DiseaseName", "DiseaseName", 50, GenericDataType.String, ParameterDirection.Input, obj.DiseaseName));
list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser));
list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime));
list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser));
list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime));
list.Add(SqlConnManager.GetConnParameters("LCode", "LCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.LCode));
list.Add(SqlConnManager.GetConnParameters("DLock", "DLock", 3, GenericDataType.String, ParameterDirection.Input, obj.DLock));
list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy));
list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy));
list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT));
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 DataBaseResultSet SaveT_TranCash <T>(T objData) where T : class, IModel, new()
{
T_TranCash obj = objData as T_TranCash;
string sQuery = "sprocT_TranCashInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("TranBankId", "TranBankId", 8, GenericDataType.Long, ParameterDirection.Input, obj.TranBankId));
list.Add(SqlConnManager.GetConnParameters("VoucherNo", "VoucherNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.VoucherNo));
list.Add(SqlConnManager.GetConnParameters("CompanyId", "CompanyId", 4, GenericDataType.Int, ParameterDirection.Input, obj.CompanyId));
list.Add(SqlConnManager.GetConnParameters("AmountType", "AmountType", 10, GenericDataType.String, ParameterDirection.Input, obj.AmountType));
list.Add(SqlConnManager.GetConnParameters("VoucherDate", "VoucherDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.VoucherDate));
list.Add(SqlConnManager.GetConnParameters("ChequeNo", "ChequeNo", 50, GenericDataType.String, ParameterDirection.Input, obj.ChequeNo));
list.Add(SqlConnManager.GetConnParameters("BankId", "BankId", 8, GenericDataType.Long, ParameterDirection.Input, obj.BankId));
list.Add(SqlConnManager.GetConnParameters("PartyId", "PartyId", 8, GenericDataType.Long, ParameterDirection.Input, obj.PartyId));
list.Add(SqlConnManager.GetConnParameters("NoOfDay", "NoOfDay", 4, GenericDataType.Int, ParameterDirection.Input, obj.NoOfDay));
list.Add(SqlConnManager.GetConnParameters("Place", "Place", 50, GenericDataType.String, ParameterDirection.Input, obj.Place));
list.Add(SqlConnManager.GetConnParameters("BankName", "BankName", 100, GenericDataType.String, ParameterDirection.Input, obj.BankName));
list.Add(SqlConnManager.GetConnParameters("Description", "Description", 500, GenericDataType.String, ParameterDirection.Input, obj.Description));
list.Add(SqlConnManager.GetConnParameters("Amount", "Amount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Amount));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, 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 DataBaseResultSet SaveT_MstCompany <T>(T objData) where T : class, IModel, new()
{
T_MstCompany obj = objData as T_MstCompany;
string sQuery = "sprocT_MstCompanyInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("CompanyId", "CompanyId", 8, GenericDataType.Long, ParameterDirection.Input, obj.CompanyId));
list.Add(SqlConnManager.GetConnParameters("FinancialYearId", "FinancialYearId", 4, GenericDataType.Int, ParameterDirection.Input, obj.FinancialYearId));
list.Add(SqlConnManager.GetConnParameters("CompanyName", "CompanyName", 100, GenericDataType.String, ParameterDirection.Input, obj.CompanyName));
list.Add(SqlConnManager.GetConnParameters("Add1", "Add1", 100, GenericDataType.String, ParameterDirection.Input, obj.Add1));
list.Add(SqlConnManager.GetConnParameters("Add2", "Add2", 100, GenericDataType.String, ParameterDirection.Input, obj.Add2));
list.Add(SqlConnManager.GetConnParameters("Place", "Place", 50, GenericDataType.String, ParameterDirection.Input, obj.Place));
list.Add(SqlConnManager.GetConnParameters("PhoneNo", "PhoneNo", 50, GenericDataType.String, ParameterDirection.Input, obj.PhoneNo));
list.Add(SqlConnManager.GetConnParameters("PhoneNo1", "PhoneNo1", 50, GenericDataType.String, ParameterDirection.Input, obj.PhoneNo1));
list.Add(SqlConnManager.GetConnParameters("MobileNo", "MobileNo", 50, GenericDataType.String, ParameterDirection.Input, obj.MobileNo));
list.Add(SqlConnManager.GetConnParameters("PanNo", "PanNo", 15, GenericDataType.String, ParameterDirection.Input, obj.PanNo));
list.Add(SqlConnManager.GetConnParameters("ECCNo", "ECCNo", 50, GenericDataType.String, ParameterDirection.Input, obj.ECCNo));
list.Add(SqlConnManager.GetConnParameters("TdsNo", "TdsNo", 50, GenericDataType.String, ParameterDirection.Input, obj.TdsNo));
list.Add(SqlConnManager.GetConnParameters("AccountNo", "AccountNo", 50, GenericDataType.String, ParameterDirection.Input, obj.AccountNo));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, DateTime.Now));
list.Add(SqlConnManager.GetConnParameters("PrimKeyId", "PrimKeyId", 4, GenericDataType.Int, ParameterDirection.Input, obj.PrimKeyTableId));
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 DataBaseResultSet SaveShiftMaster <T>(T objData) where T : class, IModel, new()
{
ShiftMaster obj = objData as ShiftMaster;
string sQuery = "sprocShiftMasterInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo));
list.Add(SqlConnManager.GetConnParameters("ShiftName", "ShiftName", 50, GenericDataType.String, ParameterDirection.Input, obj.ShiftName));
list.Add(SqlConnManager.GetConnParameters("ShiftNo", "ShiftNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.ShiftNo));
list.Add(SqlConnManager.GetConnParameters("ShiftDate", "ShiftDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.ShiftDate));
list.Add(SqlConnManager.GetConnParameters("OpCash", "OpCash", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.OpCash));
list.Add(SqlConnManager.GetConnParameters("CashReceipt", "CashReceipt", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.CashReceipt));
list.Add(SqlConnManager.GetConnParameters("ReceiptVoucher", "ReceiptVoucher", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.ReceiptVoucher));
list.Add(SqlConnManager.GetConnParameters("CashReturn", "CashReturn", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.CashReturn));
list.Add(SqlConnManager.GetConnParameters("CashPayment", "CashPayment", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.CashPayment));
list.Add(SqlConnManager.GetConnParameters("PaymentVoucher", "PaymentVoucher", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.PaymentVoucher));
list.Add(SqlConnManager.GetConnParameters("ExtraAmount", "ExtraAmount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.ExtraAmount));
list.Add(SqlConnManager.GetConnParameters("Amount", "Amount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Amount));
list.Add(SqlConnManager.GetConnParameters("ShiftMess", "ShiftMess", 100, GenericDataType.String, ParameterDirection.Input, obj.ShiftMess));
list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser));
list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime));
list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser));
list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime));
list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy));
list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy));
list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT));
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 DataBaseResultSet SaveTallyMaster <T>(T objData) where T : class, IModel, new()
{
TallyMaster obj = objData as TallyMaster;
string sQuery = "sprocTallyMasterInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo));
list.Add(SqlConnManager.GetConnParameters("TallyTag", "TallyTag", 10, GenericDataType.String, ParameterDirection.Input, obj.TallyTag));
list.Add(SqlConnManager.GetConnParameters("AccountCode", "AccountCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.AccountCode));
list.Add(SqlConnManager.GetConnParameters("VAT", "VAT", 5, GenericDataType.String, ParameterDirection.Input, obj.VAT));
list.Add(SqlConnManager.GetConnParameters("TallyLedger", "TallyLedger", 100, GenericDataType.String, ParameterDirection.Input, obj.TallyLedger));
list.Add(SqlConnManager.GetConnParameters("TallyVATLedger", "TallyVATLedger", 100, GenericDataType.String, ParameterDirection.Input, obj.TallyVATLedger));
list.Add(SqlConnManager.GetConnParameters("TallyClass", "TallyClass", 100, GenericDataType.String, ParameterDirection.Input, obj.TallyClass));
list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser));
list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime));
list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser));
list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime));
list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy));
list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy));
list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT));
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 DataBaseResultSet SaveReceivePayment <T>(T objData) where T : class, IModel, new()
{
ReceivePayment obj = objData as ReceivePayment;
string sQuery = "sprocReceivePaymentInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo));
list.Add(SqlConnManager.GetConnParameters("EntryTag", "EntryTag", 30, GenericDataType.String, ParameterDirection.Input, obj.EntryTag));
list.Add(SqlConnManager.GetConnParameters("RefNo", "RefNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RefNo));
list.Add(SqlConnManager.GetConnParameters("EntryDate", "EntryDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EntryDate));
list.Add(SqlConnManager.GetConnParameters("ChequeNo", "ChequeNo", 10, GenericDataType.String, ParameterDirection.Input, obj.ChequeNo));
list.Add(SqlConnManager.GetConnParameters("ChequeDate", "ChequeDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.ChequeDate));
list.Add(SqlConnManager.GetConnParameters("AccountCode1", "AccountCode1", 8, GenericDataType.Long, ParameterDirection.Input, obj.AccountCode1));
list.Add(SqlConnManager.GetConnParameters("AccountCode2", "AccountCode2", 8, GenericDataType.Long, ParameterDirection.Input, obj.AccountCode2));
list.Add(SqlConnManager.GetConnParameters("Amount", "Amount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Amount));
list.Add(SqlConnManager.GetConnParameters("RcptMess", "RcptMess", 100, GenericDataType.String, ParameterDirection.Input, obj.RcptMess));
list.Add(SqlConnManager.GetConnParameters("ReconDate", "ReconDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.ReconDate));
list.Add(SqlConnManager.GetConnParameters("ShiftNo", "ShiftNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.ShiftNo));
list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser));
list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime));
list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser));
list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime));
list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy));
list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy));
list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT));
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 DataBaseResultSet SaveConfig <T>(T objData) where T : class, IModel, new()
{
Config obj = objData as Config;
string sQuery = "sprocConfigInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo));
list.Add(SqlConnManager.GetConnParameters("DfltVariable", "DfltVariable", 50, GenericDataType.String, ParameterDirection.Input, obj.DfltVariable));
list.Add(SqlConnManager.GetConnParameters("DfltValue", "DfltValue", 50, GenericDataType.String, ParameterDirection.Input, obj.DfltValue));
list.Add(SqlConnManager.GetConnParameters("USERCODE", "USERCODE", 8, GenericDataType.Long, ParameterDirection.Input, obj.USERCODE));
list.Add(SqlConnManager.GetConnParameters("CUSER", "CUSER", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUSER));
list.Add(SqlConnManager.GetConnParameters("CDATETIME", "CDATETIME", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDATETIME));
list.Add(SqlConnManager.GetConnParameters("EUSER", "EUSER", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUSER));
list.Add(SqlConnManager.GetConnParameters("EDATETIME", "EDATETIME", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDATETIME));
list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy));
list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy));
list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT));
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 DataBaseResultSet SaveBranchStock <T>(T objData) where T : class, IModel, new()
{
BranchStock obj = objData as BranchStock;
string sQuery = "sprocBranchStockInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo));
list.Add(SqlConnManager.GetConnParameters("BranchName", "BranchName", 50, GenericDataType.String, ParameterDirection.Input, obj.BranchName));
list.Add(SqlConnManager.GetConnParameters("ProductCode", "ProductCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.ProductCode));
list.Add(SqlConnManager.GetConnParameters("PartyPrdCode", "PartyPrdCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.PartyPrdCode));
list.Add(SqlConnManager.GetConnParameters("ProductName", "ProductName", 50, GenericDataType.String, ParameterDirection.Input, obj.ProductName));
list.Add(SqlConnManager.GetConnParameters("Packing", "Packing", 50, GenericDataType.String, ParameterDirection.Input, obj.Packing));
list.Add(SqlConnManager.GetConnParameters("CompanyTag", "CompanyTag", 50, GenericDataType.String, ParameterDirection.Input, obj.CompanyTag));
list.Add(SqlConnManager.GetConnParameters("RackID", "RackID", 50, GenericDataType.String, ParameterDirection.Input, obj.RackID));
list.Add(SqlConnManager.GetConnParameters("TStk", "TStk", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.TStk));
list.Add(SqlConnManager.GetConnParameters("Scheme", "Scheme", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Scheme));
list.Add(SqlConnManager.GetConnParameters("SQty", "SQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SQty));
list.Add(SqlConnManager.GetConnParameters("SFQty", "SFQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SFQty));
list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser));
list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime));
list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser));
list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime));
list.Add(SqlConnManager.GetConnParameters("BranchCode", "BranchCode", 10, GenericDataType.String, ParameterDirection.Input, obj.BranchCode));
list.Add(SqlConnManager.GetConnParameters("UDateTime", "UDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UDateTime));
list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy));
list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy));
list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT));
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 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 DataBaseResultSet SaveT_ErrorDesc <T>(T objData) where T : class, IModel, new()
{
T_ErrorDesc obj = objData as T_ErrorDesc;
string sQuery = "sprocT_ErrorDescInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("ErrorId", "ErrorId", 8, GenericDataType.Long, ParameterDirection.Input, obj.ErrorId));
list.Add(SqlConnManager.GetConnParameters("CategoryId", "CategoryId", 4, GenericDataType.Int, ParameterDirection.Input, obj.CategoryId));
list.Add(SqlConnManager.GetConnParameters("PageCode", "PageCode", 4, GenericDataType.Int, ParameterDirection.Input, obj.PageCode));
list.Add(SqlConnManager.GetConnParameters("MethodCode", "MethodCode", 4, GenericDataType.Int, ParameterDirection.Input, obj.MethodCode));
list.Add(SqlConnManager.GetConnParameters("EventCode", "EventCode", 4, GenericDataType.Int, ParameterDirection.Input, obj.EventCode));
list.Add(SqlConnManager.GetConnParameters("ErrorLineNo", "ErrorLineNo", 4, GenericDataType.Int, ParameterDirection.Input, obj.ErrorLineNo));
list.Add(SqlConnManager.GetConnParameters("MethodTrace", "MethodTrace", 100, GenericDataType.String, ParameterDirection.Input, obj.MethodTrace));
list.Add(SqlConnManager.GetConnParameters("EmpNo", "EmpNo", 10, GenericDataType.String, ParameterDirection.Input, obj.EmpNo));
list.Add(SqlConnManager.GetConnParameters("ClientIPAddress", "ClientIPAddress", 30, GenericDataType.String, ParameterDirection.Input, obj.ClientIPAddress));
list.Add(SqlConnManager.GetConnParameters("PageName", "PageName", 50, GenericDataType.String, ParameterDirection.Input, obj.PageName));
list.Add(SqlConnManager.GetConnParameters("MethodName", "MethodName", 50, GenericDataType.String, ParameterDirection.Input, obj.MethodName));
list.Add(SqlConnManager.GetConnParameters("ErrorMsg", "ErrorMsg", 500, GenericDataType.String, ParameterDirection.Input, obj.ErrorMsg));
list.Add(SqlConnManager.GetConnParameters("ErrorType", "ErrorType", 50, GenericDataType.String, ParameterDirection.Input, obj.ErrorType));
list.Add(SqlConnManager.GetConnParameters("ErrorDate", "ErrorDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.ErrorDate));
list.Add(SqlConnManager.GetConnParameters("ErrorData", "ErrorData", -1, GenericDataType.String, ParameterDirection.Input, obj.ErrorData));
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 DataBaseResultSet SavePreFormat <T>(T objData) where T : class, IModel, new()
{
PreFormat obj = objData as PreFormat;
string sQuery = "sprocPreFormatInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo));
list.Add(SqlConnManager.GetConnParameters("BillNo", "BillNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.BillNo));
list.Add(SqlConnManager.GetConnParameters("BillDate", "BillDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.BillDate));
list.Add(SqlConnManager.GetConnParameters("CustomerCode", "CustomerCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.CustomerCode));
list.Add(SqlConnManager.GetConnParameters("DoctorCode", "DoctorCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.DoctorCode));
list.Add(SqlConnManager.GetConnParameters("ProductCode", "ProductCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.ProductCode));
list.Add(SqlConnManager.GetConnParameters("Qty", "Qty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Qty));
list.Add(SqlConnManager.GetConnParameters("Remark", "Remark", 50, GenericDataType.String, ParameterDirection.Input, obj.Remark));
list.Add(SqlConnManager.GetConnParameters("ReminderTag", "ReminderTag", 10, GenericDataType.String, ParameterDirection.Input, obj.ReminderTag));
list.Add(SqlConnManager.GetConnParameters("ReminderOn", "ReminderOn", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.ReminderOn));
list.Add(SqlConnManager.GetConnParameters("ReminderUpTo", "ReminderUpTo", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.ReminderUpTo));
list.Add(SqlConnManager.GetConnParameters("Disc", "Disc", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Disc));
list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser));
list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime));
list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser));
list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime));
list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy));
list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy));
list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT));
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 DataBaseResultSet SaveOrderDetail <T>(T objData) where T : class, IModel, new()
{
OrderDetail obj = objData as OrderDetail;
string sQuery = "sprocOrderDetailInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo));
list.Add(SqlConnManager.GetConnParameters("BillTag", "BillTag", 20, GenericDataType.String, ParameterDirection.Input, obj.BillTag));
list.Add(SqlConnManager.GetConnParameters("BillType", "BillType", 20, GenericDataType.String, ParameterDirection.Input, obj.BillType));
list.Add(SqlConnManager.GetConnParameters("BillCredit", "BillCredit", 10, GenericDataType.String, ParameterDirection.Input, obj.BillCredit));
list.Add(SqlConnManager.GetConnParameters("BillSeries", "BillSeries", 1, GenericDataType.String, ParameterDirection.Input, obj.BillSeries));
list.Add(SqlConnManager.GetConnParameters("BillNo", "BillNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.BillNo));
list.Add(SqlConnManager.GetConnParameters("BillDate", "BillDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.BillDate));
list.Add(SqlConnManager.GetConnParameters("AccountCode", "AccountCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.AccountCode));
list.Add(SqlConnManager.GetConnParameters("ChallanNo", "ChallanNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.ChallanNo));
list.Add(SqlConnManager.GetConnParameters("ChallanDate", "ChallanDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.ChallanDate));
list.Add(SqlConnManager.GetConnParameters("EntryTag", "EntryTag", 8, GenericDataType.String, ParameterDirection.Input, obj.EntryTag));
list.Add(SqlConnManager.GetConnParameters("ProductCode", "ProductCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.ProductCode));
list.Add(SqlConnManager.GetConnParameters("CompanyCode", "CompanyCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.CompanyCode));
list.Add(SqlConnManager.GetConnParameters("BatchCode", "BatchCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.BatchCode));
list.Add(SqlConnManager.GetConnParameters("MRP", "MRP", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.MRP));
list.Add(SqlConnManager.GetConnParameters("BatchNo", "BatchNo", 15, GenericDataType.String, ParameterDirection.Input, obj.BatchNo));
list.Add(SqlConnManager.GetConnParameters("Expiry", "Expiry", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.Expiry));
list.Add(SqlConnManager.GetConnParameters("Qty", "Qty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Qty));
list.Add(SqlConnManager.GetConnParameters("FQty", "FQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.FQty));
list.Add(SqlConnManager.GetConnParameters("ConversionUnit", "ConversionUnit", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.ConversionUnit));
list.Add(SqlConnManager.GetConnParameters("Rate", "Rate", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Rate));
list.Add(SqlConnManager.GetConnParameters("HalfScheme", "HalfScheme", 3, GenericDataType.String, ParameterDirection.Input, obj.HalfScheme));
list.Add(SqlConnManager.GetConnParameters("Scheme", "Scheme", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Scheme));
list.Add(SqlConnManager.GetConnParameters("SchemeRs", "SchemeRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SchemeRs));
list.Add(SqlConnManager.GetConnParameters("SplDisc", "SplDisc", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SplDisc));
list.Add(SqlConnManager.GetConnParameters("SplDiscRs", "SplDiscRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SplDiscRs));
list.Add(SqlConnManager.GetConnParameters("Disc", "Disc", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Disc));
list.Add(SqlConnManager.GetConnParameters("DiscRs", "DiscRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.DiscRs));
list.Add(SqlConnManager.GetConnParameters("Inclusive", "Inclusive", 3, GenericDataType.String, ParameterDirection.Input, obj.Inclusive));
list.Add(SqlConnManager.GetConnParameters("VatOn", "VatOn", 5, GenericDataType.String, ParameterDirection.Input, obj.VatOn));
list.Add(SqlConnManager.GetConnParameters("Vat", "Vat", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Vat));
list.Add(SqlConnManager.GetConnParameters("VatRs", "VatRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.VatRs));
list.Add(SqlConnManager.GetConnParameters("AdVat", "AdVat", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.AdVat));
list.Add(SqlConnManager.GetConnParameters("AdVatRs", "AdVatRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.AdVatRs));
list.Add(SqlConnManager.GetConnParameters("NetRate", "NetRate", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.NetRate));
list.Add(SqlConnManager.GetConnParameters("VatOnFree", "VatOnFree", 3, GenericDataType.String, ParameterDirection.Input, obj.VatOnFree));
list.Add(SqlConnManager.GetConnParameters("NetCostRate", "NetCostRate", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.NetCostRate));
list.Add(SqlConnManager.GetConnParameters("NetAmount", "NetAmount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.NetAmount));
list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser));
list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime));
list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser));
list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime));
list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy));
list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy));
list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT));
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 DataBaseResultSet SaveOrderMaster <T>(T objData) where T : class, IModel, new()
{
OrderMaster obj = objData as OrderMaster;
string sQuery = "sprocOrderMasterInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo));
list.Add(SqlConnManager.GetConnParameters("BillTag", "BillTag", 20, GenericDataType.String, ParameterDirection.Input, obj.BillTag));
list.Add(SqlConnManager.GetConnParameters("BillType", "BillType", 20, GenericDataType.String, ParameterDirection.Input, obj.BillType));
list.Add(SqlConnManager.GetConnParameters("BillCredit", "BillCredit", 10, GenericDataType.String, ParameterDirection.Input, obj.BillCredit));
list.Add(SqlConnManager.GetConnParameters("BillSeries", "BillSeries", 1, GenericDataType.String, ParameterDirection.Input, obj.BillSeries));
list.Add(SqlConnManager.GetConnParameters("BillNo", "BillNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.BillNo));
list.Add(SqlConnManager.GetConnParameters("BillDate", "BillDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.BillDate));
list.Add(SqlConnManager.GetConnParameters("PurBillNo", "PurBillNo", 10, GenericDataType.String, ParameterDirection.Input, obj.PurBillNo));
list.Add(SqlConnManager.GetConnParameters("PurBillDate", "PurBillDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.PurBillDate));
list.Add(SqlConnManager.GetConnParameters("CustomerCode", "CustomerCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.CustomerCode));
list.Add(SqlConnManager.GetConnParameters("DoctorCode", "DoctorCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.DoctorCode));
list.Add(SqlConnManager.GetConnParameters("AccountCode", "AccountCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.AccountCode));
list.Add(SqlConnManager.GetConnParameters("SalesmanCode", "SalesmanCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.SalesmanCode));
list.Add(SqlConnManager.GetConnParameters("VatInRate", "VatInRate", 3, GenericDataType.String, ParameterDirection.Input, obj.VatInRate));
list.Add(SqlConnManager.GetConnParameters("GrossAmount", "GrossAmount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.GrossAmount));
list.Add(SqlConnManager.GetConnParameters("SchemeRs", "SchemeRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SchemeRs));
list.Add(SqlConnManager.GetConnParameters("SplDiscRs", "SplDiscRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SplDiscRs));
list.Add(SqlConnManager.GetConnParameters("DiscPer", "DiscPer", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.DiscPer));
list.Add(SqlConnManager.GetConnParameters("DiscRs", "DiscRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.DiscRs));
list.Add(SqlConnManager.GetConnParameters("VatPer", "VatPer", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.VatPer));
list.Add(SqlConnManager.GetConnParameters("VatRs", "VatRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.VatRs));
list.Add(SqlConnManager.GetConnParameters("AdVatPer", "AdVatPer", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.AdVatPer));
list.Add(SqlConnManager.GetConnParameters("AdVatRs", "AdVatRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.AdVatRs));
list.Add(SqlConnManager.GetConnParameters("CrRs", "CrRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.CrRs));
list.Add(SqlConnManager.GetConnParameters("OtherAdj", "OtherAdj", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.OtherAdj));
list.Add(SqlConnManager.GetConnParameters("RndOff", "RndOff", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.RndOff));
list.Add(SqlConnManager.GetConnParameters("NetAmount", "NetAmount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.NetAmount));
list.Add(SqlConnManager.GetConnParameters("RateTag", "RateTag", 10, GenericDataType.String, ParameterDirection.Input, obj.RateTag));
list.Add(SqlConnManager.GetConnParameters("OrdRef", "OrdRef", 20, GenericDataType.String, ParameterDirection.Input, obj.OrdRef));
list.Add(SqlConnManager.GetConnParameters("ModOfDespatch", "ModOfDespatch", 20, GenericDataType.String, ParameterDirection.Input, obj.ModOfDespatch));
list.Add(SqlConnManager.GetConnParameters("RRNo", "RRNo", 20, GenericDataType.String, ParameterDirection.Input, obj.RRNo));
list.Add(SqlConnManager.GetConnParameters("NoOfPack", "NoOfPack", 20, GenericDataType.String, ParameterDirection.Input, obj.NoOfPack));
list.Add(SqlConnManager.GetConnParameters("DespDate", "DespDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.DespDate));
list.Add(SqlConnManager.GetConnParameters("SplInst", "SplInst", 50, GenericDataType.String, ParameterDirection.Input, obj.SplInst));
list.Add(SqlConnManager.GetConnParameters("RcptAmount", "RcptAmount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.RcptAmount));
list.Add(SqlConnManager.GetConnParameters("MiscPndAmount", "MiscPndAmount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.MiscPndAmount));
list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser));
list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime));
list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser));
list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime));
list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy));
list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy));
list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT));
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 DataBaseResultSet SaveAccountMaster <T>(T objData) where T : class, IModel, new()
{
AccountMaster obj = objData as AccountMaster;
string sQuery = "sprocAccountMasterInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("AccountCode", "AccountCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.AccountCode));
list.Add(SqlConnManager.GetConnParameters("ICode", "ICode", 13, GenericDataType.String, ParameterDirection.Input, obj.ICode));
list.Add(SqlConnManager.GetConnParameters("AccountName", "AccountName", 50, GenericDataType.String, ParameterDirection.Input, obj.AccountName));
list.Add(SqlConnManager.GetConnParameters("Add1", "Add1", 50, GenericDataType.String, ParameterDirection.Input, obj.Add1));
list.Add(SqlConnManager.GetConnParameters("Add2", "Add2", 50, GenericDataType.String, ParameterDirection.Input, obj.Add2));
list.Add(SqlConnManager.GetConnParameters("Add3", "Add3", 50, GenericDataType.String, ParameterDirection.Input, obj.Add3));
list.Add(SqlConnManager.GetConnParameters("Add4", "Add4", 50, GenericDataType.String, ParameterDirection.Input, obj.Add4));
list.Add(SqlConnManager.GetConnParameters("CityCode", "CityCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.CityCode));
list.Add(SqlConnManager.GetConnParameters("ContactPerson", "ContactPerson", 50, GenericDataType.String, ParameterDirection.Input, obj.ContactPerson));
list.Add(SqlConnManager.GetConnParameters("Phone1", "Phone1", 50, GenericDataType.String, ParameterDirection.Input, obj.Phone1));
list.Add(SqlConnManager.GetConnParameters("Phone2", "Phone2", 50, GenericDataType.String, ParameterDirection.Input, obj.Phone2));
list.Add(SqlConnManager.GetConnParameters("Email", "Email", 50, GenericDataType.String, ParameterDirection.Input, obj.Email));
list.Add(SqlConnManager.GetConnParameters("DLNo1", "DLNo1", 50, GenericDataType.String, ParameterDirection.Input, obj.DLNo1));
list.Add(SqlConnManager.GetConnParameters("DLNo2", "DLNo2", 50, GenericDataType.String, ParameterDirection.Input, obj.DLNo2));
list.Add(SqlConnManager.GetConnParameters("VatTin", "VatTin", 50, GenericDataType.String, ParameterDirection.Input, obj.VatTin));
list.Add(SqlConnManager.GetConnParameters("VatDate", "VatDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.VatDate));
list.Add(SqlConnManager.GetConnParameters("CSTVat", "CSTVat", 50, GenericDataType.String, ParameterDirection.Input, obj.CSTVat));
list.Add(SqlConnManager.GetConnParameters("CSTVatDate", "CSTVatDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CSTVatDate));
list.Add(SqlConnManager.GetConnParameters("CashDiscount", "CashDiscount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.CashDiscount));
list.Add(SqlConnManager.GetConnParameters("BillSeries", "BillSeries", 20, GenericDataType.String, ParameterDirection.Input, obj.BillSeries));
list.Add(SqlConnManager.GetConnParameters("BillType", "BillType", 20, GenericDataType.String, ParameterDirection.Input, obj.BillType));
list.Add(SqlConnManager.GetConnParameters("AccountType", "AccountType", 50, GenericDataType.String, ParameterDirection.Input, obj.AccountType));
list.Add(SqlConnManager.GetConnParameters("GroupCode", "GroupCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.GroupCode));
list.Add(SqlConnManager.GetConnParameters("VisitDay", "VisitDay", 21, GenericDataType.String, ParameterDirection.Input, obj.VisitDay));
list.Add(SqlConnManager.GetConnParameters("InfoID", "InfoID", 10, GenericDataType.String, ParameterDirection.Input, obj.InfoID));
list.Add(SqlConnManager.GetConnParameters("OpBalAmount", "OpBalAmount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.OpBalAmount));
list.Add(SqlConnManager.GetConnParameters("OpSetAmount", "OpSetAmount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.OpSetAmount));
list.Add(SqlConnManager.GetConnParameters("BalAmount", "BalAmount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.BalAmount));
list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser));
list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime));
list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser));
list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime));
list.Add(SqlConnManager.GetConnParameters("LCode", "LCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.LCode));
list.Add(SqlConnManager.GetConnParameters("DLock", "DLock", 3, GenericDataType.String, ParameterDirection.Input, obj.DLock));
list.Add(SqlConnManager.GetConnParameters("ChequeName", "ChequeName", 50, GenericDataType.String, ParameterDirection.Input, obj.ChequeName));
list.Add(SqlConnManager.GetConnParameters("LBT", "LBT", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.LBT));
list.Add(SqlConnManager.GetConnParameters("LBTNo", "LBTNo", 50, GenericDataType.String, ParameterDirection.Input, obj.LBTNo));
list.Add(SqlConnManager.GetConnParameters("LBTCat", "LBTCat", 50, GenericDataType.String, ParameterDirection.Input, obj.LBTCat));
list.Add(SqlConnManager.GetConnParameters("DueDay", "DueDay", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.DueDay));
list.Add(SqlConnManager.GetConnParameters("MailFormat", "MailFormat", 50, GenericDataType.String, ParameterDirection.Input, obj.MailFormat));
list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy));
list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT));
list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy));
list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount));
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 DataBaseResultSet SavePrintFormat <T>(T objData) where T : class, IModel, new()
{
PrintFormat obj = objData as PrintFormat;
string sQuery = "sprocPrintFormatInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo));
list.Add(SqlConnManager.GetConnParameters("LabelType", "LabelType", 50, GenericDataType.String, ParameterDirection.Input, obj.LabelType));
list.Add(SqlConnManager.GetConnParameters("OprtSys", "OprtSys", 50, GenericDataType.String, ParameterDirection.Input, obj.OprtSys));
list.Add(SqlConnManager.GetConnParameters("FormatName", "FormatName", 50, GenericDataType.String, ParameterDirection.Input, obj.FormatName));
list.Add(SqlConnManager.GetConnParameters("PrinterName", "PrinterName", 50, GenericDataType.String, ParameterDirection.Input, obj.PrinterName));
list.Add(SqlConnManager.GetConnParameters("TxtType", "TxtType", 50, GenericDataType.String, ParameterDirection.Input, obj.TxtType));
list.Add(SqlConnManager.GetConnParameters("SampleTxt", "SampleTxt", 200, GenericDataType.String, ParameterDirection.Input, obj.SampleTxt));
list.Add(SqlConnManager.GetConnParameters("FPrefix", "FPrefix", 50, GenericDataType.String, ParameterDirection.Input, obj.FPrefix));
list.Add(SqlConnManager.GetConnParameters("FldName", "FldName", 50, GenericDataType.String, ParameterDirection.Input, obj.FldName));
list.Add(SqlConnManager.GetConnParameters("FSufix", "FSufix", 50, GenericDataType.String, ParameterDirection.Input, obj.FSufix));
list.Add(SqlConnManager.GetConnParameters("PrntFormat", "PrntFormat", 50, GenericDataType.String, ParameterDirection.Input, obj.PrntFormat));
list.Add(SqlConnManager.GetConnParameters("PosX", "PosX", 8, GenericDataType.Long, ParameterDirection.Input, obj.PosX));
list.Add(SqlConnManager.GetConnParameters("PosY", "PosY", 8, GenericDataType.Long, ParameterDirection.Input, obj.PosY));
list.Add(SqlConnManager.GetConnParameters("PWidth", "PWidth", 8, GenericDataType.Long, ParameterDirection.Input, obj.PWidth));
list.Add(SqlConnManager.GetConnParameters("PHeight", "PHeight", 8, GenericDataType.Long, ParameterDirection.Input, obj.PHeight));
list.Add(SqlConnManager.GetConnParameters("FntName", "FntName", 50, GenericDataType.String, ParameterDirection.Input, obj.FntName));
list.Add(SqlConnManager.GetConnParameters("FntStyle", "FntStyle", 50, GenericDataType.String, ParameterDirection.Input, obj.FntStyle));
list.Add(SqlConnManager.GetConnParameters("FntBold", "FntBold", 3, GenericDataType.String, ParameterDirection.Input, obj.FntBold));
list.Add(SqlConnManager.GetConnParameters("FntItalic", "FntItalic", 3, GenericDataType.String, ParameterDirection.Input, obj.FntItalic));
list.Add(SqlConnManager.GetConnParameters("FntStrikout", "FntStrikout", 3, GenericDataType.String, ParameterDirection.Input, obj.FntStrikout));
list.Add(SqlConnManager.GetConnParameters("FntUnderLine", "FntUnderLine", 3, GenericDataType.String, ParameterDirection.Input, obj.FntUnderLine));
list.Add(SqlConnManager.GetConnParameters("FntSize", "FntSize", 8, GenericDataType.Long, ParameterDirection.Input, obj.FntSize));
list.Add(SqlConnManager.GetConnParameters("FntColor", "FntColor", 8, GenericDataType.Long, ParameterDirection.Input, obj.FntColor));
list.Add(SqlConnManager.GetConnParameters("AcrossLbl", "AcrossLbl", 8, GenericDataType.Long, ParameterDirection.Input, obj.AcrossLbl));
list.Add(SqlConnManager.GetConnParameters("PgLbl", "PgLbl", 8, GenericDataType.Long, ParameterDirection.Input, obj.PgLbl));
list.Add(SqlConnManager.GetConnParameters("DuplicateLbl", "DuplicateLbl", 3, GenericDataType.String, ParameterDirection.Input, obj.DuplicateLbl));
list.Add(SqlConnManager.GetConnParameters("PgTopMargin", "PgTopMargin", 8, GenericDataType.Long, ParameterDirection.Input, obj.PgTopMargin));
list.Add(SqlConnManager.GetConnParameters("PgLeftMargin", "PgLeftMargin", 8, GenericDataType.Long, ParameterDirection.Input, obj.PgLeftMargin));
list.Add(SqlConnManager.GetConnParameters("LblVerticalGap", "LblVerticalGap", 8, GenericDataType.Long, ParameterDirection.Input, obj.LblVerticalGap));
list.Add(SqlConnManager.GetConnParameters("LblHorizontalGap", "LblHorizontalGap", 8, GenericDataType.Long, ParameterDirection.Input, obj.LblHorizontalGap));
list.Add(SqlConnManager.GetConnParameters("LblWidth", "LblWidth", 8, GenericDataType.Long, ParameterDirection.Input, obj.LblWidth));
list.Add(SqlConnManager.GetConnParameters("LblHeight", "LblHeight", 8, GenericDataType.Long, ParameterDirection.Input, obj.LblHeight));
list.Add(SqlConnManager.GetConnParameters("NoOfLine", "NoOfLine", 8, GenericDataType.Long, ParameterDirection.Input, obj.NoOfLine));
list.Add(SqlConnManager.GetConnParameters("GapLine", "GapLine", 8, GenericDataType.Long, ParameterDirection.Input, obj.GapLine));
list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser));
list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime));
list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser));
list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime));
list.Add(SqlConnManager.GetConnParameters("PrintStyle", "PrintStyle", 50, GenericDataType.String, ParameterDirection.Input, obj.PrintStyle));
list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy));
list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy));
list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT));
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 DataBaseResultSet SaveT_MstRole <T>(T objData) where T : class, IModel, new()
{
T_MstRole obj = objData as T_MstRole;
string sQuery = "sprocT_MstRoleInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("RoleId", "RoleId", 4, GenericDataType.Int, ParameterDirection.Input, obj.RoleId));
list.Add(SqlConnManager.GetConnParameters("RoleName", "RoleName", 100, GenericDataType.String, ParameterDirection.Input, obj.RoleName));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, 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 DataBaseResultSet SaveT_MstBroker <T>(T objData) where T : class, IModel, new()
{
T_MstBroker obj = objData as T_MstBroker;
string sQuery = "sprocT_MstBrokerInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("BrokerCode", "BrokerCode", 4, GenericDataType.Int, ParameterDirection.Input, obj.BrokerCode));
list.Add(SqlConnManager.GetConnParameters("CompanyId", "CompanyId", 4, GenericDataType.Int, ParameterDirection.Input, obj.CompanyId));
list.Add(SqlConnManager.GetConnParameters("BrokerName", "BrokerName", 100, GenericDataType.String, ParameterDirection.Input, obj.BrokerName));
list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag));
list.Add(SqlConnManager.GetConnParameters("PrimKeyId", "PrimKeyId", 4, GenericDataType.Int, ParameterDirection.Input, obj.PrimKeyTableId));
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 DataBaseResultSet SaveT_MstQuality <T>(T objData) where T : class, IModel, new()
{
T_MstQuality obj = objData as T_MstQuality;
string sQuery = "sprocT_MstQualityInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("QualityCode", "QualityCode", 4, GenericDataType.Int, ParameterDirection.Input, obj.QualityCode));
list.Add(SqlConnManager.GetConnParameters("CompanyId", "CompanyId", 4, GenericDataType.Int, ParameterDirection.Input, obj.CompanyId));
list.Add(SqlConnManager.GetConnParameters("QualityName", "QualityName", 100, GenericDataType.String, ParameterDirection.Input, obj.QualityName));
list.Add(SqlConnManager.GetConnParameters("OpeningStockMtrs", "OpeningStockMtrs", 4, GenericDataType.Int, ParameterDirection.Input, obj.OpeningStockMtrs));
list.Add(SqlConnManager.GetConnParameters("OpeningStockTaga", "OpeningStockTaga", 4, GenericDataType.Int, ParameterDirection.Input, obj.OpeningStockTaga));
list.Add(SqlConnManager.GetConnParameters("OpeningStockBales", "OpeningStockBales", 4, GenericDataType.Int, ParameterDirection.Input, obj.OpeningStockBales));
list.Add(SqlConnManager.GetConnParameters("Commodity", "Commodity", 200, GenericDataType.String, ParameterDirection.Input, obj.Commodity));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, DateTime.Now));
list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag));
list.Add(SqlConnManager.GetConnParameters("PrimKeyId", "PrimKeyId", 4, GenericDataType.Int, ParameterDirection.Input, obj.PrimKeyTableId));
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 DataBaseResultSet SaveOtherAdd <T>(T objData) where T : class, IModel, new()
{
OtherAdd obj = objData as OtherAdd;
string sQuery = "sprocOtherAddInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo));
list.Add(SqlConnManager.GetConnParameters("AddName", "AddName", 50, GenericDataType.String, ParameterDirection.Input, obj.AddName));
list.Add(SqlConnManager.GetConnParameters("KeyPerson", "KeyPerson", 50, GenericDataType.String, ParameterDirection.Input, obj.KeyPerson));
list.Add(SqlConnManager.GetConnParameters("Address1", "Address1", 50, GenericDataType.String, ParameterDirection.Input, obj.Address1));
list.Add(SqlConnManager.GetConnParameters("Address2", "Address2", 50, GenericDataType.String, ParameterDirection.Input, obj.Address2));
list.Add(SqlConnManager.GetConnParameters("Address3", "Address3", 50, GenericDataType.String, ParameterDirection.Input, obj.Address3));
list.Add(SqlConnManager.GetConnParameters("City", "City", 50, GenericDataType.String, ParameterDirection.Input, obj.City));
list.Add(SqlConnManager.GetConnParameters("Mobile", "Mobile", 50, GenericDataType.String, ParameterDirection.Input, obj.Mobile));
list.Add(SqlConnManager.GetConnParameters("Phone1", "Phone1", 50, GenericDataType.String, ParameterDirection.Input, obj.Phone1));
list.Add(SqlConnManager.GetConnParameters("Phone2", "Phone2", 50, GenericDataType.String, ParameterDirection.Input, obj.Phone2));
list.Add(SqlConnManager.GetConnParameters("PhoneR", "PhoneR", 50, GenericDataType.String, ParameterDirection.Input, obj.PhoneR));
list.Add(SqlConnManager.GetConnParameters("Fax", "Fax", 50, GenericDataType.String, ParameterDirection.Input, obj.Fax));
list.Add(SqlConnManager.GetConnParameters("Email", "Email", 50, GenericDataType.String, ParameterDirection.Input, obj.Email));
list.Add(SqlConnManager.GetConnParameters("Category", "Category", 50, GenericDataType.String, ParameterDirection.Input, obj.Category));
list.Add(SqlConnManager.GetConnParameters("AddNote", "AddNote", 200, GenericDataType.String, ParameterDirection.Input, obj.AddNote));
list.Add(SqlConnManager.GetConnParameters("ImageName", "ImageName", 250, GenericDataType.String, ParameterDirection.Input, obj.ImageName));
list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser));
list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime));
list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser));
list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime));
list.Add(SqlConnManager.GetConnParameters("DLock", "DLock", 3, GenericDataType.String, ParameterDirection.Input, obj.DLock));
list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy));
list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy));
list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT));
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 DataBaseResultSet SaveT_TranSalesBill <T>(T objData) where T : class, IModel, new()
{
T_TranSalesBill obj = objData as T_TranSalesBill;
string sQuery = "sprocT_TranSalesBillInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("TranSalesBillId", "TranSalesBillId", 8, GenericDataType.Long, ParameterDirection.Input, obj.TranSalesBillId));
list.Add(SqlConnManager.GetConnParameters("SalesBillNo", "SalesBillNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.SalesBillNo));
list.Add(SqlConnManager.GetConnParameters("CompanyId", "CompanyId", 4, GenericDataType.Int, ParameterDirection.Input, obj.CompanyId));
list.Add(SqlConnManager.GetConnParameters("VoucherDate", "VoucherDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.VoucherDate));
list.Add(SqlConnManager.GetConnParameters("ToMSPartyId", "ToMSPartyId", 8, GenericDataType.Long, ParameterDirection.Input, obj.ToMSPartyId));
list.Add(SqlConnManager.GetConnParameters("TransportId", "TransportId", 4, GenericDataType.Int, ParameterDirection.Input, obj.TransportId));
list.Add(SqlConnManager.GetConnParameters("CheckerId", "CheckerId", 4, GenericDataType.Int, ParameterDirection.Input, obj.CheckerId));
list.Add(SqlConnManager.GetConnParameters("LRNo", "LRNo", 50, GenericDataType.String, ParameterDirection.Input, obj.LRNo));
list.Add(SqlConnManager.GetConnParameters("LRDate", "LRDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LRDate));
list.Add(SqlConnManager.GetConnParameters("BrokerId", "BrokerId", 4, GenericDataType.Int, ParameterDirection.Input, obj.BrokerId));
list.Add(SqlConnManager.GetConnParameters("Station", "Station", 50, GenericDataType.String, ParameterDirection.Input, obj.Station));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, 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 DataBaseResultSet SaveAddressBook <T>(T objData) where T : class, IModel, new()
{
AddressBook obj = objData as AddressBook;
string sQuery = "sprocAddressBookInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("AddCode", "AddCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.AddCode));
list.Add(SqlConnManager.GetConnParameters("AddName", "AddName", 50, GenericDataType.String, ParameterDirection.Input, obj.AddName));
list.Add(SqlConnManager.GetConnParameters("ContactPerson", "ContactPerson", 50, GenericDataType.String, ParameterDirection.Input, obj.ContactPerson));
list.Add(SqlConnManager.GetConnParameters("Add1", "Add1", 50, GenericDataType.String, ParameterDirection.Input, obj.Add1));
list.Add(SqlConnManager.GetConnParameters("Add2", "Add2", 50, GenericDataType.String, ParameterDirection.Input, obj.Add2));
list.Add(SqlConnManager.GetConnParameters("Add3", "Add3", 50, GenericDataType.String, ParameterDirection.Input, obj.Add3));
list.Add(SqlConnManager.GetConnParameters("CityName", "CityName", 20, GenericDataType.String, ParameterDirection.Input, obj.CityName));
list.Add(SqlConnManager.GetConnParameters("PinCode", "PinCode", 10, GenericDataType.String, ParameterDirection.Input, obj.PinCode));
list.Add(SqlConnManager.GetConnParameters("Phone1", "Phone1", 30, GenericDataType.String, ParameterDirection.Input, obj.Phone1));
list.Add(SqlConnManager.GetConnParameters("Phone2", "Phone2", 30, GenericDataType.String, ParameterDirection.Input, obj.Phone2));
list.Add(SqlConnManager.GetConnParameters("Fax", "Fax", 30, GenericDataType.String, ParameterDirection.Input, obj.Fax));
list.Add(SqlConnManager.GetConnParameters("Email", "Email", 30, GenericDataType.String, ParameterDirection.Input, obj.Email));
list.Add(SqlConnManager.GetConnParameters("Category", "Category", 50, GenericDataType.String, ParameterDirection.Input, obj.Category));
list.Add(SqlConnManager.GetConnParameters("RelWith", "RelWith", 50, GenericDataType.String, ParameterDirection.Input, obj.RelWith));
list.Add(SqlConnManager.GetConnParameters("AddNote", "AddNote", 200, GenericDataType.String, ParameterDirection.Input, obj.AddNote));
list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser));
list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime));
list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser));
list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime));
list.Add(SqlConnManager.GetConnParameters("DLock", "DLock", 3, GenericDataType.String, ParameterDirection.Input, obj.DLock));
list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy));
list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy));
list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT));
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 DataBaseResultSet SaveFirmMaster <T>(T objData) where T : class, IModel, new()
{
FirmMaster obj = objData as FirmMaster;
string sQuery = "sprocFirmMasterInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo));
list.Add(SqlConnManager.GetConnParameters("FirmName", "FirmName", 50, GenericDataType.String, ParameterDirection.Input, obj.FirmName));
list.Add(SqlConnManager.GetConnParameters("Add1", "Add1", 50, GenericDataType.String, ParameterDirection.Input, obj.Add1));
list.Add(SqlConnManager.GetConnParameters("Add2", "Add2", 50, GenericDataType.String, ParameterDirection.Input, obj.Add2));
list.Add(SqlConnManager.GetConnParameters("Add3", "Add3", 50, GenericDataType.String, ParameterDirection.Input, obj.Add3));
list.Add(SqlConnManager.GetConnParameters("Area", "Area", 30, GenericDataType.String, ParameterDirection.Input, obj.Area));
list.Add(SqlConnManager.GetConnParameters("City", "City", 20, GenericDataType.String, ParameterDirection.Input, obj.City));
list.Add(SqlConnManager.GetConnParameters("PinCode", "PinCode", 10, GenericDataType.String, ParameterDirection.Input, obj.PinCode));
list.Add(SqlConnManager.GetConnParameters("KeyPerson", "KeyPerson", 50, GenericDataType.String, ParameterDirection.Input, obj.KeyPerson));
list.Add(SqlConnManager.GetConnParameters("PhoneNo", "PhoneNo", 35, GenericDataType.String, ParameterDirection.Input, obj.PhoneNo));
list.Add(SqlConnManager.GetConnParameters("Email", "Email", 50, GenericDataType.String, ParameterDirection.Input, obj.Email));
list.Add(SqlConnManager.GetConnParameters("VatNo", "VatNo", 20, GenericDataType.String, ParameterDirection.Input, obj.VatNo));
list.Add(SqlConnManager.GetConnParameters("VatDate", "VatDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.VatDate));
list.Add(SqlConnManager.GetConnParameters("CSTVatNo", "CSTVatNo", 20, GenericDataType.String, ParameterDirection.Input, obj.CSTVatNo));
list.Add(SqlConnManager.GetConnParameters("CSTVatDate", "CSTVatDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CSTVatDate));
list.Add(SqlConnManager.GetConnParameters("DlNo1", "DlNo1", 50, GenericDataType.String, ParameterDirection.Input, obj.DlNo1));
list.Add(SqlConnManager.GetConnParameters("DlNo2", "DlNo2", 50, GenericDataType.String, ParameterDirection.Input, obj.DlNo2));
list.Add(SqlConnManager.GetConnParameters("RegKey", "RegKey", 25, GenericDataType.String, ParameterDirection.Input, obj.RegKey));
list.Add(SqlConnManager.GetConnParameters("DataPath", "DataPath", 8, GenericDataType.String, ParameterDirection.Input, obj.DataPath));
list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy));
list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy));
list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT));
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 DataBaseResultSet SaveT_TranJournal <T>(T objData) where T : class, IModel, new()
{
T_TranJournal obj = objData as T_TranJournal;
string sQuery = "sprocT_TranJournalInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("TranJournalId", "TranJournalId", 8, GenericDataType.Long, ParameterDirection.Input, obj.TranJournalId));
list.Add(SqlConnManager.GetConnParameters("JournalNo", "JournalNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.JournalNo));
list.Add(SqlConnManager.GetConnParameters("CompanyId", "CompanyId", 4, GenericDataType.Int, ParameterDirection.Input, obj.CompanyId));
list.Add(SqlConnManager.GetConnParameters("AmountType", "AmountType", 10, GenericDataType.String, ParameterDirection.Input, obj.AmountType));
list.Add(SqlConnManager.GetConnParameters("VoucherDate", "VoucherDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.VoucherDate));
list.Add(SqlConnManager.GetConnParameters("RefNo", "RefNo", 50, GenericDataType.String, ParameterDirection.Input, obj.RefNo));
list.Add(SqlConnManager.GetConnParameters("DebitPartyId", "DebitPartyId", 8, GenericDataType.Long, ParameterDirection.Input, obj.DebitPartyId));
list.Add(SqlConnManager.GetConnParameters("CreditPartyId", "CreditPartyId", 8, GenericDataType.Long, ParameterDirection.Input, obj.CreditPartyId));
list.Add(SqlConnManager.GetConnParameters("DebitNarration", "DebitNarration", 500, GenericDataType.String, ParameterDirection.Input, obj.DebitNarration));
list.Add(SqlConnManager.GetConnParameters("CreditNarration", "CreditNarration", 500, GenericDataType.String, ParameterDirection.Input, obj.CreditNarration));
list.Add(SqlConnManager.GetConnParameters("Amount", "Amount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Amount));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, DateTime.Now));
list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag));
list.Add(SqlConnManager.GetConnParameters("PrimKeyId", "PrimKeyId", 4, GenericDataType.Int, ParameterDirection.Input, obj.PrimKeyTableId));
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 DataBaseResultSet SaveProductMaster <T>(T objData) where T : class, IModel, new()
{
ProductMaster obj = objData as ProductMaster;
string sQuery = "sprocProductMasterInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("ProductCode", "ProductCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.ProductCode));
list.Add(SqlConnManager.GetConnParameters("ICode", "ICode", 50, GenericDataType.String, ParameterDirection.Input, obj.ICode));
list.Add(SqlConnManager.GetConnParameters("ProductName", "ProductName", 50, GenericDataType.String, ParameterDirection.Input, obj.ProductName));
list.Add(SqlConnManager.GetConnParameters("Packing", "Packing", 50, GenericDataType.String, ParameterDirection.Input, obj.Packing));
list.Add(SqlConnManager.GetConnParameters("PackingType", "PackingType", 50, GenericDataType.String, ParameterDirection.Input, obj.PackingType));
list.Add(SqlConnManager.GetConnParameters("ConversionUnit", "ConversionUnit", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.ConversionUnit));
list.Add(SqlConnManager.GetConnParameters("CompanyTag", "CompanyTag", 50, GenericDataType.String, ParameterDirection.Input, obj.CompanyTag));
list.Add(SqlConnManager.GetConnParameters("CompanyCode", "CompanyCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.CompanyCode));
list.Add(SqlConnManager.GetConnParameters("CategoryCode", "CategoryCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.CategoryCode));
list.Add(SqlConnManager.GetConnParameters("GenericCode", "GenericCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.GenericCode));
list.Add(SqlConnManager.GetConnParameters("Rate", "Rate", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Rate));
list.Add(SqlConnManager.GetConnParameters("SplRate", "SplRate", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SplRate));
list.Add(SqlConnManager.GetConnParameters("DiscYN", "DiscYN", 50, GenericDataType.String, ParameterDirection.Input, obj.DiscYN));
list.Add(SqlConnManager.GetConnParameters("Discount", "Discount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Discount));
list.Add(SqlConnManager.GetConnParameters("Inclusive", "Inclusive", 50, GenericDataType.String, ParameterDirection.Input, obj.Inclusive));
list.Add(SqlConnManager.GetConnParameters("VatOn", "VatOn", 50, GenericDataType.String, ParameterDirection.Input, obj.VatOn));
list.Add(SqlConnManager.GetConnParameters("Vat", "Vat", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Vat));
list.Add(SqlConnManager.GetConnParameters("AdVat", "AdVat", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.AdVat));
list.Add(SqlConnManager.GetConnParameters("CST", "CST", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.CST));
list.Add(SqlConnManager.GetConnParameters("BarPrint", "BarPrint", 50, GenericDataType.String, ParameterDirection.Input, obj.BarPrint));
list.Add(SqlConnManager.GetConnParameters("BarCode", "BarCode", 13, GenericDataType.String, ParameterDirection.Input, obj.BarCode));
list.Add(SqlConnManager.GetConnParameters("MinQty", "MinQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.MinQty));
list.Add(SqlConnManager.GetConnParameters("MaxQty", "MaxQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.MaxQty));
list.Add(SqlConnManager.GetConnParameters("ReOrderQty", "ReOrderQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.ReOrderQty));
list.Add(SqlConnManager.GetConnParameters("RackID", "RackID", 50, GenericDataType.String, ParameterDirection.Input, obj.RackID));
list.Add(SqlConnManager.GetConnParameters("TStk", "TStk", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.TStk));
list.Add(SqlConnManager.GetConnParameters("LPurRs", "LPurRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.LPurRs));
list.Add(SqlConnManager.GetConnParameters("ImageName", "ImageName", 50, GenericDataType.String, ParameterDirection.Input, obj.ImageName));
list.Add(SqlConnManager.GetConnParameters("Scheme", "Scheme", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Scheme));
list.Add(SqlConnManager.GetConnParameters("SQty", "SQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SQty));
list.Add(SqlConnManager.GetConnParameters("SFQty", "SFQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SFQty));
list.Add(SqlConnManager.GetConnParameters("NDRX", "NDRX", 3, GenericDataType.String, ParameterDirection.Input, obj.NDRX));
list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser));
list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime));
list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser));
list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime));
list.Add(SqlConnManager.GetConnParameters("LCode", "LCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.LCode));
list.Add(SqlConnManager.GetConnParameters("SaleCatCode", "SaleCatCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.SaleCatCode));
list.Add(SqlConnManager.GetConnParameters("OldProductCode", "OldProductCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.OldProductCode));
list.Add(SqlConnManager.GetConnParameters("DoctorCode", "DoctorCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.DoctorCode));
list.Add(SqlConnManager.GetConnParameters("DLock", "DLock", 3, GenericDataType.String, ParameterDirection.Input, obj.DLock));
list.Add(SqlConnManager.GetConnParameters("SchDrg", "SchDrg", 10, GenericDataType.String, ParameterDirection.Input, obj.SchDrg));
list.Add(SqlConnManager.GetConnParameters("Note1", "Note1", 200, GenericDataType.String, ParameterDirection.Input, obj.Note1));
list.Add(SqlConnManager.GetConnParameters("Fav", "Fav", 3, GenericDataType.String, ParameterDirection.Input, obj.Fav));
list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy));
list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy));
list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT));
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 DataBaseResultSet SaveBatchMaster <T>(T objData) where T : class, IModel, new()
{
BatchMaster obj = objData as BatchMaster;
string sQuery = "sprocBatchMasterInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("BatchCode", "BatchCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.BatchCode));
list.Add(SqlConnManager.GetConnParameters("ICode", "ICode", 13, GenericDataType.String, ParameterDirection.Input, obj.ICode));
list.Add(SqlConnManager.GetConnParameters("ProductCode", "ProductCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.ProductCode));
list.Add(SqlConnManager.GetConnParameters("AccountCode", "AccountCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.AccountCode));
list.Add(SqlConnManager.GetConnParameters("MRP", "MRP", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.MRP));
list.Add(SqlConnManager.GetConnParameters("BatchNo", "BatchNo", 15, GenericDataType.String, ParameterDirection.Input, obj.BatchNo));
list.Add(SqlConnManager.GetConnParameters("Expiry", "Expiry", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.Expiry));
list.Add(SqlConnManager.GetConnParameters("Inclusive", "Inclusive", 3, GenericDataType.String, ParameterDirection.Input, obj.Inclusive));
list.Add(SqlConnManager.GetConnParameters("VatOn", "VatOn", 5, GenericDataType.String, ParameterDirection.Input, obj.VatOn));
list.Add(SqlConnManager.GetConnParameters("Vat", "Vat", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Vat));
list.Add(SqlConnManager.GetConnParameters("AdVat", "AdVat", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.AdVat));
list.Add(SqlConnManager.GetConnParameters("Octroi", "Octroi", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Octroi));
list.Add(SqlConnManager.GetConnParameters("PurRs", "PurRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.PurRs));
list.Add(SqlConnManager.GetConnParameters("SaleRs", "SaleRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SaleRs));
list.Add(SqlConnManager.GetConnParameters("NetRate", "NetRate", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.NetRate));
list.Add(SqlConnManager.GetConnParameters("StockPt", "StockPt", 8, GenericDataType.Long, ParameterDirection.Input, obj.StockPt));
list.Add(SqlConnManager.GetConnParameters("OpQty", "OpQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.OpQty));
list.Add(SqlConnManager.GetConnParameters("OpQtyRs", "OpQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.OpQtyRs));
list.Add(SqlConnManager.GetConnParameters("OpFQty", "OpFQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.OpFQty));
list.Add(SqlConnManager.GetConnParameters("OpFQtyRs", "OpFQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.OpFQtyRs));
list.Add(SqlConnManager.GetConnParameters("PurQty", "PurQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.PurQty));
list.Add(SqlConnManager.GetConnParameters("PurQtyRs", "PurQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.PurQtyRs));
list.Add(SqlConnManager.GetConnParameters("PurFQty", "PurFQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.PurFQty));
list.Add(SqlConnManager.GetConnParameters("PurFQtyRs", "PurFQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.PurFQtyRs));
list.Add(SqlConnManager.GetConnParameters("CrQty", "CrQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.CrQty));
list.Add(SqlConnManager.GetConnParameters("CrQtyRs", "CrQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.CrQtyRs));
list.Add(SqlConnManager.GetConnParameters("CrFQty", "CrFQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.CrFQty));
list.Add(SqlConnManager.GetConnParameters("CrFQtyRs", "CrFQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.CrFQtyRs));
list.Add(SqlConnManager.GetConnParameters("RcptQty", "RcptQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.RcptQty));
list.Add(SqlConnManager.GetConnParameters("RcptQtyRs", "RcptQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.RcptQtyRs));
list.Add(SqlConnManager.GetConnParameters("SaleQty", "SaleQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SaleQty));
list.Add(SqlConnManager.GetConnParameters("SaleQtyRs", "SaleQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SaleQtyRs));
list.Add(SqlConnManager.GetConnParameters("SaleFQty", "SaleFQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SaleFQty));
list.Add(SqlConnManager.GetConnParameters("SaleFQtyRs", "SaleFQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SaleFQtyRs));
list.Add(SqlConnManager.GetConnParameters("IssueQty", "IssueQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.IssueQty));
list.Add(SqlConnManager.GetConnParameters("IssueQtyRs", "IssueQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.IssueQtyRs));
list.Add(SqlConnManager.GetConnParameters("ClQty", "ClQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.ClQty));
list.Add(SqlConnManager.GetConnParameters("ClQtyRs", "ClQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.ClQtyRs));
list.Add(SqlConnManager.GetConnParameters("ClFQty", "ClFQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.ClFQty));
list.Add(SqlConnManager.GetConnParameters("ClFQtyRs", "ClFQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.ClFQtyRs));
list.Add(SqlConnManager.GetConnParameters("TQty", "TQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.TQty));
list.Add(SqlConnManager.GetConnParameters("TQtyRs", "TQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.TQtyRs));
list.Add(SqlConnManager.GetConnParameters("BarSeries", "BarSeries", 2, GenericDataType.String, ParameterDirection.Input, obj.BarSeries));
list.Add(SqlConnManager.GetConnParameters("BarCode", "BarCode", 13, GenericDataType.String, ParameterDirection.Input, obj.BarCode));
list.Add(SqlConnManager.GetConnParameters("BatchHead", "BatchHead", 10, GenericDataType.String, ParameterDirection.Input, obj.BatchHead));
list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser));
list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime));
list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser));
list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime));
list.Add(SqlConnManager.GetConnParameters("DLock", "DLock", 3, GenericDataType.String, ParameterDirection.Input, obj.DLock));
list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy));
list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy));
list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT));
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()));
}
