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);
}
}
