public HttpResponseMessage AddCustomer(RegisterViewModel obj)
{
try
{
using (NavAssignmentEntities db = new NavAssignmentEntities())
{
var checkingData = db.Customers.Any(m => m.emailId == obj.emailId || m.mobileNumber == obj.mobileNumber);
if (checkingData)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Customer already exists. Please try new"));
}
else
{
Register model = new Register();
model.AddUser(obj);
}
}
}
catch (Exception)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Somthing went wrong"));
}
return(Request.CreateResponse(HttpStatusCode.OK, "Registered Successfully"));
}
public List <ProductViewModel> GetProductList()
{
try
{
using (NavAssignmentEntities db = new NavAssignmentEntities())
{
var allList = db.Products.Where(m => m.isStatus == true).ToList();
List <ProductViewModel> allResultList = new List <ProductViewModel>();
foreach (var item in allList)
{
ProductViewModel dataResult = new ProductViewModel();
dataResult.productName = item.productName;
dataResult.code = item.code;
dataResult.productDescription = item.productDescription;
dataResult.stockQuantity = item.stockQuantity;
dataResult.updatedDate = DateTime.Now;
allResultList.Add(dataResult);
}
return(allResultList);
}
}
catch (Exception)
{
throw;
}
}
public List <RegisterViewModel> GetUserList()
{
try
{
using (NavAssignmentEntities db = new NavAssignmentEntities())
{
var allList = db.Customers.Where(m => m.isStatus == true).ToList();
List <RegisterViewModel> allResultList = new List <RegisterViewModel>();
foreach (var item in allList)
{
RegisterViewModel dataResult = new RegisterViewModel();
dataResult.customerAddress = item.customerAddress;
dataResult.customername = item.customername;
dataResult.gender = item.gender;
dataResult.emailId = item.emailId;
dataResult.mobileNumber = item.mobileNumber;
dataResult.createdDate = item.createdDate;
allResultList.Add(dataResult);
}
return(allResultList);
}
}
catch (Exception)
{
throw;
}
}
public HttpResponseMessage AddProduct(ProductViewModel obj)
{
try
{
using (NavAssignmentEntities db = new NavAssignmentEntities())
{
var checkingData = db.Products.Any(m => m.code == obj.code || m.productName == obj.productName);
if (checkingData)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Product already exists. Please try new"));
}
else
{
ProductItems model = new ProductItems();
model.AddProduct(obj);
}
}
}
catch (Exception)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Somthing went wrong"));
}
return(Request.CreateResponse(HttpStatusCode.OK, "Added Successfully"));
}
public string AddCustomerOrder(CustomerOrderViewModel obj)
{
try
{
using (NavAssignmentEntities db = new NavAssignmentEntities())
{
Order orderObj = new Order();
orderObj.CustomerId = obj.CustomerId;
orderObj.OrderType = obj.OrderType;
orderObj.PaymentType = obj.PaymentType;
orderObj.GrandTotal = obj.GrandTotal;
orderObj.deliveryDate = obj.deliveryDate;
orderObj.isStatus = true;
orderObj.createdDate = orderObj.updatedDate = DateTime.Now;
orderObj.noofItems = obj.noofItems;
db.Orders.Add(orderObj);
db.SaveChanges();
return("Ok");
}
}
catch (Exception)
{
throw;
}
}
public HttpResponseMessage GetCustomerOrderList()
{
try
{
using (NavAssignmentEntities db = new NavAssignmentEntities())
{
var checkingData = db.GetCustomerOrderItemList().ToList();
return(Request.CreateResponse(HttpStatusCode.OK, checkingData));
}
}
catch (Exception)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Somthing went wrong"));
}
}
public string DeleteProduct(int id)
{
try
{
using (NavAssignmentEntities db = new NavAssignmentEntities())
{
Product cus = db.Products.Where(m => m.productId == id).FirstOrDefault();
cus.isStatus = false;
db.SaveChanges();
return("Ok");
}
}
catch (Exception)
{
throw;
}
}
public string DeleteUser(int id)
{
try
{
using (NavAssignmentEntities db = new NavAssignmentEntities())
{
Customer cus = db.Customers.Where(m => m.customerId == id).FirstOrDefault();
cus.isStatus = false;
db.SaveChanges();
return("Ok");
}
}
catch (Exception)
{
throw;
}
}
public HttpResponseMessage AddCustomerOrder(CustomerOrderItemViewModel obj)
{
try
{
using (NavAssignmentEntities db = new NavAssignmentEntities())
{
CustomerOrderItem model = new CustomerOrderItem();
model.AddCustomerOrderItems(obj);
}
}
catch (Exception)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Somthing went wrong"));
}
return(Request.CreateResponse(HttpStatusCode.OK, "Successfull"));
}
public string EditProductr(ProductViewModel obj)
{
try
{
using (NavAssignmentEntities db = new NavAssignmentEntities())
{
// Customer
Product pro = db.Products.Where(m => m.productId == obj.productId).FirstOrDefault();
pro.productName = obj.productName;
pro.code = obj.code;
pro.productDescription = obj.productDescription;
pro.stockQuantity = obj.stockQuantity;
pro.updatedDate = DateTime.Now;
return("OK");
}
}
catch (Exception)
{
throw;
}
}
public string EditUser(RegisterViewModel obj)
{
try
{
using (NavAssignmentEntities db = new NavAssignmentEntities())
{
// Customer
Customer cus = db.Customers.Where(m => m.customerId == obj.customerId).FirstOrDefault();
cus.customername = obj.customername;
cus.emailId = obj.emailId;
cus.customerAddress = obj.customerAddress;
cus.gender = obj.gender;
cus.mobileNumber = obj.mobileNumber;
cus.updatedDate = DateTime.Now;
return(null);
}
}
catch (Exception)
{
throw;
}
}
public RegisterViewModel GetUser(int id)
{
try
{
using (NavAssignmentEntities db = new NavAssignmentEntities())
{
Customer cus = db.Customers.Where(m => m.customerId == id).FirstOrDefault();
RegisterViewModel dataResult = new RegisterViewModel();
dataResult.customerAddress = cus.customerAddress;
dataResult.customername = cus.customername;
dataResult.gender = cus.gender;
dataResult.emailId = cus.emailId;
dataResult.mobileNumber = cus.mobileNumber;
dataResult.createdDate = cus.createdDate;
return(dataResult);
}
}
catch (Exception)
{
throw;
}
}
public string AddProduct(ProductViewModel obj)
{
try
{
using (NavAssignmentEntities db = new NavAssignmentEntities())
{
Product pro = new Product();
pro.productName = obj.productName;
pro.code = obj.code;
pro.productDescription = obj.productDescription;
pro.stockQuantity = obj.stockQuantity;
pro.updatedDate = pro.createdDate = DateTime.Now;
pro.isStatus = true;
db.Products.Add(pro);
db.SaveChanges();
return("Ok");
}
}
catch (Exception)
{
throw;
}
}
public HttpResponseMessage GetCustomer(int id)
{
try
{
using (NavAssignmentEntities db = new NavAssignmentEntities())
{
var checkingData = db.Customers.Any(m => m.customerId == id);
if (!checkingData)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Customer Not Found"));
}
else
{
Register model = new Register();
RegisterViewModel data = model.GetUser(id);
return(Request.CreateResponse(HttpStatusCode.OK, data));
}
}
}
catch (Exception)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Somthing went wrong"));
}
}
public string AddCustomerOrderItems(CustomerOrderItemViewModel obj)
{
try
{
using (NavAssignmentEntities db = new NavAssignmentEntities())
{
OrderItem orderObj = new OrderItem();
orderObj.OrderID = obj.OrderID;
orderObj.productId = obj.productId;
orderObj.itemPrice = obj.itemPrice;
orderObj.GrandTotal = obj.GrandTotal;
orderObj.DiscountAmount = obj.DiscountAmount;
orderObj.isStatus = true;
orderObj.createdDate = orderObj.updatedDate = DateTime.Now;
db.OrderItems.Add(orderObj);
db.SaveChanges();
return("Ok");
}
}
catch (Exception)
{
throw;
}
}
public HttpResponseMessage EditCustomer(RegisterViewModel obj)
{
try
{
using (NavAssignmentEntities db = new NavAssignmentEntities())
{
var checkingData = db.Customers.Any(m => m.customerId == obj.customerId);
if (!checkingData)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Customer Not Found"));
}
else
{
Register model = new Register();
model.EditUser(obj);
}
return(Request.CreateResponse(HttpStatusCode.OK, "updated Successfully"));
}
}
catch (Exception)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Somthing went wrong"));
}
}
public string AddUser(RegisterViewModel obj)
{
try
{
using (NavAssignmentEntities db = new NavAssignmentEntities())
{
Customer cus = new Customer();
cus.customername = obj.customername;
cus.emailId = obj.emailId;
cus.customerAddress = obj.customerAddress;
cus.gender = obj.gender;
cus.mobileNumber = obj.mobileNumber;
cus.updatedDate = cus.createdDate = DateTime.Now;
cus.isStatus = true;
db.Customers.Add(cus);
db.SaveChanges();
return("Ok");
}
}
catch (Exception)
{
throw;
}
}
public HttpResponseMessage GetCustomerList()
{
try
{
using (NavAssignmentEntities db = new NavAssignmentEntities())
{
var checkingData = db.Customers.Any();
if (!checkingData)
{
return(Request.CreateResponse(HttpStatusCode.OK, "No Customers"));
}
else
{
Register model = new Register();
List <RegisterViewModel> dataList = model.GetUserList();
return(Request.CreateResponse(HttpStatusCode.OK, dataList));
}
}
}
catch (Exception)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Somthing went wrong"));
}
}
public HttpResponseMessage EditProduct(ProductViewModel obj)
{
try
{
using (NavAssignmentEntities db = new NavAssignmentEntities())
{
var checkingData = db.Products.Any(m => m.productId == obj.productId);
if (!checkingData)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Product Not Found"));
}
else
{
ProductItems model = new ProductItems();
model.EditProductr(obj);
}
return(Request.CreateResponse(HttpStatusCode.OK, "updated Successfully"));
}
}
catch (Exception)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Somthing went wrong"));
}
}
public HttpResponseMessage DeleteProduct(int id)
{
try
{
using (NavAssignmentEntities db = new NavAssignmentEntities())
{
var checkingData = db.Customers.Any(m => m.customerId == id);
if (!checkingData)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Product Not Found"));
}
else
{
ProductItems model = new ProductItems();
model.DeleteProduct(id);
}
return(Request.CreateResponse(HttpStatusCode.OK, "Deleted Successfully"));
}
}
catch (Exception)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Somthing went wrong"));
}
}
