public int Add(int chequeId, int bankId, string chequeTitle, string chequeAmount, decimal chequeAmountFig, DateTime?chequeDate, string chequeNo, string chequeReceivedBy, string chequeReceiverPhone, string chequeReceiverIDCard, int?chequeCreatedBy, DateTime?chequeCreatedOn, int?chequeStatus)
{
int rt = 0;
srt.Clear();
srt.Add("chequeId", chequeId);
srt.Add("bankId", bankId);
srt.Add("chequeTitle", chequeTitle);
srt.Add("chequeAmount", chequeAmount);
srt.Add("chequeAmountFig", chequeAmountFig);
srt.Add("chequeDate", chequeDate);
srt.Add("chequeNo", chequeNo);
srt.Add("chequeReceivedBy", chequeReceivedBy);
srt.Add("chequeReceiverPhone", chequeReceiverPhone);
srt.Add("chequeReceiverIDCard", chequeReceiverIDCard);
srt.Add("chequeCreatedBy", chequeCreatedBy);
srt.Add("chequeCreatedOn", chequeCreatedOn);
srt.Add("chequeStatus", chequeStatus);
srt.Add("Flg", 1);
IDataReader idr = dbComm.SelectIDR(Communicate.StoredProcedures.ChequePrinting, srt);
if (idr != null)
{
while (idr.Read())
{
rt = Convert.ToInt32(idr[0]);
}
}
return(rt);
}
public IDataReader Select()
{
IDataReader idr = null;
srt.Add("Flg", 4);
idr = dbComm.SelectIDR(Communicate.StoredProcedures.Departments, srt);
return(idr);
}
public IDataReader Select()
{
IDataReader idr = null;
srt.Clear();
srt.Add("Flg", 4);
idr = dbComm.SelectIDR(Communicate.StoredProcedures.AccountCategories, srt);
return idr;
}
public IDataReader Select()
{
IDataReader idr = null;
srt.Add("Flg", 4);
idr = dbComm.SelectIDR(iDB.Communicate.StoredProcedures.AppModules, srt);
return(idr);
}
public IDataReader Select()
{
IDataReader idr = null;
srt.Clear();
srt.Add("Flg", 4);
idr = dbComm.SelectIDR(Communicate.StoredProcedures.UserProfile, srt);
return(idr);
}
public IDataReader Select()
{
srt.Clear();
IDataReader idr = null;
srt.Add("Flg", 4);
idr = dbComm.SelectIDR(Communicate.StoredProcedures.EntityTypes, srt);
return(idr);
}
public int Add(int vendorId, string vendorCode, string vendorURL, string vendorTitle, string vendorDescription, int vendorProductType, string vendorAddressLine1, string vendorAddressLine2, string vendorCity, string vendorZip, string vendorState, string vendorStateShortcode, string vendorCountry, string vendorCountryShortcode, bool vendorIsActive, string vendorEmail, string vendorEmailAlt, string vendorPhone, string vendorPhoneAlt, int vendorMinQty, int vendorMaxQty, string vendorOrderIntimationEmal, string vendorSampleIntimationEmail, string vendorFTP, string vendorFtpUsername, string vendorFtpPassword, bool vendorSendOnFtp, string vendorFirstName, string vendorLastName, int?vendorAccountId, DateTime vendorCreatedOn, int vendorCreatedBy, string vendorCreatedIP)
{
int rt = 0;
srt.Clear();
srt.Add("vendorId", vendorId);
srt.Add("vendorCode", vendorCode);
srt.Add("vendorURL", vendorURL);
srt.Add("vendorTitle", vendorTitle);
srt.Add("vendorDescription", vendorDescription);
srt.Add("vendorProductType", vendorProductType);
srt.Add("vendorAddressLine1", vendorAddressLine1);
srt.Add("vendorAddressLine2", vendorAddressLine2);
srt.Add("vendorCity", vendorCity);
srt.Add("vendorZip", vendorZip);
srt.Add("vendorState", vendorState);
srt.Add("vendorStateShortcode", vendorStateShortcode);
srt.Add("vendorCountry", vendorCountry);
srt.Add("vendorCountryShortcode", vendorCountryShortcode);
srt.Add("vendorIsActive", vendorIsActive);
srt.Add("vendorEmail", vendorEmail);
srt.Add("vendorEmailAlt", vendorEmailAlt);
srt.Add("vendorPhone", vendorPhone);
srt.Add("vendorPhoneAlt", vendorPhoneAlt);
srt.Add("vendorMinQty", vendorMinQty);
srt.Add("vendorMaxQty", vendorMaxQty);
srt.Add("vendorOrderIntimationEmal", vendorOrderIntimationEmal);
srt.Add("vendorSampleIntimationEmail", vendorSampleIntimationEmail);
srt.Add("vendorFTP", vendorFTP);
srt.Add("vendorFtpUsername", vendorFtpUsername);
srt.Add("vendorFtpPassword", vendorFtpPassword);
srt.Add("vendorSendOnFtp", vendorSendOnFtp);
srt.Add("vendorFirstName", vendorFirstName);
srt.Add("vendorLastName", vendorLastName);
srt.Add("vendorAccountId", vendorAccountId);
srt.Add("vendorCreatedOn", vendorCreatedOn);
srt.Add("vendorCreatedBy", vendorCreatedBy);
srt.Add("vendorCreatedIP", vendorCreatedIP);
srt.Add("Flg", 1);
IDataReader idr = dbComm.SelectIDR(Communicate.StoredProcedures.Product_Vendors, srt);
if (idr != null)
{
while (idr.Read())
{
rt = Convert.ToInt32(idr[0]);
}
}
return(rt);
}
public int?Add(int transGroupID, string transGroupTitle, DateTime transGroupCreatedOn, int transGroupCreatedBy, decimal transGroupTotalAmount, decimal?transGroupOfficialTotalAmount, int transTransCount, int?transGroupPrefixNo, string transGroupPrefixString, int?transGroupForeNumber, int transGroupStatus, int?transGroupApprovedBy, DateTime?transGroupApprovedOn, int?transGroupReviewedBy, DateTime?transGroupReviewedOn, int?transLinkedToGroup, int transGroupIsOfficial, string transGroupRefId, string transCField1, string transCField2, string transCField3, string transCField4)
{
int? rt = null;
IDataReader idr = null;
srt.Clear();
srt.Add("transGroupID", transGroupID);
srt.Add("transGroupTitle", transGroupTitle);
srt.Add("transGroupCreatedOn", transGroupCreatedOn);
srt.Add("transGroupCreatedBy", transGroupCreatedBy);
srt.Add("transGroupTotalAmount", transGroupTotalAmount);
srt.Add("transGroupOfficialTotalAmount", transGroupOfficialTotalAmount);
srt.Add("transTransCount", transTransCount);
srt.Add("transGroupPrefixNo", transGroupPrefixNo);
srt.Add("transGroupPrefixString", transGroupPrefixString);
srt.Add("transGroupForeNumber", transGroupForeNumber);
srt.Add("transGroupStatus", transGroupStatus);
srt.Add("transGroupApprovedBy", transGroupApprovedBy);
srt.Add("transGroupApprovedOn", transGroupApprovedOn);
srt.Add("transGroupReviewedBy", transGroupReviewedBy);
srt.Add("transGroupReviewedOn", transGroupReviewedOn);
srt.Add("transLinkedToGroup", transLinkedToGroup);
srt.Add("transGroupIsOfficial", transGroupIsOfficial);
srt.Add("transGroupRefId", transGroupRefId);
srt.Add("transCField1", transCField1);
srt.Add("transCField2", transCField2);
srt.Add("transCField3", transCField3);
srt.Add("transCField4", transCField4);
srt.Add("Flg", 1);
idr = dbComm.SelectIDR(Communicate.StoredProcedures.TransGroups, srt);
if (idr != null)
{
while (idr.Read())
{
rt = Convert.ToInt32(idr[0]);
}
}
return(rt);
}
public int Add(int?transSystemIndex, int?transParticipantID, string transRefID, string transAttachedFiles, int?transInvoiceID, int?transDrAccount, int?transCrAccount, string transNarration, decimal transAmount, DateTime transCreatedOn, int transCreatedBy, DateTime transUpdatedOn, int transUpdatedBy, int transStatus, bool transSystemRestrict, int?transGroupID, bool transIsCompound, int?transType, int?deptId)
{
IDataReader idr = null;
srt.Clear();
//srt.Add("transSystemIndex", transSystemIndex);
srt.Add("transSystemIndex", 2);
srt.Add("transParticipantID", transParticipantID);
srt.Add("transRefID", transRefID);
srt.Add("transAttachedFiles", transAttachedFiles);
srt.Add("transInvoiceID", transInvoiceID);
srt.Add("transDrAccount", transDrAccount);
srt.Add("transCrAccount", transCrAccount);
srt.Add("deptId", deptId);
srt.Add("transNarration", transNarration);
srt.Add("transAmount", transAmount);
srt.Add("transCreatedOn", transCreatedOn);
srt.Add("transCreatedBy", transCreatedBy);
srt.Add("transUpdatedOn", transUpdatedOn);
srt.Add("transUpdatedBy", transUpdatedBy);
srt.Add("transStatus", transStatus);
//srt.Add("transSystemRestrict", transSystemRestrict);
srt.Add("transSystemRestrict", 0);
srt.Add("transGroupID", transGroupID);
srt.Add("transIsCompound", transIsCompound);
srt.Add("transType", transType);
srt.Add("Flg", 1);
idr = dbComm.SelectIDR(Communicate.StoredProcedures.Transactions, srt);
int rt = 0;
if (idr != null)
{
while (idr.Read())
{
rt = Convert.ToInt32(idr[0]);
}
}
return(rt);
}