// SalesLogout
//public Task<TranStatus> SalesLogout(SalesModel model)
//{
// using (salesRepository = new SalesRepository())
// {
// return salesRepository.SalesLogout(model);
// }
//}
// Login
//SalesRepository salesloginRepository = null;
//public Task<TranStatus> SalesLogin(SalesLoginModel model)
//{
// using (salesloginRepository = new SalesRepository())
// {
// return salesloginRepository.SalesLogin(model);
// }
//}
public Task <Tuple <List <SalesLoginModel>, TranStatus> > SalesLogin(SalesLoginModel model)
{
using (salesRepository = new SalesRepository())
{
return(salesRepository.SalesLogin(model));
}
}
public async Task <IActionResult> SalesLogin([FromBody] SalesLoginModel model)
{
Dictionary <String, Object> dctData = new Dictionary <string, object>();
HttpStatusCode statusCode = HttpStatusCode.OK;
try
{
var result = await isales.SalesLogin(model);
var loginDetail = result.Item1;
transaction = result.Item2;
dctData.Add("loginDetail", loginDetail);
}
catch (Exception ex)
{
transaction = CommonHelper.TransactionErrorHandler(ex);
statusCode = HttpStatusCode.BadRequest;
}
dctData.Add("Status", transaction);
return(this.StatusCode(Convert.ToInt32(statusCode), dctData));
}
// SalesLogout
//public async Task<TranStatus> SalesLogout(SalesModel model)
//{
// using (var connection = new SqlConnection(ConnectionString))
// {
// await connection.OpenAsync();
// TranStatus transaction = new TranStatus();
// DynamicParameters parameter = new DynamicParameters();
// parameter.Add("@Userid", model.Userid);
// parameter.Add("@Message", dbType: DbType.String, direction: ParameterDirection.Output, size: 500);
// parameter.Add("@Code", dbType: DbType.Int32, direction: ParameterDirection.Output);
// await connection.QueryAsync("SalesLogout", parameter, commandType: CommandType.StoredProcedure);
// transaction.returnMessage = parameter.Get<string>("@Message");
// transaction.code = parameter.Get<int>("@Code");
// return transaction;
// }
//}
//Login
public async Task <Tuple <List <SalesLoginModel>, TranStatus> > SalesLogin(SalesLoginModel model)
{
using (var connection = new SqlConnection(ConnectionString))
{
await connection.OpenAsync();
DynamicParameters parameter = new DynamicParameters();
parameter.Add("@Email", model.Email);
parameter.Add("@Password", model.Password);
parameter.Add("@Latitude", model.Latitude);
parameter.Add("@Longitude", model.Longitude);
parameter.Add("@Message", dbType: DbType.String, direction: ParameterDirection.Output, size: 500);
parameter.Add("@Code", dbType: DbType.Int32, direction: ParameterDirection.Output);
var result = await connection.QueryAsync <SalesLoginModel>("SalesLogin", parameter, commandType : CommandType.StoredProcedure);
transaction.returnMessage = parameter.Get <string>("@Message");
transaction.code = parameter.Get <int>("@Code");
return(new Tuple <List <SalesLoginModel>, TranStatus>(result.ToList(), transaction));
}
}
