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