public DataTable GetProductsByApplicationID(string appId, string userName, string methodName, string formName) { DataTable dt = new DataTable(); List <sqlTbl> sqlParasList = new List <sqlTbl>(); sqlParasList.Add(new sqlTbl("@P_ApplicationID", appId)); dt = dbConnectionHelper.procedureRequest("GetProductsByApplication", sqlParasList, "iqmarket"); if (dbConnectionHelper.getError() != "") { //ErrorModel error = new ErrorModel(); //error.controlerName = "UserController"; //error.ProcedureName = "GetUserInfoByEmail"; //error.metodName = methodName; //error.formName = formName; //error.date = DateTime.Now; //error.ErrorMessage = dbConnectionHelper.getError(); //error.username = userName; //foreach (sqlTbl el in sqlParasList) // error.parametarList += el.name + ": " + el.value + ";"; //errorHandler.errorLogInsert(error); dt.TableName = "Error"; return(dt); } else { dt.TableName = "Table"; return(dt); } }
public DataTable GetAllApplications(string userName, string methodName, string formName) { DataTable dt = new DataTable(); List <sqlTbl> sqlParasList = new List <sqlTbl>(); dt = dbConnectionHelper.procedureRequest("GetAllApplications", sqlParasList, "iqmarket"); if (dbConnectionHelper.getError() != "") { dt.TableName = "Error"; return(dt); } else { dt.TableName = "Table"; return(dt); } }
public override async Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context) { var identity = new ClaimsIdentity(context.Options.AuthenticationType); if (context.UserName == "@dminTok" && context.Password == "@dminTok") { identity.AddClaim(new Claim(ClaimTypes.Role, "admin")); identity.AddClaim(new Claim("username", "admin")); identity.AddClaim(new Claim(ClaimTypes.Name, "Sourav Mondal")); context.Validated(identity); } else { System.Data.DataTable dt = new System.Data.DataTable(); List <sqlTbl> sqlParasList = new List <sqlTbl>(); sqlParasList.Add(new sqlTbl("@INEmail", context.UserName)); sqlParasList.Add(new sqlTbl("@Pass", context.Password)); //EncryptPassword(context.Password))); dt = dbConnectionHelper.procedureRequest("Login", sqlParasList, "iqmarket"); if (dbConnectionHelper.getError() != "" || dt.Rows.Count == 0) { context.SetError("invalid_grant", "Provided username and password is incorrect"); return; } else { identity.AddClaim(new Claim(ClaimTypes.Role, "user")); identity.AddClaim(new Claim("username", "user")); identity.AddClaim(new Claim(ClaimTypes.Name, "Suresh Sha")); context.Validated(identity); } //Debug.WriteLine("EEE"+ e); //Debug.WriteLine("EEE"); //context.SetError("invalid_grant", "Provided username and password is incorrect"); // return; //if (context.UserName == "user" && context.Password == "user") //{ // identity.AddClaim(new Claim(ClaimTypes.Role, "user")); // identity.AddClaim(new Claim("username", "user")); // identity.AddClaim(new Claim(ClaimTypes.Name, "Suresh Sha")); // context.Validated(identity); //} //else //{ // context.SetError("invalid_grant", "Provided username and password is incorrect"); // return; //} } }
public DataTable GetLastInsertDate() { DataTable dt = new DataTable(); List <sqlTbl> sqlParasList = new List <sqlTbl>(); dt = dbConnectionHelper.procedureRequest("GetLastInsertDate", sqlParasList, "iqmarket"); if (dbConnectionHelper.getError() != "") { dt.TableName = "Error"; return(dt); } else { dt.TableName = "Table"; return(dt); } }
public DataTable GetAllAppMenusForUserGroup(string clientgroupid) { DataTable dt = new DataTable(); List <sqlTbl> sqlParasList = new List <sqlTbl>(); sqlParasList.Add(new sqlTbl("@Id", clientgroupid)); dt = dbConnectionHelper.procedureRequest("GetAppMenusForUserGroup", sqlParasList, "iqmarket"); if (dbConnectionHelper.getError() != "") { dt.TableName = "Error"; return(dt); } else { dt.TableName = "Table1"; return(dt); } }
public DataTable InsertNewCampaign(CampaignModel campaign) { DataTable dt = new DataTable(); List <sqlTbl> sqlParasList = new List <sqlTbl>(); sqlParasList.Add(new sqlTbl("@P_ProductID", campaign.ProductID)); sqlParasList.Add(new sqlTbl("@P_MediumPartnerID", campaign.MediumPartnerID)); sqlParasList.Add(new sqlTbl("@P_ClientID", campaign.ClientID)); sqlParasList.Add(new sqlTbl("@P_ApplicationID", campaign.ApplicationID)); sqlParasList.Add(new sqlTbl("@P_StartDate", campaign.StartDate));//.ToString("yyyy-MM-dd"))); sqlParasList.Add(new sqlTbl("@P_PriceNoDiscount", campaign.PriceNoDiscount)); sqlParasList.Add(new sqlTbl("@P_DiscountPercentage", campaign.DiscountPercentage)); sqlParasList.Add(new sqlTbl("@P_Discount", campaign.Discount)); sqlParasList.Add(new sqlTbl("@P_CampaignPrice", campaign.CampaignPrice)); sqlParasList.Add(new sqlTbl("@P_CampaignTextLong", campaign.CampaignTextLong)); sqlParasList.Add(new sqlTbl("@P_Status", campaign.Status)); sqlParasList.Add(new sqlTbl("@P_CampaignTextShort", campaign.CampaignTextShort)); sqlParasList.Add(new sqlTbl("@P_CampaignImagePath", campaign.CampaignImagePath)); sqlParasList.Add(new sqlTbl("@P_CampaignLink", campaign.CampaignLink)); sqlParasList.Add(new sqlTbl("@P_CampaignName", campaign.CampaignName)); sqlParasList.Add(new sqlTbl("@P_GainedImpressions", campaign.GainedImpressions)); sqlParasList.Add(new sqlTbl("@P_BoughtImpressions", campaign.BoughtImpressions)); sqlParasList.Add(new sqlTbl("@P_UserInsert", campaign.UserInsert)); sqlParasList.Add(new sqlTbl("@P_DateInsert", campaign.DateInsert)); sqlParasList.Add(new sqlTbl("@P_UserUpdate", campaign.UserUpdate)); sqlParasList.Add(new sqlTbl("@P_DateUpdate", campaign.DateUpdate)); sqlParasList.Add(new sqlTbl("@P_DateChangeStatus", campaign.DateChangeStatus)); dt = dbConnectionHelper.procedureRequest("InsertNewCampaign", sqlParasList, "iqmarket"); if (dbConnectionHelper.getError() != "") { //ErrorModel error = new ErrorModel(); //error.controlerName = "CampaignController"; //error.ProcedureName = "InsertNewCampaign"; //error.metodName = campaign.methodName; //error.formName = campaign.formName; //error.date = DateTime.Now; //error.ErrorMessage = dbConnectionHelper.getError(); //error.username = campaign.userName; //foreach (sqlTbl el in sqlParasList) // error.parametarList += el.name + ": " + el.value + ";"; //errorHandler.errorLogInsert(error); dt.TableName = "Error"; return(dt); } else { dt.TableName = "Table"; return(dt); } }