public JsonResult Create(Insurance model)
{
try
{
if (!ModelState.IsValid)
{
return(Json(new { Result = "ERROR", Message = "Form is not valid! Please correct it and try again." }));
}
var insCount = InsuranceManager.GetCountDuplicate(model.sInsuranceName.Trim());
if (insCount.Count >= 1)
{
return(Json(new { Result = "ERROR", Message = "Item Exists." }));
}
model.dtDateAdd = DateTime.Now;
model.kInsuranceId = Guid.NewGuid();
InsuranceManager.Create(model);
return(Json(new { Result = "OK", Record = model }));
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", Message = ex.Message }));
}
}
public JsonResult Search2(string term)
{
try
{
var items = InsuranceManager.GetBySearch(term.Trim());
return(Json(items.Select(m => new
{
label = m.sInsuranceName
,
m.kInsuranceId
,
m.sInsuranceName
,
m.sAddress1
,
m.sCity
,
m.sZip
,
m.sPhone
,
m.sMobile
,
m.sFax
,
m.sEmailAddress
})
, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", Message = ex.Message }));
}
}
public JsonResult Edit(Insurance model)
{
try
{
if (!ModelState.IsValid)
{
return(Json(new { Result = "ERROR", Message = "Form is not valid! Please correct it and try again." }));
}
Insurance itemFound = InsuranceManager.GetById(model.kInsuranceId);
if (itemFound == null)
{
return(Json(new { Result = "ERROR", Message = "Item Not Found" }));
}
model.dtDateAdd = itemFound.dtDateAdd;
model.dtDateUpdate = DateTime.Now;
InsuranceManager.Edit(model);
return(Json(new { Result = "OK" }));
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", Message = ex.Message }));
}
}
//สรุปรายการซ่อมประจำวัน
public ActionResult ReportDay()
{
ViewBag.ReportList = "first active";
ReportDayViewModel model = new ReportDayViewModel();
model.Report = new ReportDay();
DateTime start = DateTime.Today;
model.DateStart = start.AddYears(543);
DateTime end = DateTime.Today.AddDays(1);
model.DateEnd = Convert.ToDateTime(end.AddYears(543).ToString("MM/dd/yyyy"));
model.Report.Repairs = ReportManager.ReportRepairDay(start);
model.Report.Claims = ReportManager.ReportClaimDay(start);
var workingstatus = WorkingStatusManager.GetAll().Where(m => m.iDefault>=5 && m.iDefault<=7);
model.Report.WorkingStatuies = workingstatus.OrderBy(m => m.iDefault).ToList();
model.Report.Insurances = InsuranceManager.GetAll().OrderBy(m => m.sInsuranceName).ToList();
model.Report.TCStaffs = StaffManager.GetAll().Where(m => m.StaffPosition.sDescription == "ช่าง").OrderBy(m => m.sStaffName).ToList();
model.Report.STCStaffs = StaffManager.GetAll().Where(m => m.StaffPosition.sDescription == "หัวหน้าช่าง").OrderBy(m => m.sStaffName).ToList();
model.Report.QCStaffs = StaffManager.GetAll().Where(m => m.StaffPosition.sDescription == "ฝ่ายตรวจสอบคุณภาพ").OrderBy(m => m.sStaffName).ToList();
ViewBag.ReportHeader = String.Format("รายงานบริการประจำวันที่ {0}", DateExtension.DateThaiFormat(start));
return View(model);
}
public InsuranceOverview()
{
this.InitializeComponent();
this.DataContext = this;
//this.contentControl.Content = new UserControl();
// Get data
InsurManager = new InsuranceManager();
insurances = InsurManager.GetInsurances();
InsuranceTypes = InsurTypeManager.GetTypes();
}
public JsonResult Search(string term)
{
try
{
var items = InsuranceManager.GetBySearch(term);
return(Json(items.Select(m => m.sInsuranceName), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", Message = ex.Message }));
}
}
public JsonResult Delete(Guid kInsuranceId)
{
try
{
//Thread.Sleep(50);
InsuranceManager.Delete(kInsuranceId);
return(Json(new { Result = "OK" }));
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", Message = ex.Message }));
}
}
public ActionResult ReportMonth(ReportMonthViewModel model, FormCollection collection)
{
ViewBag.ReportList = "first active";
DateTime start = model.DateStart;
model.DateStart = start.AddYears(-543);
DateTime end = model.DateEnd;
model.DateEnd = end.AddYears(-543);
model.Report = new ReportMonth();
model.Report.Repairs = ReportManager.ReportRepairMonth(model.DateStart, model.DateEnd);
model.Insurances = InsuranceManager.GetAll().OrderBy(m => m.sInsuranceName).ToList();
ViewBag.ReportHeader = String.Format("สรุปบริการประจำเดือน {0}", DateExtension.DateThaiFormat2(model.DateStart));
return View(model);
}
public ActionResult Edit2(BookingClaimViewModel model, FormCollection collection)
{
try
{
if (model.Claim != null)
{
//initial value
var item_found = ClaimManager.GetById(model.Claim.kClaimId);
#region SAVE EDIT CLAIM BOOKING
//Insurance
model.Insurance.kInsuranceId = item_found.Insurance.kInsuranceId;
InsuranceManager.Edit(model.Insurance);
//Product
model.Product.kProductId = item_found.Product.kProductId;
ProductManager.Edit(model.Product);
//Claim
model.Claim.kClaimId = item_found.kClaimId;
model.Claim.kStaffId = item_found.kStaffId;
model.Claim.kOwnerId = item_found.kOwnerId;
model.Claim.sClaimNo = item_found.sClaimNo;
model.Claim.IsComplete = item_found.IsComplete;
model.Claim.IsRecieved = item_found.IsRecieved;
model.Claim.IsNoCredit = item_found.IsNoCredit;
model.Claim.kInsuranceId = model.Insurance.kInsuranceId;
model.Claim.kProductId = model.Product.kProductId;
model.Claim.dtInsuranceExpire = model.Claim.dtInsuranceExpire.Value.AddYears(-543);
model.Claim.dtDateAdd = item_found.dtDateAdd;
model.Claim.dtDateUpdate = item_found.dtDateUpdate;
ClaimManager.Edit(model.Claim);
#endregion
}
}
catch (Exception ex)
{
return(View("Error"));
}
return(RedirectToAction("Index"));
}
public JsonResult Lists(string jtSearching = null, int jtStartIndex = 0, int jtPageSize = 0, string jtSorting = null)
{
try
{
//Thread.Sleep(200);
var itemCount = InsuranceManager.GetCountByFiltering(jtSearching);
var items = InsuranceManager.GetByFilterings(jtSearching, jtStartIndex, jtPageSize, jtSorting).ToList();
return(Json(new
{
Result = "OK",
Records = items,
TotalRecordCount = itemCount
}, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", Message = ex.Message }));
}
}
//สรุปรายการซ่อมประจำเดือน
public ActionResult ReportMonth()
{
ViewBag.ReportList = "first active";
ReportMonthViewModel model = new ReportMonthViewModel();
model.Report = new ReportMonth();
DateTime start = DateExtension.FirstDayOfMonthFromDateTime(DateTime.Now);
model.DateStart = Convert.ToDateTime(start.AddYears(543).ToString("MM/dd/yyyy"));
DateTime end = DateExtension.LastDayOfMonthFromDateTime(DateTime.Now);
model.DateEnd = Convert.ToDateTime(end.AddYears(543).ToString("MM/dd/yyyy"));
model.Report.Repairs = ReportManager.ReportRepairMonth(start, end);
//model.Report.Claims = ReportManager.ReportClaim(start, end);
model.Insurances = InsuranceManager.GetAll().OrderBy(m => m.sInsuranceName).ToList();
ViewBag.ReportHeader = String.Format("สรุปบริการประจำเดือน {0}", DateExtension.DateThaiFormat2(start));
return View(model);
}
public InsuranceController(ILogger <InsuranceController> logger, InsuranceManager insuranceManager, DogManager dogManager)
{
_logger = logger;
_insuranceManager = insuranceManager;
_dogManager = dogManager;
}
public CompanyInsuranceController()
{
this.insuranceManager = new InsuranceManager();
this.insuranceIt2Manager = new InsuranceIt2Manager();
this.officeServices = Container.Resolve <IOfficeServices>();
}
public CompanyInsuranceController(InsuranceManager insuranceManager, InsuranceIt2Manager insuranceIt2Manager, IOfficeServices officeServices)
{
this.insuranceManager = insuranceManager;
this.insuranceIt2Manager = insuranceIt2Manager;
this.officeServices = officeServices;
}
public ActionResult Create(BookingClaimViewModel model, FormCollection collection)
{
try
{
//initial working status
var workingStatusId = WorkingStatusManager.GetAll().Where(m => m.iDefault == (int)Working.Claiming).SingleOrDefault();
if (model.Product != null)
{
model.Product.Brand = BrandManager.GetById(model.Product.kBrandId);
}
model.Product.ProductType = ProductTypeManager.GetById(model.Product.kProductTypeId);
#region SAVE CUSTOMER
var insCount = InsuranceManager.GetCountDuplicate(model.Insurance.sInsuranceName.Trim());
if (insCount.Count <= 0)
{
Insurance insurance = new Insurance
{
kInsuranceId = Guid.NewGuid(),
sInsuranceName = model.Insurance.sInsuranceName,
sAddress1 = model.Insurance.sAddress1,
sCity = model.Insurance.sCity,
sZip = model.Insurance.sZip,
sPhone = model.Insurance.sPhone,
sMobile = model.Insurance.sMobile,
sFax = model.Insurance.sFax,
sEmailAddress = model.Insurance.sEmailAddress
};
InsuranceManager.Create(insurance);
model.Claim.Insurance = insurance;
}
else
{
model.Claim.Insurance = insCount[0];
}
#endregion
#region SAVE Brand
var brandCount = BrandManager.GetCountDuplicate(model.Product.Brand.sBrandName.Trim());
if (brandCount.Count <= 0)
{
Brand brand = new Brand
{
kBrandId = Guid.NewGuid(),
sBrandName = model.Product.Brand.sBrandName
};
BrandManager.Create(brand);
model.Product.Brand = brand;
}
else
{
model.Product.Brand = brandCount[0];
}
#endregion
#region SAVE Product Type
var productTypeCount = ProductTypeManager.GetCountDuplicate(model.Product.ProductType.sDescription.Trim());
if (productTypeCount.Count <= 0)
{
ProductType productType = new ProductType
{
kProductTypeId = Guid.NewGuid(),
sDescription = model.Product.ProductType.sDescription
};
ProductTypeManager.Create(productType);
model.Product.ProductType = productType;
}
else
{
model.Product.ProductType = productTypeCount[0];
}
#endregion
#region SAVE PRODUCT
var productCount = ProductManager.GetCountDuplicate(
model.Product.sProductName.Trim()
//, model.Product.Brand.sBrandName.Trim()
//, model.Product.ProductType.sDescription.Trim()
);
if (productCount.Count <= 0)
{
Product product = new Product
{
kProductId = Guid.NewGuid(),
kProductTypeId = productTypeCount.SingleOrDefault().kProductTypeId,
kBrandId = brandCount.SingleOrDefault().kBrandId,
sProductName = model.Product.sProductName,
sProductModel = model.Product.sProductModel
};
ProductManager.Create(product);
model.Product = product;
}
else
{
model.Product = productCount[0];
}
#endregion
#region SAVE CLAIM BOOKING
var repair = RepairManager.GetByRepairNo(model.Claim.sRepairNo ?? "");
//initial booking first character
string char_number = CharBooking.C.ToString();
Claim claim = new Claim();
claim.dtDateUpdate = DateTime.Now;
claim.kClaimId = Guid.NewGuid();
claim.kStaffId = (Guid)Membership.GetUser().ProviderUserKey;
claim.kOwnerId = repair.kOwnerId ?? (Guid)Membership.GetUser().ProviderUserKey;
claim.kInsuranceId = model.Claim.Insurance.kInsuranceId;
claim.kProductId = model.Product.kProductId;
claim.sRepairNo = model.Claim.sRepairNo;
claim.sClaimNo = String.Format("{0}{1}", char_number, ClaimNextItemNoManager.GetNextItemNo());
claim.sSerial = model.Claim.sSerial;
if (model.Claim.dtInsuranceExpire != null)
{
claim.dtInsuranceExpire = model.Claim.dtInsuranceExpire.Value.AddYears(-543);
}
model.Claim = claim;
ClaimManager.Create(model.Claim);
ClaimNextItemNoManager.IncreaseNextItemNo();
#region also pdate repair side
repair.dtDateUpdate = DateTime.Now;
repair.kStaffId = (Guid)Membership.GetUser().ProviderUserKey;
RepairManager.Edit(repair);
#endregion
#endregion
#region SAVE REPAIR WORKING STATUS
ClaimStatus claimStatus = new ClaimStatus
{
kClaimStatusId = Guid.NewGuid(),
kWorkingStatusId = workingStatusId.kWorkingStatusId,
kStaffId = (Guid)Membership.GetUser().ProviderUserKey,
kClaimId = model.Claim.kClaimId
};
ClaimStatusManager.Create(claimStatus);
#endregion
#region UPDATE REPAIR WORKING STATUS
if (!String.IsNullOrEmpty(model.Claim.sRepairNo))
{
repair = RepairManager.GetByRepairNo(model.Claim.sRepairNo);
RepairStatus repairStatus = new RepairStatus
{
kRepairStatusId = Guid.NewGuid(),
kWorkingStatusId = workingStatusId.kWorkingStatusId,
kStaffId = (Guid)Membership.GetUser().ProviderUserKey,
kRepairId = repair.kRepairId
};
RepairStatusManager.Create(repairStatus);
}
#endregion
#region SAVE CAUSE OF CLAIM
//initial cause
string keyname;
string keyvalue;
int countvalue = 0;
for (int i = 0; i <= collection.Count - 1; i++)
{
keyname = collection.AllKeys[i];
keyvalue = collection[i];
if (keyname.Contains("cause"))
{
countvalue++;
}
}
if (countvalue > 1)
{
model.ClaimCauses = new List <ClaimCause>();
for (int i = 1; i <= countvalue / 4; i++)
{
ClaimCause claimCause = new ClaimCause();
claimCause.kClaimCauseId = Guid.NewGuid();
claimCause.kClaimId = model.Claim.kClaimId;
claimCause.kStaffId = (Guid)Membership.GetUser().ProviderUserKey;
claimCause.sDescription = collection[String.Format("cause_description_{0}", i)];
claimCause.sNote = collection[String.Format("cause_note_{0}", i)];
if (!String.IsNullOrEmpty(claimCause.sDescription))
{
int qty = 0;
if (int.TryParse(collection[String.Format("cause_qty_{0}", i)], out qty))
{
claimCause.iQty = qty;
}
Decimal price = 0;
if (Decimal.TryParse(collection[String.Format("cause_price_{0}", i)], out price))
{
claimCause.dPrice = price;
}
model.ClaimCauses.Add(claimCause);
ClaimCourseManager.Create(claimCause);
}
}
}
if (model.ClaimCauses != null)
{
foreach (var item in model.ClaimCauses)
{
var causeCount = CauseManager.GetCountDuplicate(item.sDescription.Trim());
if (causeCount <= 0)
{
Cause cause = new Cause
{
kCauseId = Guid.NewGuid(),
sDescription = item.sDescription.Trim()
};
CauseManager.Create(cause);
}
}
}
#endregion
}
catch (Exception ex)
{
return(RedirectToAction("Error", "Home"));
}
Claim model2 = ClaimManager.GetById(model.Claim.kClaimId);
//create remind for history
RemindHistory remind = new RemindHistory
{
sRemind = model2.vMessage,
kStaffId = model2.kStaffId
};
RemindHistoryManager.Create(remind);
var clientName = User.Identity.Name;
Task.Factory.StartNew(() =>
{
var clients = Hub.GetClients <RealTimeJTableDemoHub>();
clients.RecordCreated(clientName, model2);
});
return(RedirectToAction("Index"));
}
public InsuranceController(InsuranceManager insuranceManager)
{
_insuranceManager = insuranceManager;
}
