public void Add(int entityId, int entityType, string entityTitle, string entityDescription, string entityFirstName, string entityLastName, string entityEmail, string entityAltEmail, string entityAddress, string entityCity, string entityZip, int?entityCountry, string entityState, string entityPhone, string entityAltPhone, string entityMobile, string entityAltMobile, string entityFax, string entityAltFax, int entityStatus, int entityAccountId, string entityAccountTitle, DateTime entityCreatedOn, int entityCreatedBy, int entityLastUpdatedBy, DateTime entityLastUpdateOn)
{
srt.Clear();
srt.Add("entityId", entityId);
srt.Add("entityType", entityType);
srt.Add("entityTitle", entityTitle);
srt.Add("entityDescription", entityDescription);
srt.Add("entityFirstName", entityFirstName);
srt.Add("entityLastName", entityLastName);
srt.Add("entityEmail", entityEmail);
srt.Add("entityAltEmail", entityAltEmail);
srt.Add("entityAddress", entityAddress);
srt.Add("entityCity", entityCity);
srt.Add("entityZip", entityZip);
srt.Add("entityCountry", entityCountry);
srt.Add("entityState", entityState);
srt.Add("entityPhone", entityPhone);
srt.Add("entityAltPhone", entityAltPhone);
srt.Add("entityMobile", entityMobile);
srt.Add("entityAltMobile", entityAltMobile);
srt.Add("entityFax", entityFax);
srt.Add("entityAltFax", entityAltFax);
srt.Add("entityStatus", entityStatus);
srt.Add("entityAccountId", entityAccountId);
srt.Add("entityAccountTitle", entityAccountTitle);
srt.Add("entityCreatedOn", entityCreatedOn);
srt.Add("entityCreatedBy", entityCreatedBy);
srt.Add("entityLastUpdatedBy", entityLastUpdatedBy);
srt.Add("entityLastUpdateOn", entityLastUpdateOn);
srt.Add("Flg", 1);
dbComm.Execute(srt, Communicate.StoredProcedures.Entities);
}
public void Update(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)
{
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("Flg", 2);
srt.Add("transGroupIsOfficial", transGroupIsOfficial);
srt.Add("transGroupRefId", transGroupRefId);
srt.Add("transCField1", transCField1);
srt.Add("transCField2", transCField2);
srt.Add("transCField3", transCField3);
srt.Add("transCField4", transCField4);
dbComm.Execute(srt, Communicate.StoredProcedures.TransGroups);
}
public void Add(int entityType, string entityTypeTitle)
{
srt.Clear();
srt.Add("entityType", entityType);
srt.Add("entityTypeTitle", entityTypeTitle);
srt.Add("Flg", 1);
dbComm.Execute(srt, Communicate.StoredProcedures.EntityTypes);
}
public void Add(int accCatID, string accCatTitle, string accCatDescription)
{
srt.Clear();
srt.Add("accCatID", accCatID);
srt.Add("accCatTitle", accCatTitle);
srt.Add("accCatDescription", accCatDescription);
srt.Add("Flg", 1);
dbComm.Execute(srt, Communicate.StoredProcedures.AccountCategories);
}
public void Add(int attachmentId, string attachmentOriginalFileName, string attachmentMaskedFileName, int transGroupID)
{
srt.Clear();
srt.Add("attachmentId", attachmentId);
srt.Add("attachmentOriginalFileName", attachmentOriginalFileName);
srt.Add("attachmentMaskedFileName", attachmentMaskedFileName);
srt.Add("transGroupID", transGroupID);
srt.Add("Flg", 1);
dbComm.Execute(srt, Communicate.StoredProcedures.Attachments);
}
public void Add(int deptId, string deptTitle, string deptCode, string deptDescription)
{
srt.Add("deptId", deptId);
srt.Add("deptTitle", deptTitle);
srt.Add("deptCode", deptCode);
srt.Add("deptDescription", deptDescription);
srt.Add("Flg", 1);
dbComm.Execute(srt, Communicate.StoredProcedures.Departments);
}
public void Add(int finyrID, DateTime startDate, DateTime endDate, bool status)
{
srt.Clear();
srt.Add("finyrID", finyrID);
srt.Add("startDate", startDate);
srt.Add("endDate", endDate);
srt.Add("status", status);
srt.Add("Flg", 1);
dbComm.Execute(srt, Communicate.StoredProcedures.FinYear);
}
public void Add(int userID, string userFirstName, string userMiddleName, string userLastName, string userEmail, bool userIsOfficial, bool userIsActive)
{
srt.Clear();
srt.Add("userID", userID);
srt.Add("userFirstName", userFirstName);
srt.Add("userMiddleName", userMiddleName);
srt.Add("userLastName", userLastName);
srt.Add("userEmail", userEmail);
srt.Add("userIsOfficial", userIsOfficial);
srt.Add("userIsActive", userIsActive);
srt.Add("Flg", 1);
dbComm.Execute(srt, Communicate.StoredProcedures.UserProfile);
}
public void Add(int moduleId, string moduleTitle, string moduleDescription, bool moduleIsOffial, string CField1, string CField2, string CField3, string CField4)
{
srt.Add("moduleId", moduleId);
srt.Add("moduleTitle", moduleTitle);
srt.Add("moduleDescription", moduleDescription);
srt.Add("moduleIsOffial", moduleIsOffial);
srt.Add("CField1", CField1);
srt.Add("CField2", CField2);
srt.Add("CField3", CField3);
srt.Add("CField4", CField4);
srt.Add("Flg", 1);
dbComm.Execute(srt, iDB.Communicate.StoredProcedures.AppModules);
}
public void Add(int taxId, string taxTitle, decimal taxValue, bool taxTypeIsPercent, int taxCreatedBy, DateTime taxCreatedOn, string taxCreatedIP, int taxAccountId, string taxTransNarration)
{
srt.Clear();
srt.Add("taxId", taxId);
srt.Add("taxTitle", taxTitle);
srt.Add("taxValue", taxValue);
srt.Add("taxTypeIsPercent", taxTypeIsPercent);
srt.Add("taxCreatedBy", taxCreatedBy);
srt.Add("taxCreatedOn", taxCreatedOn);
srt.Add("taxCreatedIP", taxCreatedIP);
srt.Add("taxAccountId", taxAccountId);
srt.Add("taxTransNarration", taxTransNarration);
srt.Add("Flg", 1);
dbComm.Execute(srt, Communicate.StoredProcedures.Taxes);
}
private static void StartCommunication(WebSocket socket, IServiceProvider provider)
{
using (socket)
{
Communicate communication = BuildCommunication(socket, provider);
communication.Execute().Wait();
}
}
public void Update(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)
{
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", 2);
dbComm.Execute(srt, Communicate.StoredProcedures.ChequePrinting);
}
public void Update(int transID, 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)
{
srt.Clear();
srt.Add("transID", transID);
srt.Add("transSystemIndex", transSystemIndex);
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("transGroupID", transGroupID);
srt.Add("transIsCompound", transIsCompound);
srt.Add("transType", transType);
srt.Add("Flg", 2);
dbComm.Execute(srt, Communicate.StoredProcedures.Transactions);
}
public void Update(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)
{
srt.Clear();
srt.Add("vendorId", vendorId);
srt.Add("vendorURL", vendorURL);
srt.Add("vendorCode", vendorCode);
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", 2);
dbComm.Execute(srt, Communicate.StoredProcedures.Product_Vendors);
}