private void button2_Click(object sender, EventArgs e)
{
var xxtyy = ((KeyValuePear)cmb_make.SelectedItem).Value;
if (MessageBox.Show("Do you want to add this car and don;t get upset later ?", "Car Management System", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
var xx = cmb_yearmade.SelectedIndex;
var xxy = cmb_yearmade.SelectedValue;
ItemMaster master = new ItemMaster()
{
Id = -1,
BodyTypeId = ((KeyValuePear)cmb_bodyTypes.SelectedItem).Value,
MakeId = ((KeyValuePear)cmb_make.SelectedItem).Value,
ModelId = ((KeyValuePear)cmb_models.SelectedItem).Value,
Milage = ((KeyValuePear)cmb_milage.SelectedItem).Value,
Year = ((KeyValuePear)cmb_yearmade.SelectedItem).Value,
Option = 1,
DisplayName = txt_carName.Text
};
Repository.RepoBase <ItemMaster> db = new RepoBase <ItemMaster>("ItemMasters");
db.SaveNonAsync(master, 1);
MessageBox.Show("Car " + txt_carName.Text + " Added successfully", "Car Management System", MessageBoxButtons.OK, MessageBoxIcon.Information);
backgroundWorker2.RunWorkerAsync();
}
}
/**
* Constructor for Repo (at every launch of CmisSync)
*/
public SynchronizedFolder(RepoInfo repoInfo,
ActivityListener activityListener, CmisRepo repo)
{
this.repo = repo;
this.activityListener = activityListener;
this.repoinfo = repoInfo;
// Database is the user's AppData/Roaming
database = new Database(repoinfo.CmisDatabase);
// Get path on remote repository.
remoteFolderPath = repoInfo.RemotePath;
cmisParameters = new Dictionary <string, string>();
cmisParameters[SessionParameter.BindingType] = BindingType.AtomPub;
cmisParameters[SessionParameter.AtomPubUrl] = repoInfo.Address.ToString();
cmisParameters[SessionParameter.User] = repoInfo.User;
// Unprotect password
cmisParameters[SessionParameter.Password] = Crypto.Unprotect(repoInfo.Password);
cmisParameters[SessionParameter.RepositoryId] = repoInfo.RepoID;
cmisParameters[SessionParameter.ConnectTimeout] = "-1";
syncing = false;
}
public static int PostNaps(NapsObj obj, int postType)
{
//OutPutObj ret = new OutPutObj();
var p = new DynamicParameters();
p.Add("DEBITACCTNO", obj.DEBITACCTNO, DbType.String);
p.Add("DEBITBANKCODE", obj.DEBITBANKCODE, DbType.String);
p.Add("BENEFICIARYACCTNO", obj.BENEFICIARYACCTNO, DbType.String);
p.Add("BENEFICIARYBANKCODE", obj.BENEFICIARYBANKCODE, DbType.String);
p.Add("BENEFICIARYNAME", obj.BENEFICIARYNAME, DbType.String);
p.Add("BENEFICIARYNARRATION", obj.BENEFICIARYNARRATION, DbType.String);
p.Add("CREDITAMOUNT", obj.CREDITAMOUNT, DbType.Decimal);
p.Add("SETTLEMENTDATE", obj.SETTLEMENTDATE, DbType.Date);
p.Add("REASON", obj.REASON, DbType.String);
p.Add("REQUESTTYPE", obj.REQUESTTYPE, DbType.String);
p.Add("USERID", obj.USERID, DbType.String);
p.Add("CREATEDATE", obj.CREATEDATE, DbType.DateTime);
p.Add("BATCHID", obj.BATCHID, DbType.String);
p.Add("PID", obj.PID, DbType.String);
p.Add("POSTTYPE", postType, DbType.String);
p.Add("EVENTTYPE", obj.EVENTTYPE, DbType.String);
p.Add("MERCHANTID", obj.MERCHANTID, DbType.String);
p.Add("PostSequence", null, DbType.Int32);
p.Add("@VALIDATIONERRORMESSAGE", obj.VALIDATIONERRORMESSAGE, DbType.String);
p.Add("@VALIDATIONERRORSTATUS", obj.VALIDATIONERRORSTATUS, DbType.Boolean);
p.Add("@WARNINGMESSAGE", obj.WARNINGMESSAGE, DbType.String);
using (var con = new RepoBase().OpenConnection(null))
{
var rst = con.Execute("SESS_POST_NAPS", p, commandType: CommandType.StoredProcedure);
return(rst);
}
}
public OutPutObj PostMAcct(MerchantAcctObj obj, int postType)
{
OutPutObj ret = new OutPutObj();
var p = new DynamicParameters();
p.Add("PID", obj.PID, DbType.String);
p.Add("DEPOSIT_ACCOUNTNO", obj.DEPOSIT_ACCOUNTNO, DbType.String);
p.Add("MERCHANTID", obj.MERCHANTID, DbType.String);
p.Add("DEPOSIT_ACCTNAME", obj.DEPOSIT_ACCTNAME, DbType.String);
p.Add("DEPOSIT_BANKADDRESS", obj.DEPOSIT_BANKADDRESS, DbType.String);
p.Add("DEPOSIT_BANKCODE", obj.DEPOSIT_BANKCODE, DbType.String);
p.Add("DEPOSIT_BANKNAME", obj.DEPOSIT_BANKNAME, DbType.String);
p.Add("DEPOSIT_COUNTRYCODE", obj.DEPOSIT_COUNTRYCODE, DbType.String);
p.Add("CREATEDATE", obj.CREATEDATE, DbType.DateTime);
p.Add("USERID", obj.USERID, DbType.String);
p.Add("SETTLEMENTCURRENCY", obj.SETTLEMENTCURRENCY, DbType.String);
p.Add("DB_ITBID", obj.DB_ITBID, DbType.Decimal);
p.Add("EVENTTYPE", obj.EVENTTYPE, DbType.String);
p.Add("POSTTYPE", postType, DbType.Int16);
p.Add("DEFAULT_ACCOUNT", obj.DEFAULT_ACCOUNT, DbType.Boolean);
using (var con = new RepoBase().OpenConnection(null))
{
ret = con.Query <OutPutObj>("SESS_POST_MERCHANTACCT", p, commandType: CommandType.StoredProcedure).FirstOrDefault();
return(ret);
}
}
public int PostRvHeadUpload(RvHeadUpldObj obj, int postType, string userId)
{
//OutPutObj ret = new OutPutObj();
var p = new DynamicParameters();
p.Add("@ID", obj.PID, DbType.String);
p.Add("@RVCODE", obj.RVCODE, DbType.String);
p.Add("@GROUPCODE", obj.GROUPCODE, DbType.String);
p.Add("@DESCRIPTION", obj.DESCRIPTION, DbType.String);
p.Add("@CREATEDATE", DateTime.Now, DbType.DateTime);
p.Add("@USERID", userId, DbType.String);
p.Add("@STATUS", obj.STATUS, DbType.String);
p.Add("@PAYMENTITEMID", obj.PAYMENTITEMID, DbType.Int32);
p.Add("@BANKCODE", obj.BANKCODE, DbType.String);
p.Add("@BANKACCOUNT", obj.BANKACCOUNT, DbType.String);
p.Add("@SETTLEMENT_FREQUENCY", obj.SETTLEMENT_FREQUENCY, DbType.Int32);
p.Add("@POSTTYPE", 2, DbType.Int16);
p.Add("@VALIDATIONERRORMESSAGE", obj.VALIDATIONERRORMESSAGE, DbType.String);
p.Add("@VALIDATIONERRORSTATUS", obj.VALIDATIONERRORSTATUS, DbType.String);
p.Add("@WARNINGMESSAGE", obj.WARNINGMESSAGE, DbType.String);
p.Add("@PostSequence", obj.POSTSEQUENCE, DbType.Int32);
p.Add("@ACCOUNT_ID", obj.ACCOUNT_ID, DbType.Decimal);
using (var con = new RepoBase().OpenConnection(null))
{
var rst = con.Execute("SESS_POST_RVHEADUPLD", p, commandType: CommandType.StoredProcedure);
return(rst);
}
}
/// <summary>
/// Constructor for Repo (at every launch of CmisSync)
/// </summary>
public SynchronizedFolder(RepoInfo repoInfo,
IActivityListener listener, RepoBase repoCmis)
{
if (null == repoInfo || null == repoCmis)
{
throw new ArgumentNullException("repoInfo");
}
this.repo = repoCmis;
this.activityListener = listener;
this.repoinfo = repoInfo;
// Database is the user's AppData/Roaming
database = new Database(repoinfo.CmisDatabase);
// Get path on remote repository.
remoteFolderPath = repoInfo.RemotePath;
cmisParameters = new Dictionary <string, string>();
cmisParameters[SessionParameter.BindingType] = BindingType.AtomPub;
cmisParameters[SessionParameter.AtomPubUrl] = repoInfo.Address.ToString();
cmisParameters[SessionParameter.User] = repoInfo.User;
cmisParameters[SessionParameter.Password] = Crypto.Deobfuscate(repoInfo.Password); // Deobfuscate password.
cmisParameters[SessionParameter.RepositoryId] = repoInfo.RepoID;
cmisParameters[SessionParameter.ConnectTimeout] = "-1";
foreach (string ignoredFolder in repoInfo.getIgnoredPaths())
{
Logger.Info("The folder \"" + ignoredFolder + "\" will be ignored");
}
}
public int PostBinUpload(DataBinUpldObj obj, int postType, string userId)
{
//OutPutObj ret = new OutPutObj();
var p = new DynamicParameters();
p.Add("@PID", obj.PID, DbType.String);
p.Add("@BANKFIID", obj.BANKFIID, DbType.String);
p.Add("@BIN", obj.BIN, DbType.String);
p.Add("@BUSINESSTYPE", obj.BUSINESSTYPE, DbType.String);
p.Add("@CARDSCHEME", obj.CARDSCHEME, DbType.String);
p.Add("@CBNCODE", obj.CBNCODE, DbType.String);
p.Add("@COUNTRYCODE", obj.COUNTRYCODE, DbType.String);
p.Add("@CURRENCYCODE", obj.CURRENCYCODE, DbType.String);
p.Add("@ISSUERFIID", obj.ISSUERFIID, DbType.String);
p.Add("@BATCHID", null, DbType.String);
p.Add("USERID", userId, DbType.String);
p.Add("@CREATEDATE", DateTime.Now, DbType.DateTime);
p.Add("@VALIDATIONERRORMESSAGE", obj.VALIDATIONERRORMESSAGE, DbType.String);
p.Add("@VALIDATIONERRORSTATUS", obj.VALIDATIONERRORSTATUS, DbType.String);
p.Add("@WARNINGMESSAGE", obj.WARNINGMESSAGE, DbType.String);
p.Add("POSTTYPE", postType, DbType.Int16);
p.Add("POSTSEQUENCE", obj.POSTSEQUENCE, DbType.Int32);
using (var con = new RepoBase().OpenConnection(null))
{
var rst = con.Execute("SESS_POST_DATABINUPLD", p, commandType: CommandType.StoredProcedure);
return(rst);
}
}
public int PostSetReconUpload(SetReconUpldObj obj, int postType, string userId)
{
//OutPutObj ret = new OutPutObj();
var p = new DynamicParameters();
p.Add("@PID", obj.PID, DbType.String);
p.Add("@PAYREFNO", obj.PAYREFNO, DbType.String);
p.Add("@AMOUNT", obj.AMOUNT, DbType.Decimal);
p.Add("@PAYMENTDATE", obj.PAYMENTDATE, DbType.DateTime);
p.Add("@VALUEDATE", obj.VALUEDATE, DbType.DateTime);
//p.Add("@RECEIPTNO", obj.RECEIPTNO, DbType.String);
p.Add("@CUSTOMERNAME", obj.CUSTOMERNAME, DbType.String);
p.Add("@PAYMENTMETHOD", obj.PAYMENTMETHOD, DbType.String);
//p.Add("@TRANSACTIONSTATUS", obj.TRANSACTIONSTATUS, DbType.String);
//p.Add("@DEPOSITSLIPNO", obj.DEPOSITSLIPNO, DbType.String);
p.Add("@BANKNAME", obj.BANKNAME, DbType.String);
//p.Add("@BRANCHNAME", obj.BRANCHNAME, DbType.String);
//p.Add("@PAYERID", obj.PAYERID, DbType.String);
//p.Add("@VALUEGRANTED", obj.VALUEGRANTED, DbType.String);
// p.Add("@RECONCILE", obj.RECONCILE, DbType.Int32);
p.Add("@BATCHID", null, DbType.String);
p.Add("USERID", userId, DbType.String);
p.Add("@CREATEDATE", DateTime.Now, DbType.DateTime);
p.Add("@VALIDATIONERRORMESSAGE", obj.VALIDATIONERRORMESSAGE, DbType.String);
p.Add("@VALIDATIONERRORSTATUS", obj.VALIDATIONERRORSTATUS, DbType.String);
p.Add("@WARNINGMESSAGE", obj.WARNINGMESSAGE, DbType.String);
p.Add("POSTTYPE", postType, DbType.Int16);
p.Add("POSTSEQUENCE", obj.POSTSEQUENCE, DbType.Int32);
using (var con = new RepoBase().OpenConnection(null))
{
var rst = con.Execute("SESS_POST_SETRECON", p, commandType: CommandType.StoredProcedure);
return(rst);
}
}
public void LoadPageDataFromDb(string rootPath, string site, string pageName, Template template)
{
this.template = template.template;
int sequence = 0;
foreach (var region in template.regions)
{
region.sequence = sequence;
this.regions.Add(region);
sequence++;
}
RepoBase repo = RepoBase.RepoFactory(site, context, rootPath);
if (repo == null)
{
throw new Exception("Repo not defined");
}
foreach (var region in regions)
{
switch (region.regionType)
{
case RegionType.Gallery:
var galleryRegion = repo.GetGalleryFromDb(region, pageName, rootPath);
galleryRegions.Add(galleryRegion);
break;
case RegionType.Html:
var htmlRegion = repo.GetHtmlFromDb(region, pageName);
htmlRegions.Add(htmlRegion);
break;
}
}
}
private static bool TidExistDb(string tid)
{
using (var con = new RepoBase().OpenConnection(null))
{
var p = new DynamicParameters();
// p.Add(":P_INSTITUTION_ITBID", inst_itbid, OracleDbType.Int32);
p.Add("@P_GEN_TID", tid, DbType.String);
// p.Add(":CURSOR_", dbType: OracleDbType.RefCursor, direction: ParameterDirection.Output);
string qry = "SELECT FUNC_TID_EXIST(:P_GEN_TID) RespCode FROM DUAL"; //@"GET_MID_ACCT";
var rec = con.Query <OutPutObj>(qry, p, commandType: CommandType.Text).FirstOrDefault();
if (rec != null)
{
if (rec.RespCode == 0)
{
// mid does not exist before
return(false);
}
else
{
return(true);
}
}
}
return(true);
}
/// <summary>
/// Remove a synchronized folder from the CmisSync configuration.
/// This happens after the user removes the folder.
/// </summary>
/// <param name="folder">The synchronized folder to remove</param>
private void RemoveRepository(Config.SyncConfig.Folder folder)
{
if (this.repositories.Count > 0)
{
for (int i = 0; i < this.repositories.Count; i++)
{
RepoBase repo = this.repositories[i];
if (repo.LocalPath.Equals(folder.LocalPath))
{
repo.CancelSync();
repo.Dispose();
this.repositories.Remove(repo);
Logger.Info("Removed Repository: " + repo.Name);
repo = null;
break;
}
}
}
// Remove Cmis Database File
string dbfilename = folder.DisplayName;
dbfilename = dbfilename.Replace("\\", "_");
dbfilename = dbfilename.Replace("/", "_");
RemoveDatabase(dbfilename);
}
public OutPutObj PostSharingParty(SharingPartyObj obj, int postType)
{
OutPutObj ret = new OutPutObj();
var p = new DynamicParameters();
p.Add("PID", obj.PID, DbType.String);
p.Add("BILLER_CODE", obj.BILLER_CODE, DbType.String);
p.Add("PARTYITBID", obj.PARTYITBID, DbType.Int32);
p.Add("BILLERMSC_ITBID", obj.BILLERMSC_ITBID, DbType.Decimal);
p.Add("PARTY_LOCATOR", obj.PARTY_LOCATOR, DbType.String);
p.Add("SHARINGVALUE", obj.SHARINGVALUE, DbType.Decimal);
p.Add("CAP", obj.CAP, DbType.Decimal);
p.Add("ACCOUNT_ID", obj.ACCOUNT_ID, DbType.Decimal);
p.Add("CREATEDATE", obj.CREATEDATE, DbType.DateTime);
p.Add("USERID", obj.USERID, DbType.String);
p.Add("PARTYTYPE_CODE", obj.PARTYTYPE_CODE, DbType.String);
p.Add("DB_ITBID", obj.DB_ITBID, DbType.Decimal);
p.Add("EVENTTYPE", obj.EVENTTYPE, DbType.String);
p.Add("POSTTYPE", postType, DbType.Int16);
using (var con = new RepoBase().OpenConnection(null))
{
ret = con.Query <OutPutObj>("SESS_POST_SHARINGPARTY", p, commandType: CommandType.StoredProcedure).FirstOrDefault();
return(ret);
}
}
public List <SM_SETTLEMENTDETAIL> GetSettlementEnquiryObj(SettlementEnquiryObj obj)
{
// OutPutObj ret = new OutPutObj();
var p = new DynamicParameters();
p.Add("P_FROMDATE", obj.fromDate, DbType.DateTime);
p.Add("P_TODATE", obj.toDate, DbType.DateTime);
p.Add("@P_SETTDATE", obj.settDate, DbType.DateTime);
p.Add("PAYREF", obj.payRef, DbType.String);
p.Add("REFNO", obj.tranRef, DbType.String);
p.Add("TRANSID", obj.tranID, DbType.Decimal);
p.Add("MERCHANTDEPOSITBANK", obj.crBank, DbType.String);
p.Add("DEBITBANK", obj.drBank, DbType.String);
p.Add("MERCHANTID", obj.merchantID, DbType.String);
p.Add("MERCHANTNAME", obj.merchantName, DbType.String);
p.Add("CARDSCHEME", obj.cardScheme, DbType.String);
p.Add("TRANAMOUNT", obj.tranAmt, DbType.Decimal);
p.Add("ACQUIRERFIID", obj.acquirer, DbType.String);
p.Add("ISSUERFIID", obj.issuer, DbType.String);
p.Add("SETTLEMENTACCOUNT", obj.settAcct, DbType.String);
p.Add("CHANNELID", obj.channel, DbType.Int32);
p.Add("MASKPAN", obj.maskpan, DbType.String);
p.Add("TERMINALID", obj.termID, DbType.String);
p.Add("LOCATION", obj.mlocation, DbType.String);
p.Add("INVOICENO", obj.invoiceNo, DbType.String);
using (var con = new RepoBase().OpenConnection(null))
{
var ret = con.Query <SM_SETTLEMENTDETAIL>("PROC_SETTLEMENTENQUIRY", p, commandType: CommandType.StoredProcedure).ToList();
return(ret);
}
}
public int PostRvDrAcctUpload(RvDrAcctUpldObj obj, int postType, string userId)
{
//OutPutObj ret = new OutPutObj();
var p = new DynamicParameters();
p.Add("@PID", obj.PID, DbType.String);
p.Add("@GROUPCODE", obj.RVGROUPCODE, DbType.String);
p.Add("@MERCHANTID", obj.MERCHANTID, DbType.String);
p.Add("@AGENTCODE", obj.AGENT_CODE, DbType.String);
p.Add("@BANKACCTNAME", obj.BANKACCTNAME, DbType.String);
p.Add("@BANKACCTNO", obj.BANKACCTNO, DbType.String);
p.Add("@BANKCODE", obj.BANKCODE, DbType.String);
p.Add("USERID", userId, DbType.String);
p.Add("STATUS", obj.STATUS, DbType.String);
p.Add("@CREATEDATE", DateTime.Now, DbType.DateTime);
p.Add("@VALIDATIONERRORMESSAGE", obj.VALIDATIONERRORMESSAGE, DbType.String);
p.Add("@VALIDATIONERRORSTATUS", obj.VALIDATIONERRORSTATUS, DbType.String);
p.Add("@WARNINGMESSAGE", obj.WARNINGMESSAGE, DbType.String);
p.Add("POSTTYPE", 2, DbType.Int16);
p.Add("PostSequence", obj.POSTSEQUENCE, DbType.Int32);
using (var con = new RepoBase().OpenConnection(null))
{
var rst = con.Execute("SESS_POST_RVDRACCTUPLD", p, commandType: CommandType.StoredProcedure);
return(rst);
}
}
/// <summary>
/// Initialize (in the GUI and syncing mechanism) an existing CmisSync synchronized folder.
/// </summary>
/// <param name="repositoryInfo">Synchronized folder path</param>
private void AddRepository(RepoInfo repositoryInfo)
{
RepoBase repo = null;
repo = new CmisSync.Lib.Sync.CmisRepo(repositoryInfo, activityListenerAggregator);
this.repositories.Add(repo);
repo.Initialize();
}
/// <summary>
/// Initialize (in the UI and syncing mechanism) an existing CmisSync synchronized folder.
/// </summary>
/// <param name="repositoryInfo">Synchronized folder path</param>
/// <param name="perpetual">Whether to perpetually sync again and again at regular intervals. False means syncing just once then stopping.</param>
private void AddRepository(RepoInfo repositoryInfo, bool perpetual)
{
RepoBase repo = null;
repo = new CmisSync.Lib.Sync.CmisRepo(repositoryInfo, activityListenerAggregator, true, perpetual);
this.repositories.Add(repo);
repo.SyncAtStartupIfConfiguredToDoSo();
}
/// <summary>
/// Constructor for Repo (at every launch of CmisSync)
/// </summary>
public SynchronizedFolder(RepoInfo repoInfo, RepoBase repoCmis)
{
if (null == repoInfo || null == repoCmis)
{
throw new ArgumentNullException("repoInfo");
}
this.repo = repoCmis;
this.repoinfo = repoInfo;
// Database is the user's AppData/Roaming
database = new Database(repoinfo.CmisDatabase);
// Get path on remote repository.
remoteFolderPath = repoInfo.RemotePath;
cmisParameters = new Dictionary <string, string>();
cmisParameters[SessionParameter.BindingType] = BindingType.AtomPub;
cmisParameters[SessionParameter.AtomPubUrl] = repoInfo.Address.ToString();
cmisParameters[SessionParameter.User] = repoInfo.User;
cmisParameters[SessionParameter.Password] = repoInfo.Password.ToString();
cmisParameters[SessionParameter.RepositoryId] = repoInfo.RepoID;
cmisParameters[SessionParameter.ConnectTimeout] = "-1";
foreach (string ignoredFolder in repoInfo.getIgnoredPaths())
{
Logger.Info("The folder \"" + ignoredFolder + "\" will be ignored");
}
syncWorker = new BackgroundWorker();
syncWorker.WorkerSupportsCancellation = true;
syncWorker.DoWork += new DoWorkEventHandler(
delegate(Object o, DoWorkEventArgs args)
{
bool syncFull = (bool)args.Argument;
try
{
Sync(syncFull);
}
catch (OperationCanceledException e)
{
Logger.Info(e.Message);
}
catch (CmisPermissionDeniedException e)
{
repo.OnSyncError(new PermissionDeniedException("Authentication failed.", e));
}
catch (Exception e)
{
repo.OnSyncError(new BaseException(e));
}
finally
{
SyncComplete(syncFull);
}
}
);
}
public int PostMerchantUpload(MerchantUpldObj obj, int postType, string userId)
{
//OutPutObj ret = new OutPutObj();
var p = new DynamicParameters();
p.Add("@PID", obj.PID, DbType.String);
p.Add("@MERCHANTID", obj.MERCHANTID, DbType.String);
p.Add("@MERCHANTNAME", obj.MERCHANTNAME, DbType.String);
p.Add("@CONTACTTITLE", obj.CONTACTTITLE, DbType.String);
p.Add("@CONTACTNAME", obj.CONTACTNAME, DbType.String);
p.Add("@MOBILEPHONE", obj.MOBILEPHONE, DbType.String);
p.Add("@EMAIL", obj.EMAIL, DbType.String);
p.Add("@EMAILALERTS", obj.EMAILALERTS, DbType.String);
p.Add("@PHYSICALADDR", obj.PHYSICALADDR, DbType.String);
p.Add("@TERMINALMODELCODE", obj.TERMINALMODELCODE, DbType.String);
p.Add("@TERMINALID", obj.TERMINALID, DbType.String);
p.Add("@BANKCODE", obj.BANKCODE, DbType.String);
p.Add("@BANKACCNO", obj.BANKACCNO, DbType.String);
p.Add("@BANKTYPE", obj.BANKTYPE, DbType.Int32);
p.Add("@SLIPHEADER", obj.SLIPHEADER, DbType.String);
p.Add("@SLIPFOOTER", obj.SLIPFOOTER, DbType.String);
p.Add("@BUISNESSOCCUPATIONCODE", obj.BUISNESSOCCUPATIONCODE, DbType.String);
p.Add("@MERCHANTCATEGORYCODE", obj.MERCHANTCATEGORYCODE, DbType.String);
p.Add("@STATECODE", obj.STATECODE, DbType.String);
p.Add("@VISAACQUIRERID", obj.VISAACQUIRERID, DbType.String);
p.Add("@VERVEACQUIRERID", obj.VERVEACQUIRERID, DbType.String);
p.Add("@MASTERCARDACQUIRERID", obj.MASTERCARDACQUIRERID, DbType.String);
p.Add("@TERMINALOWNERCODE", obj.TERMINALOWNERCODE, DbType.String);
p.Add("@LGA_LCDA", obj.LGA_LCDA, DbType.String);
p.Add("@BANK_URL", obj.BANK_URL, DbType.String);
p.Add("@ACCOUNTNAME", obj.ACCOUNTNAME, DbType.String);
p.Add("@PTSP", obj.PTSP, DbType.String);
p.Add("@BATCHID", null, DbType.String);
p.Add("@USERID", userId, DbType.String);
p.Add("@CREATEDATE", DateTime.Now, DbType.DateTime);
p.Add("@INTERFACE_FORMAT", null, DbType.String);
p.Add("@SERVICETYPE", null, DbType.String);
p.Add("@GROUPLABEL", null, DbType.Int32);
p.Add("@ROWCOLOR", null, DbType.String);
p.Add("@PAYATTITUDE_ACCEPTANCE", null, DbType.String);
p.Add("@TRANSCURRENCY", obj.TRANSCURRENCY, DbType.String);
p.Add("@PTSA", obj.PTSA, DbType.String);
p.Add("@VALIDATIONERRORMESSAGE", obj.VALIDATIONERRORMESSAGE, DbType.String);
p.Add("@VALIDATIONERRORSTATUS", obj.VALIDATIONERRORSTATUS, DbType.String);
p.Add("@WARNINGMESSAGE", obj.WARNINGMESSAGE, DbType.String);
p.Add("POSTTYPE", postType, DbType.Int16);
using (var con = new RepoBase().OpenConnection(null))
{
var rst = con.Execute("SESS_POST_MERCHANTUPLD", p, commandType: CommandType.StoredProcedure);
return(rst);
}
}
//public OutPutObj PostRevenueHeadBulk(List<RvHeadObj> objList)
//{
// OutPutObj ret = new OutPutObj();
// var p = new DynamicParameters();
// using (var con = new RepoBase().OpenConnection(null))
// {
// foreach (var obj in objList)
// {
// ret = con.Query<OutPutObj>("POST_REVENUEHEAD_SESSION", p, commandType: CommandType.StoredProcedure).FirstOrDefault();
// }
// return ret;
// }
//}
public List <SharingPartyObj> GetSharingParty(string userId)
{
// OutPutObj ret = new OutPutObj();
var p = new DynamicParameters();
p.Add("USERID", userId, DbType.String);
using (var con = new RepoBase().OpenConnection(null))
{
var ret = con.Query <SharingPartyObj>("SESS_GET_SHARINGPARTY", p, commandType: CommandType.StoredProcedure).ToList();
return(ret);
}
}
public async Task <IEnumerable <Level2> > GetSubcategoryForSideMenu(int CategoryId)
{
try
{
RepoBase <Level2> repo = new RepoBase <Level2>("Level1");
return(await repo.FindExistanceMulti("Level1Id", CategoryId.ToString()));
}
catch (Exception ex)
{
throw ex;
}
}
public List <DataBinUpldObj> GetDataBinUpload(string userId)
{
// OutPutObj ret = new OutPutObj();
var p = new DynamicParameters();
p.Add("USERID", userId, DbType.String);
using (var con = new RepoBase().OpenConnection(null))
{
var ret = con.Query <DataBinUpldObj>("SESS_GET_DATABINUPLD", p, commandType: CommandType.StoredProcedure).ToList();
return(ret);
}
}
public int PurgeRouteOfficer(string userId)
{
//OutPutObj ret = new OutPutObj();
var p = new DynamicParameters();
p.Add("USERID", userId, DbType.String);
using (var con = new RepoBase().OpenConnection(null))
{
var ret = con.Execute("SESS_PURGE_APPROVALOFFICER", p, commandType: CommandType.StoredProcedure);
return(ret);
}
}
//public int DeleteDataBinUpload(string Id,string userId)
//{
// //OutPutObj ret = new OutPutObj();
// var p = new DynamicParameters();
// p.Add("USERID", userId, DbType.String);
// p.Add("ID", Id, DbType.String);
// using (var con = new RepoBase().OpenConnection(null))
// {
// var ret = con.Execute("DELETE_REVENUEHEAD_SESSION", p, commandType: CommandType.StoredProcedure);
// return ret;
// }
//}
//public RvHeadObj FindRevenueHead(string Id, string userId)
//{
// //OutPutObj ret = new OutPutObj();
// var p = new DynamicParameters();
// p.Add("USERID", userId, DbType.String);
// p.Add("ID", Id, DbType.String);
// using (var con = new RepoBase().OpenConnection(null))
// {
// var ret = con.Query<RvHeadObj>("FIND_REVENUEHEAD_SESSION", p, commandType: CommandType.StoredProcedure).FirstOrDefault();
// return ret;
// }
//}
public int PurgeDataBinUpload(string userId)
{
//OutPutObj ret = new OutPutObj();
var p = new DynamicParameters();
p.Add("USERID", userId, DbType.String);
using (var con = new RepoBase().OpenConnection(null))
{
var ret = con.Execute("SESS_PURGE_DATABINUPLD", p, commandType: CommandType.StoredProcedure);
return(ret);
}
}
public int PurgeMerchantAcct(string userId)
{
//OutPutObj ret = new OutPutObj();
var p = new DynamicParameters();
p.Add("USERID", userId, DbType.String);
using (var con = new RepoBase().OpenConnection(null))
{
var ret = con.Execute("SESS_PURGE_MERCHANTACCT", p, commandType: CommandType.StoredProcedure);
return(ret);
}
}
public async Task <IEnumerable <SpecProductDetails> > GetAllSpecProductDetails(int ProductId)
{
try
{
var repo = new RepoBase <SpecProductDetails>("SpecProductDetails");
return(await repo.FindExistanceMulti("SpecMasterId", ProductId.ToString()));
}
catch (Exception ex)
{
throw ex;
}
}
//public OutPutObj PostRevenueHeadBulk(List<RvHeadObj> objList)
//{
// OutPutObj ret = new OutPutObj();
// var p = new DynamicParameters();
// using (var con = new RepoBase().OpenConnection(null))
// {
// foreach (var obj in objList)
// {
// ret = con.Query<OutPutObj>("POST_REVENUEHEAD_SESSION", p, commandType: CommandType.StoredProcedure).FirstOrDefault();
// }
// return ret;
// }
//}
public List <MerchantAcctObj> GetMerchantAcct(string userId)
{
// OutPutObj ret = new OutPutObj();
var p = new DynamicParameters();
p.Add("USERID", userId, DbType.String);
using (var con = new RepoBase().OpenConnection(null))
{
var ret = con.Query <MerchantAcctObj>("SESS_GET_MERCHANTACCT", p, commandType: CommandType.StoredProcedure).ToList();
return(ret);
}
}
public async Task <IEnumerable <SpecDetail> > GetAllSpecDetailsForMAster(int MasterId)
{
try
{
var repo = new RepoBase <SpecDetail>("SpecItems");
return(await repo.FindExistanceMulti("SpecMasterId", MasterId.ToString()));
}
catch (Exception ex)
{
throw ex;
}
}
//public OutPutObj PostRevenueHeadBulk(List<RvHeadObj> objList)
//{
// OutPutObj ret = new OutPutObj();
// var p = new DynamicParameters();
// using (var con = new RepoBase().OpenConnection(null))
// {
// foreach (var obj in objList)
// {
// ret = con.Query<OutPutObj>("POST_REVENUEHEAD_SESSION", p, commandType: CommandType.StoredProcedure).FirstOrDefault();
// }
// return ret;
// }
//}
public List <RvHeadObj> GetRevenueHead(string userId)
{
// OutPutObj ret = new OutPutObj();
var p = new DynamicParameters();
p.Add("USERID", userId, DbType.String);
using (var con = new RepoBase().OpenConnection(null))
{
var ret = con.Query <RvHeadObj>("GET_SM_REVENUEHEAD_SESSION", p, commandType: CommandType.StoredProcedure).ToList();
return(ret);
}
}
public async Task <IEnumerable <SpecItem> > GetAllSpecItems()
{
try
{
var repo = new RepoBase <SpecItem>("SpecItems");
return(await repo.FindALL());
}
catch (Exception ex)
{
throw ex;
}
}
public int PurgeRevenueHead(string userId)
{
//OutPutObj ret = new OutPutObj();
var p = new DynamicParameters();
p.Add("USERID", userId, DbType.String);
using (var con = new RepoBase().OpenConnection(null))
{
var ret = con.Execute("PURGE_REVENUEHEAD_SESSION", p, commandType: CommandType.StoredProcedure);
return(ret);
}
}
/// <summary>
/// Constructor for Repo (at every launch of CmisSync)
/// </summary>
public SynchronizedFolder(RepoInfo repoInfo,
IActivityListener listener, RepoBase repoCmis)
{
if (null == repoInfo || null == repoCmis)
{
throw new ArgumentNullException("repoInfo");
}
this.repo = repoCmis;
this.activityListener = listener;
this.repoinfo = repoInfo;
// Database is the user's AppData/Roaming
database = new Database(repoinfo.CmisDatabase);
// Get path on remote repository.
remoteFolderPath = repoInfo.RemotePath;
cmisParameters = new Dictionary<string, string>();
cmisParameters[SessionParameter.BindingType] = BindingType.AtomPub;
cmisParameters[SessionParameter.AtomPubUrl] = repoInfo.Address.ToString();
cmisParameters[SessionParameter.User] = repoInfo.User;
cmisParameters[SessionParameter.Password] = Crypto.Deobfuscate(repoInfo.Password); // Deobfuscate password.
cmisParameters[SessionParameter.RepositoryId] = repoInfo.RepoID;
cmisParameters[SessionParameter.ConnectTimeout] = "-1";
foreach (string ignoredFolder in repoInfo.getIgnoredPaths())
{
Logger.Info("The folder \""+ignoredFolder+"\" will be ignored");
}
}
public BinaryFileRepo(IFileLocator fileLocator, RepoBase repoToClone)
: base(fileLocator, repoToClone.GetRawList())
{
}
/// <summary>
/// Constructor for Repo (at every launch of CmisSync)
/// </summary>
public SynchronizedFolder(RepoInfo repoInfo, RepoBase repoCmis, IActivityListener activityListener)
{
this.activityListener = activityListener;
if (null == repoInfo || null == repoCmis)
{
throw new ArgumentNullException("repoInfo");
}
this.repo = repoCmis;
this.repoinfo = repoInfo;
suspended = this.repoinfo.IsSuspended;
// Database is the user's AppData/Roaming
database = new Database.Database(repoinfo.CmisDatabase);
// Get path on remote repository.
remoteFolderPath = repoInfo.RemotePath;
if (Logger.IsInfoEnabled)
{
foreach (string ignoredFolder in repoInfo.getIgnoredPaths())
{
Logger.Info("The folder \"" + ignoredFolder + "\" will be ignored");
}
}
syncWorker = new BackgroundWorker();
syncWorker.WorkerSupportsCancellation = true;
syncWorker.DoWork += new DoWorkEventHandler(
delegate(Object o, DoWorkEventArgs args)
{
bool syncFull = (bool)args.Argument;
try
{
Sync(syncFull);
}
catch (OperationCanceledException e)
{
Logger.Info(e.Message);
}
catch (CmisPermissionDeniedException e)
{
repo.OnSyncError(new PermissionDeniedException("Authentication failed.", e));
}
catch (CmisMissingSyncFolderException e)
{
repo.OnSyncError(new MissingSyncFolderException("Missing sync folder.", e));
}
catch (Exception e)
{
repo.OnSyncError(new BaseException(e));
}
finally
{
SyncComplete(syncFull);
}
}
);
}
/// <summary>
/// Constructor for Repo (at every launch of CmisSync)
/// </summary>
public SynchronizedFolder(RepoInfo repoInfo, RepoBase repoCmis)
{
if (null == repoInfo || null == repoCmis)
{
throw new ArgumentNullException("repoInfo");
}
this.repo = repoCmis;
this.repoinfo = repoInfo;
// Database is the user's AppData/Roaming
database = new Database(repoinfo.CmisDatabase);
// Get path on remote repository.
remoteFolderPath = repoInfo.RemotePath;
cmisParameters = new Dictionary<string, string>();
cmisParameters[SessionParameter.BindingType] = BindingType.AtomPub;
cmisParameters[SessionParameter.AtomPubUrl] = repoInfo.Address.ToString();
cmisParameters[SessionParameter.User] = repoInfo.User;
cmisParameters[SessionParameter.Password] = repoInfo.Password.ToString();
cmisParameters[SessionParameter.RepositoryId] = repoInfo.RepoID;
cmisParameters[SessionParameter.ConnectTimeout] = "-1";
foreach (string ignoredFolder in repoInfo.getIgnoredPaths())
{
Logger.Info("The folder \"" + ignoredFolder + "\" will be ignored");
}
syncWorker = new BackgroundWorker();
syncWorker.WorkerSupportsCancellation = true;
syncWorker.DoWork += new DoWorkEventHandler(
delegate(Object o, DoWorkEventArgs args)
{
bool syncFull = (bool)args.Argument;
try
{
Sync(syncFull);
}
catch (OperationCanceledException e)
{
Logger.Info(e.Message);
}
catch (CmisPermissionDeniedException e)
{
repo.OnSyncError(new PermissionDeniedException("Authentication failed.", e));
}
catch (Exception e)
{
repo.OnSyncError(new BaseException(e));
}
finally
{
SyncComplete(syncFull);
}
}
);
}
