public Dictionary <string, object> BankBind(string userid)
{
try
{
var Result = Common.Getdata(dbcontext.MultipleResults("[dbo].[Sp_Mandate]").With <BankBind>().Execute("@QueryType", "@UserId", "UserBank", DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(userid.Replace("_", "%")))));
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public Dictionary <string, object> BindUser(string UserId)
{
try
{
var Result = Common.Getdata(dbcontext.MultipleResults("[dbo].[SP_Report]").With <BindUser>().Execute("@QueryType", "@UserId", "BindDdluser", DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(UserId.Replace("_", "%")))));
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public Dictionary <string, object> getEntity()
{
try
{
var Result = Common.Getdata(dbcontext.MultipleResults("[dbo].[Sp_Entity]").With <Entity>().Execute("@QueryType", "GetEntity"));
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
//public IEnumerable<GridData> GridBind(string Entityid, string Pageno)
//{
// try
// {
// var Result = dbcontext.MultipleResults("[dbo].[Sp_Uploaddata]").With<GridData>().Execute("@QueryType", "@PageCount", "@EntityID", "UMRNUpload", Pageno, DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(Entityid.Replace("_", "%"))));
// foreach (var employe in Result)
// {
// dataList = employe.Cast<GridData>().ToList();
// }
// return dataList;
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
public Dictionary <string, object> GridBind1(string Entityid, string Pageno)
{
try
{
var Result = Common.Getdata(dbcontext.MultipleResults("[dbo].[Sp_Uploaddata]").With <GridData>().With <Paging>().Execute("@QueryType", "@PageCount", "@EntityID", "UMRNUpload", Pageno, DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(Entityid.Replace("_", "%")))));
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public Dictionary <string, object> GetPageLoaddata(string UserId, string EntityId)
{
try
{
var Result = Common.Getdata(dbcontext.MultipleResults("[dbo].[Sp_Mandate]").With <BindEntityDetails> ().With <BindLogoImageDetails>().With <BindBankNameDetails>().With <BindSponserCode>().With <BindBankUtilityCode>().With <BindBankPaymentMode>().With <BindEntityDetailsdata>().With <BindDebitType>().With <Bindfrequency>().With <BindEntityPeriods>().With <BindEntitydebitcredit>().With <BindEntityCategorytype>().With <BindLogincheck>().Execute("@QueryType", "@UserId", "@EntityId", "UserData", DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(UserId.Replace("_", "%"))), DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(EntityId.Replace("_", "%")))));
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public Dictionary <string, object> BindGrid()
{
try
{
var Result = Common.Getdata(dbcontext.MultipleResults("[dbo].[Sp_LinkSetup_AccessRights]").With <BindGrid>().Execute("@QueryType", "BindGridLinkItems"));
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public Dictionary <string, object> BindGrid(string EntityId)
{
try
{
var Result = Common.Getdata(dbcontext.MultipleResults("[dbo].[Sp_Uploaddata]").With <MainGrid>().Execute("@QueryType", "@EntityId", "BindRecord", DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(EntityId.Replace("_", "%")))));
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
// downloadOldMandateTableAttibute
public IEnumerable <downloadOldMandateTableAttibute> GetUserBankData(string UserId)
{
try
{
var Data = dbcontext.MultipleResults("[dbo].[Sp_Mandate]").With <downloadOldMandateTableAttibute>().Execute("@QueryType", "@UserId", "UserBank", DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(UserId.Replace("_", "%"))));
foreach (var dt in Data)
{
downlodmanlist = dt.Cast <downloadOldMandateTableAttibute>().ToList();
}
return(downlodmanlist);
}
catch (Exception ex)
{
throw ex;
}
}
public IEnumerable <DownloadMandateDetails> Binddropdownbank(string userId)
{
// List<DownloadMandateDetails> dataList = new List<DownloadMandateDetails>();
try
{
var Result = dbcontext.MultipleResults("[dbo].[Sp_Mandate]").With <DownloadMandateDetails>().Execute("@QueryType", "@UserId", "UserBank", DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(userId.Replace("_", "%"))));
foreach (var employe in Result)
{
dataList = employe.Cast <DownloadMandateDetails>().ToList();
}
return(dataList);
// return Result;
}
catch (Exception ex)
{
throw ex;
}
}
public Dictionary <string, object> BindCountryAndBank()
{
try
{
var Result = Common.Getdata(dbcontext.MultipleResults("[dbo].[Sp_Entity]").With <BindCountry>().With <BindBank>().With <EntityBusinessCode>().Execute("@QueryType", "BindCountry"));
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public IEnumerable <AccessRightsEntityDetails> BindEntityDetails(string UserType, string ReferenceId)
{
// List<DownloadMandateDetails> dataList = new List<DownloadMandateDetails>();
try
{
var Result = dbcontext.MultipleResults("[dbo].[Sp_LinkSetup_AccessRights]").With <AccessRightsEntityDetails>().Execute("@QueryType", "@userType", "@EntityID", "GetUsersType", DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(UserType.Replace("_", "%"))), DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(ReferenceId.Replace("_", "%"))));
foreach (var employe in Result)
{
dataList = employe.Cast <AccessRightsEntityDetails>().ToList();
}
return(dataList);
// return Result;
}
catch (Exception ex)
{
throw ex;
}
}
//public Dictionary<string, object> BankBind(string UserId,string EntityId)
public IEnumerable <Nachtransactionpresentation> BankBind(string UserId, string EntityId)
{
try
{
var Result = dbcontext.MultipleResults("[dbo].[Sp_Presenment]").With <Nachtransactionpresentation>().Execute("@QueryType", "@UserId", "@EntityId", "Dropdown", DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(UserId.Replace("_", "%"))), DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(EntityId.Replace("_", "%"))));
foreach (var Nachtransactionpresentation in Result)
{
dataList = Nachtransactionpresentation.Cast <Nachtransactionpresentation>().ToList();
}
return(dataList);
}
catch (Exception ex)
{
throw ex;
}
}
public Dictionary <string, object> GetAllUsers(string EntityId, string PageCount, string Search_Text)
{
try
{
var Result = Common.Getdata(dbcontext.MultipleResults("[dbo].[Sp_user]").With <UserData>().With <UtilityCodes>().With <SponsorBankCode>().With <EntityPaymentMode>().With <UserEntity>().With <EntityMandateMode>().With <TempData>().With <CategoryCodes>().Execute("@QueryType", "@EntityId", "@PageCount", "@Search_Text", "BindUser", DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(EntityId.Replace("_", "%"))), PageCount, Search_Text));
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public IEnumerable <HistoricalMandateClass> GetDataFromDB(string FromDate, string ToDate, string UserId)
{
try
{
var Result = dbcontext.MultipleResults("[dbo].[Sp_Mandate]").With <HistoricalMandateClass>().Execute("@QueryType", "@ToDate", "@FromDate", "@UserId", "grdMandateDataDateWise", ToDate, FromDate, DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(UserId.Replace("_", "%"))));
foreach (var HistoricalMandateData in Result)
{
dataList = HistoricalMandateData.Cast <HistoricalMandateClass>().ToList();
}
return(dataList);
}
catch (Exception ex)
{
throw ex;
}
}
public IEnumerable <UMRNHistoryClass> GetDataFromDB(UMRNHistoryClass UMRNHistoryClass)
{
try
{
var Result = dbcontext.MultipleResults("[dbo].[Sp_Presenment]").With <UMRNHistoryClass>().Execute("@QueryType", "@UMRN", "@customer1", "@Refrence1", "@UserID", "UMRNHistoryDetails", UMRNHistoryClass.UMRN, UMRNHistoryClass.customer1, UMRNHistoryClass.RefrNo, DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(UMRNHistoryClass.UserId.Replace("_", "%"))));
foreach (var Data in Result)
{
dataList = Data.Cast <UMRNHistoryClass>().ToList();
}
return(dataList);
}
catch (Exception ex)
{
throw ex;
}
}
public Dictionary <string, object> GetData(string UserId, string EntityId, string topVal, string ActivityType)
{
try
{
var Data = Common.Getdata(dbcontext.MultipleResults("[dbo].[Sp_Mandate]").With <BulkEmandateAttribute>().With <BulkEmandateTabledatacount>().Execute("@QueryType", "@UserId", "@EntityId", "@topVal", "@ActivityType", "DataActivity", DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(UserId.Replace("_", "%"))), DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(EntityId.Replace("_", "%"))), topVal, ActivityType));
//foreach (var dt in Data)
//{
// dataList= dt.Cast<BulkEmandateAttribute>().ToList();
//}
return(Data);
}
catch (Exception ex)
{
throw ex;
}
}
// List<OldMandateAttribute> dataList = new List<OldMandateAttribute>();
// List<downloadOldMandateTableAttibute> downlodmanlist = new List<downloadOldMandateTableAttibute>();
public Dictionary <string, object> GetData(string ActivityID, string UserId, string EntityId, string TEUHID, string LoadData)
{
try
{
var Data = Common.Getdata(dbcontext.MultipleResults("Sp_Bulkmandate").With <MainGridAttribute>().With <MainGridTableCountAttribute>().With <InvalidDataAttribute>().With <InvalidGridTableCountAttribute>().With <ValidatedDataAttribute>().With <ValidatedDataTableCountAttribute>().With <ActivityIDAttribute>().With <AccountRelatedIssueAttribute>().With <AccountRelatedIssueTableCount>().With <MisMatchAttribute>().With <MisMatchTableCount>().With <ValidDataAttribute>().With <ValidDataTableCountAttibute>().Execute("@QueryType", "@ActivityId", "@UserId", "@EntityId", "@TEUHID", "@topVal", "ActivityWiseViewData", ActivityID, DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(UserId.Replace("_", "%"))), DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(EntityId.Replace("_", "%"))), TEUHID, LoadData));
//foreach (var dt in Data)
//{
// dataList= dt.Cast<BulkEmandateAttribute>().ToList();
//}
return(Data);
}
catch (Exception ex)
{
throw ex;
}
}
public TestmodelMandateList GridBind1(string Entityid, string Pageno)
{
TestmodelMandateList obj = new TestmodelMandateList();
List <Testmodel> dataList = new List <Testmodel>();
List <TestmodelMandate> dataList1 = new List <TestmodelMandate>();
try
{
var Result = dbcontext.MultipleResults("[dbo].[Sp_WebAPI]").With <Testmodel>().With <TestmodelMandate>().Execute("@QueryType", "GetLiveBank");
dataList = Result.FirstOrDefault().Cast <Testmodel>().ToList();
dataList1 = Result.LastOrDefault().Cast <TestmodelMandate>().ToList();
//foreach (var Logindata in Result)
//{
// dataList = Logindata.Cast<Testmodel>().ToList();
//}
obj.BankList = dataList;
obj.StatusList = dataList1;
return(obj);
}
catch (Exception ex)
{
throw ex;
}
}
public IEnumerable <CommonFlag> Binddetails(string Username, string Password)
{
List <Logindetails> dataList = new List <Logindetails>();
try
{
var Result = dbcontext.MultipleResults("[dbo].[sp_UserLogin]").With <Logindetails>().Execute("@QueryType", "@UserName", "GetUser", Username);
foreach (var Logindata in Result)
{
dataList = Logindata.Cast <Logindetails>().ToList();
if (dataList.Count > 0)
{
string strDbPassword = DbSecurity.Decrypt(Convert.ToString(Logindata.Cast <Logindetails>().ToList().Select(x => x.Password).First().ToString()), Convert.ToString(Logindata.Cast <Logindetails>().ToList().Select(x => x.PasswordKey).First().ToString()));
if (strDbPassword.Trim() != Password)
{
Flag.Flag = "0";
Flag.FlagValue = "Wrong Username or Password!!";
common.Add(Flag);
}
else
{
Random generator = new Random();
QuickCheckEmandate_AngularEntities dbcontext = new QuickCheckEmandate_AngularEntities();
var SaveLoginSessionTrxn = dbcontext.MultipleResults("[dbo].[sp_UserLogin]").With <SaveLoginSessionTrxn>().Execute("@QueryType", "@UserId", "@TokenID", "@IPAddress", "@MacAddress", "@IsLogin", "SaveLoginSessionTrxn", Convert.ToString(Logindata.Cast <Logindetails>().ToList().Select(x => x.UserId).First().ToString()), Convert.ToString(generator.Next(1, 1000000)), Convert.ToString(GetIpAddress()), Convert.ToString(GetMacAddress()), Convert.ToString(1));
foreach (var Existlogin in SaveLoginSessionTrxn)
{
// if (Existlogin.Cast<SaveLoginSessionTrxn>().ToList().Select(x => x.SessionActive).First().ToString() == "0")
// {
#region Session creation
// Iace.User.User.SaveUserToSession(dataList);
Flag.IsRefrenceCheck = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsRefrenceCheck).First().ToString()))).Replace("%", "_");
Flag.IsOverPrintMandate = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsOverPrintMandate).First().ToString()))).Replace("%", "_");
Flag.IsBulkMandate = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsBulkMandate).First().ToString()))).Replace("%", "_");
Flag.IsMandate = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsMandate).First().ToString()))).Replace("%", "_");
//NewCode
Flag.IsMandateEdit = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsMandateEdit).First().ToString()))).Replace("%", "_");
Flag.IsRefrenceEdit = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsRefrenceEdit).First().ToString()))).Replace("%", "_");
Flag.IsEmandate = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsEmandate).First().ToString()))).Replace("%", "_");
Flag.IsPhysical = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsPhysical).First().ToString()))).Replace("%", "_");
Flag.IsZipShoreABPS = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsZipShoreABPS).First().ToString()))).Replace("%", "_");
Flag.UserId = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserId).First().ToString()))).Replace("%", "_");
Flag.ReferenceId = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(dataList.Cast <Logindetails>().ToList().Select(x => x.ReferenceId).First().ToString())).Replace("%", "_");
Flag.UserName = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserName).First().ToString()))).Replace("%", "_");
Flag.Password = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.Password).First().ToString()))).Replace("%", "_");
Flag.PasswordKey = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.PasswordKey).First().ToString()))).Replace("%", "_");
Flag.UserCode = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserCode).First().ToString()))).Replace("%", "_");
Flag.UserType = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.UserType).First().ToString()))).Replace("%", "_");
Flag.BranchId = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(dataList.Cast <Logindetails>().ToList().Select(x => x.BranchId).First().ToString())).Replace("%", "_");
Flag.BranchName = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.BranchName).First().ToString()))).Replace("%", "_");
Flag.IsDefaultPswdChange = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsDefaultPswdChange).First().ToString()))).Replace("%", "_");
Flag.LastLogin = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.LastLogin).First().ToString()))).Replace("%", "_");
Flag.IsActive = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsActive).First().ToString()))).Replace("%", "_");
Flag.IsDeleted = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(Convert.ToString(dataList.Cast <Logindetails>().ToList().Select(x => x.IsDeleted).First().ToString()))).Replace("%", "_");
Flag.CreatedBy = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(dataList.Cast <Logindetails>().ToList().Select(x => x.CreatedBy).First().ToString())).Replace("%", "_");
Flag.CreatedOn = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(dataList.Cast <Logindetails>().ToList().Select(x => x.CreatedOn).First().ToString())).Replace("%", "_");
#endregion
Flag.Flag = "1";
common.Add(Flag);
//}
//else {
// Flag.Flag = "0";
// Flag.FlagValue = "User already logged on. Either Try logging in after closing the current session or Try after some time!!";
// common.Add(Flag);
//}
}
}
}
else
{
Flag.Flag = "0";
Flag.FlagValue = "Invalid User!!";
common.Add(Flag);
}
}
return(common);
}
catch (Exception ex)
{
throw ex;
}
}
public IEnumerable <CommonFlag> SendMail(string Username)
{
try
{
List <Value> dataList = new List <Value>(); List <UserDetails> dataList1 = new List <UserDetails>();
var Result = dbcontext.MultipleResults("[dbo].[Sp_UserLogin]").With <Value>().With <UserDetails>().Execute("@QueryType", "@EmailId", "ChkEmail", Username);
dataList = Result.FirstOrDefault().Cast <Value>().ToList();
dataList1 = Result.LastOrDefault().Cast <UserDetails>().ToList();
if (dataList.Cast <Value>().ToList().Select(x => x.value).First().ToString() == "1")
{
if (dataList1.Count > 0)
{
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter hw = new HtmlTextWriter(sw))
{
StringBuilder sb = new StringBuilder();
string WebAppUrl = ConfigurationManager.AppSettings["WebAppUrl"].ToString();
string SMTPHost = ConfigurationManager.AppSettings["Amazon_SMTPHost"].ToString();
string UserId = ConfigurationManager.AppSettings["Amazon_UserId"].ToString();
string MailPassword = ConfigurationManager.AppSettings["Amazon_MailPassword"].ToString();
string SMTPPort = ConfigurationManager.AppSettings["Amazon_SMTPPort"].ToString();
string SMTPEnableSsl = ConfigurationManager.AppSettings["Amazon_SMTPEnableSsl"].ToString();
string FromMailId = ConfigurationManager.AppSettings["Amazon_FromMailId"].ToString();
string Teamtext = ConfigurationManager.AppSettings["Team"].ToString();
sb.Append("Dear " + dataList1.Cast <UserDetails>().ToList().Select(x => x.UserName).First().ToString() + ",<br> <br>");
sb.Append("Please click on the below button to set a new Password . <br> <br>");
string User = HttpContext.Current.Server.UrlEncode(DbSecurity.Encrypt(dataList1.Cast <UserDetails>().ToList().Select(x => x.UserId).First().ToString())).Replace("%", "_");
sb.Append("<a href=' " + WebAppUrl + "ChangePassword/" + User + "' target='_blank'>");
sb.Append("<input style='background-color: #3965a9;color: #fff;padding: 3px 10px 3px 10px;' type='button' value='Change Password' /></a> </div>");
SmtpClient smtpClient = new SmtpClient();
MailMessage mailmsg = new MailMessage();
MailAddress mailaddress = new MailAddress(FromMailId);
mailmsg.To.Add(Username);
mailmsg.From = mailaddress;
mailmsg.Subject = "Recover Password";
mailmsg.IsBodyHtml = true;
mailmsg.Body = sb.ToString();
smtpClient.Host = SMTPHost;
smtpClient.Port = Convert.ToInt32(SMTPPort);
smtpClient.EnableSsl = Convert.ToBoolean(SMTPEnableSsl);
smtpClient.UseDefaultCredentials = true;
smtpClient.Credentials = new System.Net.NetworkCredential(UserId, MailPassword);
smtpClient.Send(mailmsg);
QuickCheckEmandate_AngularEntities dbcontext = new QuickCheckEmandate_AngularEntities();
dbcontext.MultipleResults("[dbo].[Sp_SendEmail]").With <Value>().Execute("@QueryType", "@MandateId", "@EmailCount", "@SmsCount", "SendMail", Convert.ToString(0), "1", "0");
Flag.Flag = "1";
common.Add(Flag);
}
}
}
}
}
catch (Exception)
{
Flag.Flag = "1";
common.Add(Flag);
}
return(common);
}