public List <GetAllUsersModel> GetAllUsers()
{
using (var db = new sdirecttestdbEntities1())
{
List <GetAllUsersModel> users = new List <GetAllUsersModel>();
var result = db.spGetAllUsers_Sk().ToList();
foreach (var j in result)
{
users.Add(new GetAllUsersModel()
{
RoleId = j.RoleId,
UserId = j.UserId,
FirstName = j.FirstName,
MiddleName = j.MiddleName,
LastName = j.LastName,
Email = j.Email,
Mobile = j.Mobile,
Image = this.ByteArrayToString(j.Image),
Password = j.Password,
IsActive = j.IsActive,
IsDeleted = j.IsDeleted,
IsCreatedOn = j.IsCreatedOn,
IsUpdatedOn = j.IsUpdatedOn,
IsDeletedBy = j.IsDeletedBy,
IsCreatedBy = j.IsCreatedBy,
IsUpdatedBy = j.IsUpdatedBy,
}
);
}
return(users);
}
}
public IHttpActionResult PostUtility(Util util)
{
ResponseModel res = new ResponseModel();
try
{
using (var ctx = new sdirecttestdbEntities1())
{
ctx.Utilities.Add(new Utility()
{
Name = util.Name,
CreatedDate = System.DateTime.Now,
ModifiedDate = System.DateTime.Now,
IsDeleted = false,
IsActive = false,
CreatedBy = Environment.UserName,
ModifiedBy = Environment.UserName
});
ctx.SaveChanges();
}
res.StatusCode = 200;
res.Message = "Success";
}
catch (Exception ex)
{
res.StatusCode = 400;
res.Message = ex.Message;
}
return(Ok(res));
}
public void Register(RegisterUserView user)
{
using (var db = new sdirecttestdbEntities1())
{
db.spRegisterUser_Sk(
user.FirstName,
user.MiddleName,
user.LastName,
user.Email,
user.Password,
this.ImageToByteArray(user.Image),
user.Mobile,
user.CityName1,
user.Pincode1,
user.Type1,
user.Address1,
user.Type2,
user.CityName2,
user.Pincode2,
user.Address2,
user.IsSeller,
user.BusinessType,
user.BankName,
user.AccountNumber
);
db.SaveChanges();
}
}
public IHttpActionResult Delete(int id)
{
ResponseModel response = new ResponseModel();
try
{
if (id <= 0)
{
return(BadRequest("Not a valid id"));
}
using (var ctx = new sdirecttestdbEntities1())
{
var utility = ctx.Utilities
.Where(s => s.ID == id)
.FirstOrDefault();
//ctx.Entry(utility).State = System.Data.Entity.EntityState.Deleted;
utility.IsDeleted = true;
utility.ModifiedBy = Environment.UserName;
utility.ModifiedDate = System.DateTime.Now;
ctx.SaveChanges();
}
response.StatusCode = 200;
response.Message = "Success";
}
catch (Exception ex)
{
response.StatusCode = 400;
response.Message = ex.Message;
}
return(Ok(response));
}
public void RemoveOrder(int userId)
{
using (var db = new sdirecttestdbEntities1())
{
db.spRemoveOrder_Sk(userId);
}
}
public IHttpActionResult PutShift(ShiftMaster shift)
{
using (var ctx = new sdirecttestdbEntities1())
{
var existingShift = ctx.ShiftMasters.Where(s => s.ShiftId == shift.ShiftId)
.FirstOrDefault <ShiftMaster>();
if (existingShift != null)
{
existingShift.ShiftName = shift.ShiftName;
existingShift.StartTime = shift.StartTime;
existingShift.EndTime = shift.EndTime;
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
public List <GetCartView> GetCart(int UserId)
{
using (var db = new sdirecttestdbEntities1())
{
List <GetCartView> myCart = new List <GetCartView>();
var itemCountAndInventoryIds = db.spGetItemCountAndInventoryId_Sk(UserId);
foreach (var i in itemCountAndInventoryIds)
{
var ProductData = db.spGetMyCart_Sk(i.InventoryId).FirstOrDefault();
myCart.Add(new GetCartView()
{
ItemCount = i.ItemCount,
Product = new AddProductView()
{
Brand = ProductData.Brand,
Image = this.ByteArrayToString(ProductData.Image),
ProductCategoryId = ProductData.ProductCategoryId,
PricePerUnit = ProductData.PricePerUnit,
ProductCount = ProductData.ProductCount,
ProductName = ProductData.ProductName,
Description = ProductData.Description,
SellerId = ProductData.SellerId,
SellerFullName = db.spGetSellerFullName_Sk(ProductData.SellerId).FirstOrDefault().ToString()
}
});
}
return(myCart);
}
}
public void RegisterSeller(List <RegisterSellerView> decision)
{
using (var db = new sdirecttestdbEntities1())
{
foreach (var i in decision)
{
db.spChangeSellerStatus_Sk(i.SellerId, i.IsActive);
}
}
}
public void CreateOrder(List <OrderView> orderView)
{
//How would you check if the cart is empty in db?
//If cart is empty then run sp to hard delete the order & its items.
using (var db = new sdirecttestdbEntities1())
{
foreach (var i in orderView)
{
db.spCreateOrder_Sk(i.UserId, i.ProductCount, i.ProductId);
}
}
}
public UserView Post(EmailPasswordView credentials)
{
using (var db = new sdirecttestdbEntities1())
{
var result = (from obj in db.tblUser_Sk
where (obj.Email == credentials.Email)
select obj).ToList();
var user = new UserView();
int k = 0;
foreach (var i in result)
{
var UserTables = db.spGetUserDetails_Sk(i.UserId).ToList();
foreach (var j in UserTables)
{
if (k == 0)
{
user.IsSeller = j.IsSeller;
user.RoleId = j.RoleId;
user.UserId = j.UserId;
user.FirstName = j.FirstName;
user.MiddleName = j.MiddleName;
user.LastName = j.LastName;
user.Email = j.Email;
user.Type1 = j.Type;
user.CityName1 = j.CityName;
user.StateName1 = j.StateName;
user.Mobile = j.Mobile;
user.Pincode1 = j.Pincode;
user.Address1 = j.Address;
user.CountryName1 = j.CountryName;
user.Image = this.ByteArrayToString(j.Image);
}
else
{
user.Type2 = j.Type;
user.CityName2 = j.CityName;
user.StateName2 = j.StateName;
user.Pincode2 = j.Pincode;
user.Address2 = j.Address;
user.CountryName2 = j.CountryName;
}
k++;
}
}
return(user);
}
}
public IHttpActionResult GetAllUsers(int userId)
{
using (var db = new sdirecttestdbEntities1())
{
var IsAdmin = (from x in db.tblUser_Sk
where x.UserId == userId && x.RoleId == 1
select x).FirstOrDefault();
if (IsAdmin != null)
{
return(Json(this.DAL_iGetAllUsers.GetAllUsers()));
}
return(Content(HttpStatusCode.BadRequest, "Not Authorized"));
}
}
public static bool VerifySeller(int sellerId)
{
using (var db = new sdirecttestdbEntities1())
{
var result = db.spCheckSellerStatus_Sk(sellerId);
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
}
public IHttpActionResult DeleteShift(int id)
{
if (id <= 0)
{
return(BadRequest("Not a valid id"));
}
using (var ctx = new sdirecttestdbEntities1())
{
var shift = ctx.ShiftMasters
.Where(s => s.ShiftId == id)
.FirstOrDefault();
ctx.Entry(shift).State = System.Data.Entity.EntityState.Deleted;
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult PostShift(ShiftMaster shiftMaster)
{
using (var ctx = new sdirecttestdbEntities1())
{
ctx.ShiftMasters.Add(new ShiftMaster()
{
ShiftId = shiftMaster.ShiftId,
ShiftName = shiftMaster.ShiftName,
StartTime = shiftMaster.StartTime,
EndTime = shiftMaster.EndTime
});
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult GetSellerRequests(int UserId)
{
using (var db = new sdirecttestdbEntities1())
{
var IsAdmin = (from x in db.tblUser_Sk
where x.UserId == UserId && x.RoleId == 1
select x).FirstOrDefault();
if (IsAdmin != null)
{
return(Json(db.spSellerRequests_Sk().ToList()));
}
else
{
return(Content(HttpStatusCode.BadRequest, "Not Authorized"));
}
}
}
public IHttpActionResult ChangeSellerStatus(List <ChangeSellerStatusModel> statusUpdate)
{
if (statusUpdate.Count != 0)
{
using (var db = new sdirecttestdbEntities1())
{
foreach (var i in statusUpdate)
{
db.spChangeSellerStatus_Sk(i.SellerId, i.Action);
}
}
return(Content(HttpStatusCode.OK, "Done"));
}
else
{
return(Content(HttpStatusCode.BadRequest, "Nothing To Update"));
}
}
public void AddProduct(AddProductView newProduct)
{
using (var db = new sdirecttestdbEntities1())
{
db.spAddProduct_Sk(newProduct.ProductCategoryId,
newProduct.ProductName,
newProduct.Description,
newProduct.Brand,
this.ImageToByteArray(newProduct.Image),
newProduct.SellerFullName,
newProduct.SellerFullName,
newProduct.PricePerUnit,
newProduct.ProductCount,
newProduct.SellerId
);
db.SaveChanges();
}
}
public override async Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context)
{
var identity = new ClaimsIdentity(context.Options.AuthenticationType);
context.OwinContext.Response.Headers.Add("Access-Control-Allow-Origin", new[] { "*" });
using (var db = new sdirecttestdbEntities1())
{
if (db != null)
{
var result = (from obj in db.tblUser_Sk
where (obj.Email == context.UserName &&
obj.Password == context.Password)
select obj);
if (result != null)
{
identity.AddClaim(new Claim("Age", "1"));
var props = new AuthenticationProperties(new Dictionary <string, string>
{
{
"Email", context.UserName
}
});
var ticket = new AuthenticationTicket(identity, props);
context.Validated(ticket);
}
else
{
context.SetError("invalid_grant", "Provided username and password is incorrect");
context.Rejected();
}
}
else
{
context.SetError("invalid_grant", "Provided username and password is incorrect");
context.Rejected();
}
return;
}
}
public void CreateAccount(AddBankAccountView user)
{
using (var db = new sdirecttestdbEntities1())
{
db.tblBankNameUser_Sk.Add(new tblBankNameUser_Sk()
{
BankId = user.BankId,
Username = user.Username,
Password = user.Password,
Email = user.Email,
Balance = user.Balance,
AccountNumber = user.AccountNumber,
IsActive = true,
IsCreatedOn = System.DateTime.Now,
IsCreatedBy = "BankAdmin",
IsUpdatedOn = System.DateTime.Now,
IsUpdatedBy = "BankAdmin",
IsDeleted = false
});
}
}
public IHttpActionResult PutUtility(Util util)
{
ResponseModel response = new ResponseModel();
try
{
using (var ctx = new sdirecttestdbEntities1())
{
var existingUtility = ctx.Utilities.Where(s => s.ID == util.ID)
.FirstOrDefault <Utility>();
if (existingUtility != null)
{
existingUtility.Name = util.Name;
existingUtility.ModifiedDate = System.DateTime.Now;
existingUtility.ModifiedBy = Environment.UserName;
//var uti = ctx.Checklist_Utility.Where(x => x.U_ID == util.ID).FirstOrDefault();
//uti.IsActive = true;
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
response.StatusCode = 200;
response.Message = "Success";
}
catch (Exception ex)
{
response.StatusCode = 400;
response.Message = ex.Message;
}
return(Ok(response));
}
public IHttpActionResult PostChecklist(Checklist_Utility checklist_Utility)
{
using (var ctx = new sdirecttestdbEntities1())
{
ctx.Checklist_Utility.Add(new Checklist_Utility()
{
U_ID = checklist_Utility.U_ID,
ShiftId = checklist_Utility.ShiftId,
IsDone = checklist_Utility.IsDone,
Feedback = checklist_Utility.Feedback,
CreatedDate = System.DateTime.UtcNow,
ReadingDate = checklist_Utility.ReadingDate,
IsActive = checklist_Utility.IsActive
});
var uti = ctx.Utilities.Where(x => x.ID == checklist_Utility.U_ID).FirstOrDefault();
uti.IsActive = true;
ctx.SaveChanges();
}
return(Ok());
}
public IList <Report> GetSampleData()
{
List <Report> listx = new List <Report>();
using (sdirecttestdbEntities1 test = new sdirecttestdbEntities1())
{
var result = test.Utility_Report().ToList();
foreach (var item in result.ToList())
{
listx.Add(new Report
{
U_ID = item.U_ID,
Name = item.Name,
//CreatedDate = item.CreatedDate,
ReadingDate = item.ReadingDate,
IsDone = ((item.IsDone) ? "Yes" : "No"),
ShiftId = item.ShiftId,
ShiftName = item.ShiftName,
Feedback = item.Feedback,
});
}
return(listx);
}
}
public List <SearchProductView> GetProducts(string productName)
{
List <SearchProductView> products = new List <SearchProductView>();
using (var db = new sdirecttestdbEntities1())
{
var productResult = db.spGetProducts_Sk(productName).ToList();
foreach (var x in productResult)
{
products.Add(new SearchProductView()
{
ProductName = x.Productname,
ProductId = x.ProductId,
ProductCategoryId = x.ProductCategoryId,
Description = x.Description,
Brand = x.Brand,
Image = this.ByteArrayToString(x.Image),
InventoryId = x.InventoryId,
PricePerUnit = x.PricePerUnit,
ProductCount = x.ProductCount,
SellerId = x.SellerId
});
}
foreach (var i in products)
{
i.SellerFullName = db.spGetSellerFullName_Sk(i.SellerId).FirstOrDefault().ToString();
}
}
return(products);
//List<SearchProductView> products = new List<SearchProductView>();
//using (var db = new sdirecttestdbEntities1())
//{
// var result = (from x in db.tblProducts_Sk
// where (x.ProductName == productName) select x).ToList();
// foreach (var x in result)
// {
// products.Add(new SearchProductView()
// {
// ProductName = x.ProductName,
// ProductId = x.ProductId,
// ProductCategoryId = x.ProductCategoryId,
// Description = x.Description,
// Brand = x.Brand,
// Image = this.ByteArrayToString(x.Image)
// }
// );
// }
//products.AddRange((from x in db.tblProducts_Sk
// where (x.ProductName == productName)
// select new SearchProductView()
// {
// ProductName = x.ProductName,
// ProductId = x.ProductId,
// ProductCategoryId = x.ProductCategoryId,
// Description = x.Description,
// Brand = x.Brand,
// Image = this.ByteArrayToString(x.Image)
// }
// ).ToList());
// {
// ProductName = x.ProductName,
// ProductId = x.ProductId,
// ProductCategoryId = x.ProductCategoryId,
// Description = x.Description,
// Brand = x.Brand,
// Image = this.ByteArrayToString(x.Image)
// }
//to update something
//tblProducts_Sk updateProduct = db.tblProducts_Sk.Find(6);
//updateProduct.ProductCategoryId = 5;
//db.Entry(updateProduct).State = System.Data.Entity.EntityState.Modified;
//db.SaveChanges();
//tblBankNameUser
//tblBankNameUser_Sk newUser = new tblBankNameUser_Sk(){
//BankId = 2,
//Username = "******",
//Password = "******",
//Mobile = 1234567890,
//AccountNumber = 882329,
//Balance = 12000,
// IsActive = true,
// IsCreatedBy = "Shoeb",
// IsUpdatedBy = "Shoeb",
// IsCreatedOn = DateTime.Now,
// IsUpdatedOn = DateTime.Now,
// IsDeleted = false
//};
//db.tblBankNameUser_Sk.Add(newUser);
//db.SaveChanges();
//tblRole_Sk newRole = new tblRole_Sk();
//newRole.RoleName = "User";
//newRole.IsCreatedBy = "Shoeb";
//newRole.IsUpdatedBy = "Shoeb";
//newRole.IsCreatedOn = DateTime.Now;
//newRole.IsUpdatedOn = DateTime.Now;
//db.tblRole_Sk.Add(newRole);
//db.SaveChanges();
//tblUser_Sk user = new tblUser_Sk();
//{
// RoleId = 4,
// FirstName = "Shoeb",
// MiddleName = "",
// LastName = "Khan",
// Email = "*****@*****.**",
// Password = "******",
// Mobile = "8006356362",
// IsCreatedBy = "Shoeb",
// IsUpdatedBy = "Shoeb",
// Image = array,
// IsCreatedOn = DateTime.Now,
// IsUpdatedOn = DateTime.Now
//};
//db.tblUser_Sk.Add(user);
//db.SaveChanges();
//PtblPaymentMethod_Sk add details
//tblPaymentMethod_Sk newMethod = new tblPaymentMethod_Sk()
//{
// BankId = 2,
// Name = "Debit Card",
// IsActive = true,
// IsCreatedBy = "Shoeb",
// IsUpdatedBy = "Shoeb",
// IsCreatedOn = DateTime.Now,
// IsUpdatedOn = DateTime.Now,
// IsDeleted = false
//};
//db.tblPaymentMethod_Sk.Add(newMethod);
//db.SaveChanges();
//tblBorrowMoney_Sk obj = new tblBorrowMoney_Sk()
//{
// BankNameUserId = 1,
// MoneyBorrowed = 0,
// Password = "******",
// IsActive = true,
// IsCreatedBy = "Shoeb",
// IsUpdatedBy = "Shoeb",
// IsCreatedOn = DateTime.Now,
// IsUpdatedOn = DateTime.Now,
// IsDeleted = false
//};
//db.tblBorrowMoney_Sk.Add(obj);
//db.SaveChanges();
//user = db.tblUser_Sk.Find(2);
//var serializer = new JavaScriptSerializer();
//string utfString = Encoding.UTF8.GetString(user.Image, 0, user.Image.Length);
////var serializedResult = serializer.Serialize(user.Image);
//var base64 = Convert.ToBase64String(user.Image);
//no need as it is directly giving us the required output
// var base64 = Convert.ToBase64String(getProducts[0].Image);
//return products;
}
