public ActionResult DeleteCustomer(int id)
{
try
{
using (MOBILESHOPEntities dbcontext = new MOBILESHOPEntities())
{
var cstmr = dbcontext.mbshop_device_detail.Find(id);
if (cstmr != null)
{
var customer = dbcontext.mbshop_customer_details.Find(cstmr.mbshop_customer_details.customer_id);
dbcontext.mbshop_device_detail.Remove(cstmr);
dbcontext.SaveChanges();
if (customer != null)
{
dbcontext.mbshop_customer_details.Remove(customer);
dbcontext.SaveChanges();
}
return(Json(new { key = true, value = "Device Details deleted successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { key = false, value = "Device Details not Found its Deleted from data base!!" }, JsonRequestBehavior.AllowGet));
}
};
}
catch (Exception)
{
return(Json(new { key = false, value = "Unable to the Customer" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult SaveServices(int deviceId, string[] servicesId)
{
try
{
using (MOBILESHOPEntities dbcontext = new MOBILESHOPEntities())
{
var list = dbcontext.Costumer_Device_Services.Where(x => x.cds_device_key == deviceId).ToList();
if (list.Any())
{
foreach (var item in list)
{
dbcontext.Costumer_Device_Services.Remove(item);
dbcontext.SaveChanges();
}
}
foreach (var item in servicesId)
{
int serviceKey = Convert.ToInt32(item);
Costumer_Device_Services service = new Costumer_Device_Services()
{
cds_service_key = serviceKey,
cds_device_key = deviceId,
};
dbcontext.Costumer_Device_Services.Add(service);
dbcontext.SaveChanges();
}
return(Json(new { key = true, value = "Services added successfully" }, JsonRequestBehavior.AllowGet));
};
}
catch (Exception ex)
{
return(Json(new { key = false, value = "Unable to process your request please contact to your admin." }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrUpdateModel(ModelDTO dto)
{
try
{
if (ModelState.IsValid)
{
using (MOBILESHOPEntities dbcontext = new MOBILESHOPEntities())
{
if (dto.id == 0)
{
mb_model_detail mbModel = new mb_model_detail()
{
model_name = dto.modelName,
model_brand_key = dto.Brand
};
dbcontext.mb_model_detail.Add(mbModel);
dbcontext.SaveChanges();
return(Json(new { key = true, value = "model added successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
var model = dbcontext.mb_model_detail.Find(dto.id);
if (model != null)
{
model.model_name = dto.modelName;
model.model_brand_key = dto.Brand;
dbcontext.SaveChanges();
return(Json(new { key = true, value = "Model updated successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { key = true, value = "Model not found" }, JsonRequestBehavior.AllowGet));
}
}
};
}
else
{
return(Json(new { key = false, value = "Please enter correct data" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception)
{
return(Json(new { key = false, value = "Unable to save the Model" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteImage(int imageKey)
{
try
{
using (MOBILESHOPEntities dbcontext = new MOBILESHOPEntities())
{
var item = dbcontext.mb_device_images.Find(imageKey);
if (item != null)
{
var filePath = "~" + item.image_path;
if (System.IO.File.Exists(Server.MapPath(filePath)))
{
System.IO.File.Delete(Server.MapPath(filePath));
}
dbcontext.mb_device_images.Remove(item);
dbcontext.SaveChanges();
return(Json(new { key = true, value = "Image deleted successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { key = false, value = "Image not found" }, JsonRequestBehavior.AllowGet));
}
};
}
catch (Exception ex)
{
return(Json(new { key = false, value = "Unable to process your request please contact to your admin." }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddorUpdateService(ServiceDTO dto)
{
try
{
if (dto.id != 0)
{
using (MOBILESHOPEntities dbcontext = new MOBILESHOPEntities())
{
int key = dto.id;
var service = dbcontext.mbshop_service_detail.Find(key);
if (service != null)
{
service.service_name = dto.serviceName;
service.service_charges = dto.serviceCharges;
dbcontext.SaveChanges();
return(Json(new { key = true, value = "Service updated successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { key = false, value = "service not found" }, JsonRequestBehavior.AllowGet));
}
};
}
else
{
using (MOBILESHOPEntities dbcontext = new MOBILESHOPEntities())
{
mbshop_service_detail mbservice = new mbshop_service_detail()
{
service_name = dto.serviceName,
service_charges = dto.serviceCharges
};
dbcontext.mbshop_service_detail.Add(mbservice);
dbcontext.SaveChanges();
return(Json(new { key = true, value = "Service added successfully" }, JsonRequestBehavior.AllowGet));
};
}
}
catch (Exception)
{
return(Json(new { key = false, value = "Service is not found" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrUpdateBrand(BrandDTO dt)
{
try
{
if (dt.id != 0)
{
using (MOBILESHOPEntities dbcontext = new MOBILESHOPEntities())
{
int key = dt.id;
var brand = dbcontext.mb_brand_detail.Find(key);
if (brand != null)
{
brand.brand_name = dt.BrandName;
dbcontext.SaveChanges();
return(Json(new { key = true, value = "Brand updated successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { key = true, value = "Brand not found" }, JsonRequestBehavior.AllowGet));
}
};
}
else
{
using (MOBILESHOPEntities dbcontext = new MOBILESHOPEntities())
{
mb_brand_detail mbbrand = new mb_brand_detail()
{
brand_name = dt.BrandName
};
dbcontext.mb_brand_detail.Add(mbbrand);
dbcontext.SaveChanges();
return(Json(new { key = true, value = "Brand added successfully" }, JsonRequestBehavior.AllowGet));
};
}
}
catch (Exception ex)
{
return(Json(new { key = false, value = "Unable to save the Brand" }, JsonRequestBehavior.AllowGet));;
}
}
public ActionResult AddOrUpdateFault(FaultDTO dto)
{
try
{
if (dto.id != 0)
{
using (MOBILESHOPEntities dbcontext = new MOBILESHOPEntities())
{
int key = dto.id;
var fault = dbcontext.mb_fault_detail.Find(key);
if (fault != null)
{
fault.fault_name = dto.faultName;
dbcontext.SaveChanges();
return(Json(new { key = true, value = "Fault updated successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { key = true, value = "Fault not found" }, JsonRequestBehavior.AllowGet));
}
};
}
else
{
using (MOBILESHOPEntities dbcontext = new MOBILESHOPEntities())
{
mb_fault_detail mbfault = new mb_fault_detail()
{
fault_name = dto.faultName
};
dbcontext.mb_fault_detail.Add(mbfault);
dbcontext.SaveChanges();
return(Json(new { key = true, value = "fault added successfully" }, JsonRequestBehavior.AllowGet));
};
}
}
catch (Exception)
{
return(Json(new { key = false, value = "fault is not found" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteBrand(int id)
{
try
{
using (MOBILESHOPEntities dbcontext = new MOBILESHOPEntities())
{
var brnd = dbcontext.mb_brand_detail.Find(id);
if (brnd != null)
{
dbcontext.mb_brand_detail.Remove(brnd);
dbcontext.SaveChanges();
return(Json(new { key = true, value = "Brand deleted successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { key = false, value = "Brand not Found its Deleted from data base!!" }, JsonRequestBehavior.AllowGet));
}
};
}
catch (Exception)
{
return(Json(new { key = false, value = "Unable to the Brand" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteService(int id)
{
try
{
using (MOBILESHOPEntities dbcontext = new MOBILESHOPEntities())
{
var service = dbcontext.mbshop_service_detail.Find(id);
if (service != null)
{
dbcontext.mbshop_service_detail.Remove(service);
dbcontext.SaveChanges();
return(Json(new { key = true, value = "service deleted successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { key = true, value = "service not Found its Deleted from data base!!" }, JsonRequestBehavior.AllowGet));
}
};
}
catch (Exception)
{
throw;
}
}
public ActionResult DeleteFault(int id)
{
try
{
using (MOBILESHOPEntities dbcontext = new MOBILESHOPEntities())
{
var fault = dbcontext.mb_fault_detail.Find(id);
if (fault != null)
{
dbcontext.mb_fault_detail.Remove(fault);
dbcontext.SaveChanges();
return(Json(new { key = true, value = "Fault deleted successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { key = false, value = "Fault not Found its Deleted from data base!!" }, JsonRequestBehavior.AllowGet));
}
};
}
catch (Exception)
{
throw;
}
}
public ActionResult UploadFiles()
{
// Checking no of files injected in Request object
try
{
int devicekey = Convert.ToInt32(Request.Form["deviceKey"]);
String paths = Server.MapPath("~/Uploads"); //Path
//Check if directory exist
if (!System.IO.Directory.Exists(paths))
{
Directory.CreateDirectory(paths); //Create directory if it doesn't exist
}
Boolean isCapture = Convert.ToBoolean(Request.Form["iscapture"]);
if (isCapture)
{
string base64image = Request.Form["CameraImage"].ToString();
var t = base64image.Substring(23);
var randomFileName = Guid.NewGuid().ToString().Substring(0, 4) + ".png";
string imgPath = Path.Combine(paths, randomFileName);
string filePath = "/Uploads/" + randomFileName;
byte[] bytes = Convert.FromBase64String(t);
System.IO.File.WriteAllBytes(imgPath, bytes);
using (MOBILESHOPEntities dbcontext = new MOBILESHOPEntities())
{
mb_device_images images = new mb_device_images()
{
device_id = devicekey,
image_path = filePath
};
dbcontext.mb_device_images.Add(images);
dbcontext.SaveChanges();
};
}
if (Request.Files.Count > 0)
{
// Get all files from Request object
HttpFileCollectionBase files = Request.Files;
for (int i = 0; i < files.Count; i++)
{
HttpPostedFileBase file = files[i];
string fname;
// Checking for Internet Explorer
if (Request.Browser.Browser.ToUpper() == "IE" || Request.Browser.Browser.ToUpper() == "INTERNETEXPLORER")
{
string[] testfiles = file.FileName.Split(new char[] { '\\' });
fname = testfiles[testfiles.Length - 1];
}
else
{
fname = Guid.NewGuid() + file.FileName;
}
string filePath = "/Uploads/" + fname;
// Get the complete folder path and store the file inside it.
fname = Path.Combine(Server.MapPath("~/Uploads/"), fname);
file.SaveAs(fname);
using (MOBILESHOPEntities dbcontext = new MOBILESHOPEntities())
{
mb_device_images images = new mb_device_images()
{
device_id = devicekey,
image_path = filePath
};
dbcontext.mb_device_images.Add(images);
dbcontext.SaveChanges();
};
}
// Returns message that successfully uploaded
return(Json("File Uploaded Successfully!"));
}
else
{
return(Json("No files selected."));
}
}
catch (Exception ex)
{
return(Json("Error occurred. Error details: " + ex.Message));
}
}
public ActionResult AddCustomer(CustomerDTO dto)
{
try
{
DateTime submitDate = DateTime.ParseExact(dto.datetime, "MM/dd/yyyy h:mm tt", null);
DateTime deliverDate = DateTime.ParseExact(dto.datetime, "MM/dd/yyyy h:mm tt", null);
DateTime?receiveDate = null;
if (dto.receivedDate != null && dto.receivedDate != "")
{
receiveDate = (DateTime.ParseExact(dto.receivedDate, "MM/dd/yyyy h:mm tt", null));
}
using (MOBILESHOPEntities dbcontext = new MOBILESHOPEntities())
{
if (dto.id == 0)
{
mbshop_customer_details mbshop = new mbshop_customer_details()
{
customer_name = dto.Name,
customer_address = dto.Address,
customer_email = dto.Email,
customer_mobile_number = dto.Mobile
};
dbcontext.mbshop_customer_details.Add(mbshop);
dbcontext.SaveChanges();
int costmerID = mbshop.customer_id;
mbshop_device_detail device = new mbshop_device_detail()
{
device_costumer = costmerID,
device_serial_number = dto.Serial,
device_imei_number_1 = dto.imei_1,
device_imei_number_2 = dto.imei_2,
device_model_key = dto.model,
device_fault_key = dto.fault,
device_date_submitt = submitDate,
device_description = dto.Description,
device_deliver_date = deliverDate,
device_repairing_cost = dto.repairingCost,
device_customer_signature = dto.customerSignature,
};
dbcontext.mbshop_device_detail.Add(device);
dbcontext.SaveChanges();
return(Json(new { key = true, value = "Device Details added successfully", id = device.device_key }, JsonRequestBehavior.AllowGet));
}
else
{
var device = dbcontext.mbshop_device_detail.Find(dto.id);
if (device != null)
{
device.device_customer_signature = dto.customerSignature;
device.device_date_submitt = submitDate;
device.device_deliver_date = deliverDate;
device.device_description = dto.Description;
device.device_serial_number = dto.Serial;
device.device_imei_number_1 = dto.imei_1;
device.device_imei_number_2 = dto.imei_2;
device.device_model_key = dto.model;
device.device_fault_key = dto.fault;
device.device_repairing_cost = dto.repairingCost;
device.device_customer_signature = dto.customerSignature;
device.device_receiver_signature = dto.receivedSignature;
device.device_receiver_name = dto.receivedName;
device.device_receiving_date = receiveDate;
device.device_is_delivered = dto.deviceDelivered == 1 ? true : false;
}
dbcontext.SaveChanges();
int customerID = device.device_costumer;
var customer = dbcontext.mbshop_customer_details.Find(customerID);
if (customer != null)
{
customer.customer_name = dto.Name;
customer.customer_address = dto.Address;
customer.customer_email = dto.Email;
customer.customer_mobile_number = dto.Mobile;
dbcontext.SaveChanges();
return(Json(new { key = true, value = "Device Details updated successfully", id = device.device_key }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { key = false, value = "Device Details is not found" }, JsonRequestBehavior.AllowGet));
}
}
};
}
catch (Exception ex)
{
return(Json(new { key = false, value = "Unable to save the Customer" }, JsonRequestBehavior.AllowGet));;
}
}