//Update
public async Task <TranStatus> updateProduct(int ID, ProductListModel model)
{
using (var connection = new SqlConnection(ConnectionString))
{
await connection.OpenAsync();
TranStatus transaction = new TranStatus();
DynamicParameters parameter = new DynamicParameters();
parameter.Add("@Product_ID", ID);
parameter.Add("@Cid", model.Cid);
parameter.Add("@Sid", model.Sid);
parameter.Add("@Productname", model.Productname);
parameter.Add("@Description", model.Description);
parameter.Add("@Price", model.Price);
//parameter.Add("@Image", model.Image);
//parameter.Add("@Date", model.Date);
parameter.Add("@Modifiedby", model.Modifiedby);
//Data Table Type -- to update multiple image
DataTable dataTable = CommonHelper.ToDataTable(model.ImageListData);
parameter.Add("@ImageListing", dataTable.AsTableValuedParameter("dbo.ImageList"));
parameter.Add("@Message", dbType: DbType.String, direction: ParameterDirection.Output, size: 500);
parameter.Add("@Code", dbType: DbType.Int32, direction: ParameterDirection.Output);
await connection.QueryAsync("updateProduct", parameter, commandType : CommandType.StoredProcedure);
transaction.returnMessage = parameter.Get <string>("@Message");
transaction.code = parameter.Get <int>("@Code");
return(transaction);
}
}
//Register
public async Task <TranStatus> AdminRegister(AdminRegisterModel model)
{
using (var connection = new SqlConnection(ConnectionString))
{
await connection.OpenAsync();
TranStatus transaction = new TranStatus();
DynamicParameters parameter = new DynamicParameters();
parameter.Add("@Username", model.Username);
parameter.Add("@Gender", model.Gender);
parameter.Add("@Email", model.Email);
parameter.Add("@Mobile", model.Mobile);
parameter.Add("@Password", model.Password);
parameter.Add("@Cpassword", model.Cpassword);
parameter.Add("@Createdby", model.Createdby);
parameter.Add("@Message", dbType: DbType.String, direction: ParameterDirection.Output, size: 500);
parameter.Add("@Code", dbType: DbType.Int32, direction: ParameterDirection.Output);
await connection.QueryAsync("AdminRegister", parameter, commandType : CommandType.StoredProcedure);
transaction.returnMessage = parameter.Get <string>("@Message");
transaction.code = parameter.Get <int>("@Code");
return(transaction);
}
}
public async Task <TranStatus> SendMail_Sales(SendMailModel model)
{
using (var connection = new SqlConnection(ConnectionString))
{
await connection.OpenAsync();
TranStatus transaction = new TranStatus();
DynamicParameters parameter = new DynamicParameters();
parameter.Add("@UserName", model.UsernameEmail);
parameter.Add("@Token", dbType: DbType.String, direction: ParameterDirection.Output, size: 50);
parameter.Add("@UserIdentity", dbType: DbType.Int32, direction: ParameterDirection.Output);
parameter.Add("@User", dbType: DbType.String, direction: ParameterDirection.Output, size: 50);
parameter.Add("@Message", dbType: DbType.String, direction: ParameterDirection.Output, size: 500);
parameter.Add("@Code", dbType: DbType.Int32, direction: ParameterDirection.Output);
await connection.QueryAsync("SendMail_Sales", parameter, commandType : CommandType.StoredProcedure);
transaction.returnMessage = parameter.Get <string>("@Message");
transaction.code = parameter.Get <int>("@Code");
if (transaction.code == 0)
{
transaction.Token = parameter.Get <string>("@Token");
transaction.User = parameter.Get <string>("@User");
transaction.UserIdentity = parameter.Get <int>("@UserIdentity");
}
return(transaction);
}
}
public async Task <TranStatus> update_n_addProducts(int Aid, Update_ActivityModel model)
{
using (var connection = new SqlConnection(ConnectionString))
{
await connection.OpenAsync();
TranStatus transaction = new TranStatus();
DynamicParameters parameter = new DynamicParameters();
parameter.Add("@Activity_Id", Aid);
//parameter.Add("@Title", model.Title);
//parameter.Add("@Description", model.Description);
//parameter.Add("@SalesID", model.SalesID);
//parameter.Add("@ClientID", model.ClientID);
//parameter.Add("@Contact", model.Contact);
//parameter.Add("@AppointmentDate", model.AppointmentDate);
parameter.Add("@Modifiedby", model.Modifiedby);
//Data Table Type -- to insert multiple products
DataTable dataTable = model.ProductList.ToDataTable();
parameter.Add("@ProductDetails", dataTable.AsTableValuedParameter("dbo.ProductList"));
parameter.Add("@Message", dbType: DbType.String, direction: ParameterDirection.Output, size: 500);
parameter.Add("@Code", dbType: DbType.Int32, direction: ParameterDirection.Output);
await connection.QueryAsync("update_n_addProducts", parameter, commandType : CommandType.StoredProcedure);
transaction.returnMessage = parameter.Get <string>("@Message");
transaction.code = parameter.Get <int>("@Code");
return(transaction);
}
}
//Update Products added in activity
public async Task <TranStatus> update_old_Products(int Aid, Update_products_in_ActivityModel model)
{
using (var connection = new SqlConnection(ConnectionString))
{
await connection.OpenAsync();
TranStatus transaction = new TranStatus();
DynamicParameters parameter = new DynamicParameters();
parameter.Add("@Activity_Id", Aid);
parameter.Add("@Order_Id", model.Order_Id);
parameter.Add("@ProductID", model.ProductID);
//parameter.Add("@Price", model.Price);
parameter.Add("@Quantity", model.Quantity);
parameter.Add("@Amount", model.Amount);
parameter.Add("@Discount_per", model.Discount_per);
parameter.Add("@Discount_amt", model.Discount_amt);
parameter.Add("@Total_price", model.Total_price);
parameter.Add("@Modifiedby", model.Modifiedby);
parameter.Add("@Message", dbType: DbType.String, direction: ParameterDirection.Output, size: 500);
parameter.Add("@Code", dbType: DbType.Int32, direction: ParameterDirection.Output);
await connection.QueryAsync("update_old_Products", parameter, commandType : CommandType.StoredProcedure);
transaction.returnMessage = parameter.Get <string>("@Message");
transaction.code = parameter.Get <int>("@Code");
return(transaction);
}
}
public async Task <IActionResult> updateSalesProfile([FromBody] updateSalesModel model)
{
Dictionary <String, Object> dctData = new Dictionary <string, object>();
HttpStatusCode statusCode = HttpStatusCode.OK;
TranStatus transaction = new TranStatus();
try
{
//model.Image = CommonHelper.SaveImage(HttpContext, "Images\\SalesProfile", model.Image, true, model.ImageExtn);
model.Image = CommonHelper.SaveImage(HttpContext, "Avatars\\Sales", model.Image, true, model.ImageExtn);
//transaction = await isales.updateSalesProfile(model);
var result = await isales.updateSalesProfile(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));
}
public IActionResult each_admin_ClientList([FromBody] ClientListModel model)
{
TranStatus transaction = new TranStatus();
Dictionary <String, Object> dctData = new Dictionary <string, object>();
HttpStatusCode statusCode = HttpStatusCode.OK;
try
{
List <ClientListModel> each_admin_ClientList = new List <ClientListModel>();
int rowcount = 0;
each_admin_ClientList = iclient.each_admin_ClientList(model, out rowcount);
dctData.Add("each_admin_ClientList", each_admin_ClientList);
dctData.Add("RowCount", rowcount);
//var clientList = await iclient.each_admin_ClientList(model);
//dctData.Add("each_admin_ClientList", clientList);
}
catch (Exception ex)
{
transaction = CommonHelper.TransactionErrorHandler(ex);
statusCode = HttpStatusCode.BadRequest;
}
dctData.Add("Status", transaction);
return(this.StatusCode(Convert.ToInt32(statusCode), dctData));
}
public async Task <IActionResult> ProductList()
{
TranStatus transaction = new TranStatus();
Dictionary <String, Object> dctData = new Dictionary <string, object>();
HttpStatusCode statusCode = HttpStatusCode.OK;
try
{
var productList = await iproduct.ProductList();
dctData.Add("ProductList", productList);
//List<ProductListModel> ProductList = new List<ProductListModel>();
//List<GetProductImageListModel> ImageList = new List<GetProductImageListModel>();
//var result = await iproduct.ProductList(model);
//ProductList = result.Item1;
//ImageList = result.Item2;
//dctData.Add("ProductList", ProductList);
//dctData.Add("ImageList", ImageList);
}
catch (Exception ex)
{
transaction = CommonHelper.TransactionErrorHandler(ex);
statusCode = HttpStatusCode.BadRequest;
}
dctData.Add("Status", transaction);
return(this.StatusCode(Convert.ToInt32(statusCode), dctData));
}
public async Task <IActionResult> updateProduct(int ID, [FromBody] ProductListModel model)
{
Dictionary <String, Object> dctData = new Dictionary <string, object>();
HttpStatusCode statusCode = HttpStatusCode.OK;
TranStatus transaction = new TranStatus();
//try
//{
// model.Image = CommonHelper.SaveImage(HttpContext, "Images\\Product", model.Image, true, model.ImageExtn);
// transaction = await iproduct.updateProduct(ID, model);
//}
try
{
//This for loop for adding the multiple Image
for (var i = 0; i < model.ImageList.Count; i++)
{
model.ImageListData[i].Image = CommonHelper.SaveImage(HttpContext, "Images\\Product", model.ImageList[i].ImageData, true, model.ImageList[i].ImageExtn);
}
transaction = await iproduct.updateProduct(ID, model);
}
catch (Exception ex)
{
transaction = CommonHelper.TransactionErrorHandler(ex);
statusCode = HttpStatusCode.BadRequest;
}
dctData.Add("Status", transaction);
return(this.StatusCode(Convert.ToInt32(statusCode), dctData));
}
//Update
public async Task<TranStatus> updateClient(int ID, ClientListModel model)
{
using (var connection = new SqlConnection(ConnectionString))
{
await connection.OpenAsync();
TranStatus transaction = new TranStatus();
DynamicParameters parameter = new DynamicParameters();
parameter.Add("@ID", ID);
parameter.Add("@ClientName", model.ClientName);
parameter.Add("@Email", model.Email);
parameter.Add("@Contact", model.Contact);
parameter.Add("@Gender", model.Gender);
parameter.Add("@Address", model.Address);
parameter.Add("@Street", model.Street);
parameter.Add("@Cid", model.Cid);
parameter.Add("@Sid", model.Sid);
parameter.Add("@Cityid", model.Cityid);
parameter.Add("@PostalCode", model.PostalCode);
parameter.Add("@Latitude", model.Latitude);
parameter.Add("@Longitude", model.Longitude);
parameter.Add("@Modifiedby", model.Modifiedby);
parameter.Add("@Message", dbType: DbType.String, direction: ParameterDirection.Output, size: 500);
parameter.Add("@Code", dbType: DbType.Int32, direction: ParameterDirection.Output);
await connection.QueryAsync("updateClient", parameter, commandType: CommandType.StoredProcedure);
transaction.returnMessage = parameter.Get<string>("@Message");
transaction.code = parameter.Get<int>("@Code");
return transaction;
}
}
/// <summary>
/// 提交事务
/// </summary>
internal void CommitTran()
{
if (currentTransStatus != TranStatus.已开始)
{
throw new Exception("事务提交失败,没有需要提交的事务");
}
dbHelper.CommitTran();
currentTransStatus = TranStatus.未开始;
}
/// <summary>
/// 开始物务
/// </summary>
internal void BeginTran()
{
if (currentTransStatus != TranStatus.未开始)
{
throw new Exception("事务开始失败,已有未完成的事务");
}
dbHelper.BeginTran();
currentTransStatus = TranStatus.已开始;
}
/// <summary>
/// 提交事务
/// </summary>
public void CommitTran()
{
if (currentTranStatus != TranStatus.已开始)
{
throw new Exception("事务提交失败,没有需要提交的事务");
}
helper.CommitTran();
currentTranStatus = TranStatus.未开始;
}
/// <summary>
/// 开始物务
/// </summary>
public void BeginTran()
{
if (currentTranStatus != TranStatus.未开始)
{
throw new Exception("事务开始失败,已有未完成的事务");
}
helper.BeginTran();
currentTranStatus = TranStatus.已开始;
}
/// <summary>
/// 回滚事务
/// </summary>
public void RollbackTran()
{
if (currentTranStatus != TranStatus.已开始)
{
throw new Exception("事务回滚失败,没有需要回滚的事务");
}
helper.RollbackTran();
currentTranStatus = TranStatus.未开始;
}
//View Subcategory
public async Task <List <SubcategoryListModel> > ViewSubcategoryList()
{
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
TranStatus transaction = new TranStatus();
DynamicParameters parameter = new DynamicParameters();
var result = await connection.QueryAsync <SubcategoryListModel>("ViewSubcategoryList", commandType : CommandType.StoredProcedure);
return(result.ToList());
}
}
//Display City
public async Task <List <CityModel> > CityList(int stid)
{
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
TranStatus transaction = new TranStatus();
DynamicParameters parameter = new DynamicParameters();
parameter.Add("@Sid", stid);
var result = await connection.QueryAsync <CityModel>("CityList", parameter, commandType : CommandType.StoredProcedure);
return(result.ToList());
}
}
// Sales list in dropdown
public async Task <List <SalesList_DropdownModel> > SalesList_dropdown(SalesList_DropdownModel model)
{
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
TranStatus transaction = new TranStatus();
DynamicParameters parameter = new DynamicParameters();
parameter.Add("@AdminID", model.UserId);
var result = await connection.QueryAsync <SalesList_DropdownModel>("SalesList_dropdown", parameter, commandType : CommandType.StoredProcedure);
return(result.ToList());
}
}
// Count Assigned list on bell notification
public async Task <List <newNotificationActivityLisModel> > assigned_activityList(newNotificationActivityLisModel model)
{
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
TranStatus transaction = new TranStatus();
DynamicParameters parameter = new DynamicParameters();
parameter.Add("@SalesID", model.userId);
var result = await connection.QueryAsync <newNotificationActivityLisModel>("assigned_activityList", parameter, commandType : CommandType.StoredProcedure);
return(result.ToList());
}
}
public IActionResult EditTran(int id, TranStatus status)
{
var findTran = _ctx.Transactions.Where(x => x.TransactionId == id);
var z = status.ToString();
foreach (var item in findTran)
{
item.Status = z;
_ctx.Transactions.Update(item);
}
_ctx.SaveChanges();
return(Ok());
}
//Get Product Price
public async Task <List <ProductPriceModel> > ProductPrice(int id)
{
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
TranStatus transaction = new TranStatus();
DynamicParameters parameter = new DynamicParameters();
parameter.Add("@Id", id);
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 <ProductPriceModel>("ProductPrice", parameter, commandType : CommandType.StoredProcedure);
return(result.ToList());
}
}
public List <ChatModel> unread_messages(ChatModel model)
{
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
TranStatus transaction = new TranStatus();
DynamicParameters parameter = new DynamicParameters();
parameter.Add("@Sender", model.SenderId);
parameter.Add("@Receiver", model.ReceiverId);
//parameter.Add("@RowCount", dbType: DbType.Int32, direction: ParameterDirection.Output);
var result = connection.Query <ChatModel>("unread_messages", parameter, commandType: CommandType.StoredProcedure);
//RowCount = parameter.Get<int>("@RowCount");
return(result.ToList());
}
}
public List <admin_ActivityListModel> each_user_activityList(admin_ActivityListModel model, out int RowCount)
{
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
TranStatus transaction = new TranStatus();
DynamicParameters parameter = new DynamicParameters();
parameter.Add("@UserID", model.userId);
parameter.Add("@pageIndex", model.pageIndex);
parameter.Add("@pageSize", model.pageSize);
parameter.Add("@RowCount", dbType: DbType.Int32, direction: ParameterDirection.Output);
var result = connection.Query <admin_ActivityListModel>("each_user_activityList", parameter, commandType: CommandType.StoredProcedure);
RowCount = parameter.Get <int>("@RowCount");
return(result.ToList());
}
}
public async Task <IActionResult> ResetPasswordAdmin(string Token, [FromBody] ResetPasswordAdminModel model)
{
Dictionary <String, Object> dctData = new Dictionary <string, object>();
HttpStatusCode statusCode = HttpStatusCode.OK;
TranStatus transaction = new TranStatus();
try
{
transaction = await iresetpassword.ResetPasswordAdmin(Token, model);
}
catch (Exception ex)
{
transaction = CommonHelper.TransactionErrorHandler(ex);
statusCode = HttpStatusCode.BadRequest;
}
dctData.Add("Status", transaction);
return(this.StatusCode(Convert.ToInt32(statusCode), dctData));
}
//Change Status Client
public async Task<TranStatus> ChangeStatusClient(int id)
{
using (var connection = new SqlConnection(ConnectionString))
{
await connection.OpenAsync();
TranStatus transaction = new TranStatus();
DynamicParameters parameter = new DynamicParameters();
parameter.Add("@ID", id);
parameter.Add("@Message", dbType: DbType.String, direction: ParameterDirection.Output, size: 500);
parameter.Add("@Code", dbType: DbType.Int32, direction: ParameterDirection.Output);
await connection.QueryAsync("ChangeStatusClient", parameter, commandType: CommandType.StoredProcedure);
transaction.returnMessage = parameter.Get<string>("@Message");
transaction.code = parameter.Get<int>("@Code");
return transaction;
}
}
public async Task <IActionResult> activity_history(int Aid, [FromBody] ActivityListModel model)
{
Dictionary <String, Object> dctData = new Dictionary <string, object>();
HttpStatusCode statusCode = HttpStatusCode.OK;
TranStatus transaction = new TranStatus();
try
{
transaction = await iactivity.activity_history(Aid, model);
}
catch (Exception ex)
{
transaction = CommonHelper.TransactionErrorHandler(ex);
statusCode = HttpStatusCode.BadRequest;
}
dctData.Add("Status", transaction);
return(this.StatusCode(Convert.ToInt32(statusCode), dctData));
}
public async Task <IActionResult> deleteActivity_Product(int productId)
{
Dictionary <String, Object> dctData = new Dictionary <string, object>();
HttpStatusCode statusCode = HttpStatusCode.OK;
TranStatus transaction = new TranStatus();
try
{
transaction = await iactivity.deleteActivity_Product(productId);
}
catch (Exception ex)
{
transaction = CommonHelper.TransactionErrorHandler(ex);
statusCode = HttpStatusCode.BadRequest;
}
dctData.Add("Status", transaction);
return(this.StatusCode(Convert.ToInt32(statusCode), dctData));
}
public async Task <IActionResult> Refresh_Sales_Location([FromBody] Refresh_Sales_Location_Model model)
{
Dictionary <String, Object> dctData = new Dictionary <string, object>();
HttpStatusCode statusCode = HttpStatusCode.OK;
TranStatus transaction = new TranStatus();
try
{
transaction = await isales.Refresh_Sales_Location(model);
}
catch (Exception ex)
{
transaction = CommonHelper.TransactionErrorHandler(ex);
statusCode = HttpStatusCode.BadRequest;
}
dctData.Add("Status", transaction);
return(this.StatusCode(Convert.ToInt32(statusCode), dctData));
}
public async Task <IActionResult> changesalesPassword(int Id, [FromBody] ChangepasswordModel model)
{
Dictionary <String, Object> dctData = new Dictionary <string, object>();
HttpStatusCode statusCode = HttpStatusCode.OK;
TranStatus transaction = new TranStatus();
try
{
transaction = await isales.changesalesPassword(Id, model);
}
catch (Exception ex)
{
transaction = CommonHelper.TransactionErrorHandler(ex);
statusCode = HttpStatusCode.BadRequest;
}
dctData.Add("Status", transaction);
return(this.StatusCode(Convert.ToInt32(statusCode), dctData));
}
//Delete Subcategory
public async Task <TranStatus> deleteSubcategory(int Sid)
{
using (var connection = new SqlConnection(ConnectionString))
{
await connection.OpenAsync();
TranStatus transaction = new TranStatus();
DynamicParameters parameter = new DynamicParameters();
parameter.Add("@Sid", Sid);
parameter.Add("@Message", dbType: DbType.String, direction: ParameterDirection.Output, size: 500);
parameter.Add("@Code", dbType: DbType.Int32, direction: ParameterDirection.Output);
await connection.QueryAsync("deleteSubcategory", parameter, commandType : CommandType.StoredProcedure);
transaction.returnMessage = parameter.Get <string>("@Message");
transaction.code = parameter.Get <int>("@Code");
return(transaction);
}
}
