public JsonResult Submit(int id)
{
ResponeModel response = new ResponeModel(true);
Context.SalesOrder dbItem = RepoSalesOrder.FindByPK(id);
List <Context.DaftarHargaOnCall> dummy = RepoDaftarHarga.FindAll().Where(d => d.IdCust == dbItem.SalesOrderOncall.CustomerId && (dbItem.SalesOrderOncall.TanggalMuat >= d.PeriodStart && dbItem.SalesOrderOncall.TanggalMuat <= d.PeriodEnd)).ToList();
if (dummy.Where(d => d.DaftarHargaOnCallItem.Any(i => i.IdJenisTruck == dbItem.SalesOrderOncall.JenisTruckId)).Count() < 1)
{
response.Success = false;
response.Message = "Tidak terdapat daftar harga untuk jenis truck " + dbItem.SalesOrderOncall.JenisTrucks.StrJenisTruck;
}
else
{
dbItem.Status = "save";
dbItem.isReturn = false;
dbItem.UpdatedBy = UserPrincipal.id;
RepoAuditrail.saveOrderHistory(dbItem);
RepoSalesOrder.save(dbItem);
//{ Nama: "Sales Order", Id: "S" },
//{ Nama: "Planning Order", Id: "P" },
//{ Nama: "Konfirmasi Planning", Id: "KP" },
//{ Nama: "Admin Uang Jalan", Id: "A" },
//{ Nama: "Kasir", Id: "K" }
RepoListNotif.save("P",
"PLANNING SO : " + dbItem.SalesOrderOncall.SONumber + " " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString() + " belum diproses.",
"PLANNING SO : " + dbItem.SalesOrderOncall.SONumber + " " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString() + " belum diproses.");
}
return(Json(response));
}
public string GetUangMakan(string AreaMakan, int idpool, int idjenistruck)
{
ResponeModel response = new ResponeModel();
Decimal UangMakan = 0;
Context.FaktorBorongan dbitem = RepoFaktorBorongan.FindAll().Where(d => d.IdMasterPool == idpool && d.IdJenisTruck == idjenistruck).FirstOrDefault();
if (dbitem != null)
{
//ambil data berdasarkan rasio
if (AreaMakan == "JAWABALI")
{
UangMakan = dbitem.UangMakanJawaBali;
}
else if (AreaMakan == "SUMATRA")
{
UangMakan = dbitem.UangMakanSumatra;
}
response.Success = true;
response.Data = new JavaScriptSerializer().Serialize(new { UangMakan = UangMakan });
}
else
{
response.Success = false;
}
return(new JavaScriptSerializer().Serialize(response));
}
public JsonResult SaveDp(Context.SalesOrderPickupDp model)
{
Context.SalesOrder dbitem = RepoSalesOrder.FindByPickup(model.SalesOrderPickupId);
if (model.Id == 0)
{
dbitem.SalesOrderPickup.SalesOrderPickupDp.Add(model);
var query = "INSERT INTO \"dbo\".\"SalesOrderPickupDp\" (\"SalesOrderPickupId\", \"Tanggal\", \"Penerima\", \"Jenis\", \"RekeningId\", \"Jumlah\") VALUES (" + model.SalesOrderPickupId +
", " + model.Tanggal + ", " + model.Penerima + ", " + model.Jenis + ", " + model.RekeningId + ", " + model.Jumlah + ");";
RepoAuditrail.SetAuditTrail(query, "Input DP", "List Order", UserPrincipal.id);
}
else
{
Context.SalesOrderPickupDp dbdp = dbitem.SalesOrderPickup.SalesOrderPickupDp.Where(d => d.Id == model.Id).FirstOrDefault();
dbdp.Tanggal = model.Tanggal;
dbdp.Penerima = model.Penerima;
dbdp.RekeningId = model.RekeningId;
dbdp.Jenis = model.Jenis;
dbdp.Jumlah = model.Jumlah;
var query = "UPDATE \"dbo\".\"SalesOrderPickupDp\" SET \"Tanggal\" = " + dbdp.Tanggal + ", \"Penerima\" = " + dbdp.Penerima + ", \"Jenis\" = \" = " + dbdp.Jenis +
", \"RekeningId\" = " + dbdp.RekeningId + "\"Jumlah\" = " + dbdp.Jumlah + " WHERE \"Id\" = " + dbdp.Id + ";";
RepoAuditrail.SetAuditTrail(query, "Input DP", "List Order", UserPrincipal.id);
}
RepoSalesOrder.save(dbitem);
ResponeModel response = new ResponeModel(true);
return(Json(response));
}
public JsonResult Delete(List <MasterSolar> models)
{
Context.MasterSolar dbitem = RepoMasterSolar.FindByPK(models[0].Id);
RepoMasterSolar.delete(dbitem);
ResponeModel response = new ResponeModel(true);
return(Json(response));
}
public JsonResult Add(List <MasterSolar> models)
{
Context.MasterSolar dbitem = new Context.MasterSolar();
models[0].setDb(dbitem);
RepoMasterSolar.save(dbitem);
ResponeModel response = new ResponeModel(true);
return(Json(response));
}
public JsonResult Submit(int id)
{
ResponeModel response = new ResponeModel(true);
Context.SalesOrder dbItem = RepoSalesOrder.FindByPK(id);
dbItem.Status = "save";
RepoSalesOrder.save(dbItem);
return(Json(response));
}
public JsonResult Delete(int id)
{
ResponeModel response = new ResponeModel(true);
Context.Mekanik dbItem = RepoMekanik.FindByPK(id);
RepoMekanik.delete(dbItem);
return(Json(response));
}
public JsonResult Delete(int id)
{
ResponeModel response = new ResponeModel(true);
Context.PelaksanaanTraining dbItem = RepoPelaksanaanTraining.FindByPK(id);
dbItem.PelaksanaanTrainingDetail.Clear();
RepoPelaksanaanTraining.delete(dbItem);
return(Json(response));
}
public JsonResult Delete(int id)
{
ResponeModel response = new ResponeModel(true);
Context.PenetapanDriver dbItem = RepoPenetapanDriver.FindByPK(id);
RepoPenetapanDriver.delete(dbItem);
return(Json(response));
}
public JsonResult Delete(int id)
{
ResponeModel response = new ResponeModel(true);
Context.DaftarHargaKontrak dbItem = RepoDHK.FindByPK(id);
RepoDHK.delete(dbItem);
return(Json(response));
}
public JsonResult Submit(int id)
{
ResponeModel response = new ResponeModel(true);
Context.Workshop dbItem = RepoWorkshop.FindByPK(id);
dbItem.Status = "save";
RepoWorkshop.save(dbItem, UserPrincipal.id);
return(Json(response));
}
public JsonResult Delete(int id)
{
ResponeModel response = new ResponeModel(true);
Context.Rekenings dbItem = RepoRekening.FindByPK(id);
RepoRekening.delete(dbItem);
return(Json(response));
}
public JsonResult Delete(int id)
{
ResponeModel response = new ResponeModel(true);
Context.Atm dbItem = RepoAtm.FindByPK(id);
RepoAtm.delete(dbItem, UserPrincipal.id);
return(Json(response));
}
public JsonResult Delete(int id)
{
ResponeModel response = new ResponeModel(true);
Context.AuthorizationRule dbItem = RepoAuthorizationRule.FindByPK(id);
RepoAuthorizationRule.delete(dbItem);
return(Json(response));
}
public JsonResult Delete(int id)
{
ResponeModel response = new ResponeModel(true);
Context.LookupCode dbItem = RepoLookup.FindByPK(id);
RepoLookup.delete(dbItem);
return(Json(response));
}
public JsonResult Delete(int id)
{
ResponeModel response = new ResponeModel(true);
Context.FaktorBorongan dbItem = RepoFaktorBorongan.FindByPK(id);
RepoFaktorBorongan.delete(dbItem, UserPrincipal.id);
return(Json(response));
}
public JsonResult Delete(int id)
{
ResponeModel response = new ResponeModel(true);
Context.TrainingSetting dbItem = RepoTrainingSetting.FindByPK(id);
RepoTrainingSetting.delete(dbItem, UserPrincipal.id);
return(Json(response));
}
public JsonResult Delete(int id)
{
ResponeModel response = new ResponeModel(true);
Context.MasterArea dbItem = RepoArea.FindByPK(id);
RepoArea.delete(dbItem);
return(Json(response));
}
public JsonResult Delete(int id)
{
ResponeModel response = new ResponeModel(true);
Context.User dbItem = RepoUser.FindByPK(id);
dbItem.UserRole.Clear();
dbItem.UserMenus.Clear();
RepoUser.delete(dbItem, UserPrincipal.id);
return(Json(response));
}
protected ResponeModel <T> SetResponeData <T>(string message, ResponeStatusEnum status, T data) where T : class
{
var respone = new ResponeModel <T>
{
Message = message,
ResponeStatus = status,
Data = data
};
return(respone);
}
public JsonResult Return(int id)
{
ResponeModel response = new ResponeModel(true);
Context.SalesOrder dbItem = RepoSalesOrder.FindByPK(id);
dbItem.Status = "draft planning";
dbItem.isReturn = true;
RepoSalesOrder.save(dbItem);
return(Json(response));
}
public JsonResult DeleteDp(int IdSo, int id)
{
Context.SalesOrder dbitem = RepoSalesOrder.FindByKontrak(IdSo);
Context.SalesOrderKontrakDp dbdp = dbitem.SalesOrderKontrak.SalesOrderKontrakDp.Where(d => d.Id == id).FirstOrDefault();
dbitem.SalesOrderKontrak.SalesOrderKontrakDp.Remove(dbdp);
ResponeModel response = new ResponeModel(true);
RepoSalesOrder.save(dbitem);
return(Json(response));
}
public JsonResult Delete(int id)
{
ResponeModel response = new ResponeModel(true);
Context.SalesOrder dbItem = RepoSalesOrder.FindByPK(id);
//RepoSalesOrderKontrakListSo.deleteAdd(dbItem.SalesOrderKontrakId);
RepoSalesOrder.delete(dbItem, UserPrincipal.id);
return(Json(response));
}
public string UploadLookUpCode(IEnumerable <HttpPostedFileBase> filesLookUp)
{
ResponeModel response = new ResponeModel();
//algoritma
if (filesLookUp != null)
{
foreach (var file in filesLookUp)
{
try
{
using (var package = new ExcelPackage(file.InputStream))
{
var currentSheet = package.Workbook.Worksheets;
var workSheet = currentSheet.First();
var noOfCol = workSheet.Dimension.End.Column;
var noOfRow = workSheet.Dimension.End.Row;
for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++)
{
if (workSheet.Cells[rowIterator, 1].Value != null || workSheet.Cells[rowIterator, 2].Value != null ||
workSheet.Cells[rowIterator, 3].Value != null || workSheet.Cells[rowIterator, 4].Value != null)
{
string namaKategori = workSheet.Cells[rowIterator, 1].Value.ToString();
int? idKategori = RepoKategori.FindAll().Where(k => k.Category == namaKategori).Select(k => k.Id).FirstOrDefault();
string namaLookUp = RepoLookup.FindAll().Where(l => l.Nama == workSheet.Cells[rowIterator, 2].Value.ToString()).Select(l => l.Nama).FirstOrDefault();
Context.LookupCode dbitem = new Context.LookupCode();
if (idKategori.HasValue && namaLookUp == null && idKategori > 0)
{
dbitem.IdKategori = idKategori.Value;
dbitem.Nama = workSheet.Cells[rowIterator, 2].Value.ToString();
dbitem.Order = int.Parse(workSheet.Cells[rowIterator, 3].Value.ToString());
dbitem.Deskripsi = workSheet.Cells[rowIterator, 4].Value.ToString();
RepoLookup.save(dbitem);
}
}
}
}
response.Success = true;
}
catch (Exception e)
{
response.Success = false;
response.Message = e.Message.ToString();
}
}
}
return(new JavaScriptSerializer().Serialize(new { Response = response }));
}
public JsonResult Submit(int id)
{
ResponeModel response = new ResponeModel(true);
Context.SalesOrder dbItem = RepoSalesOrder.FindByPK(id);
dbItem.Status = "save konfirmasi";
dbItem.isReturn = false;
dbItem.UpdatedBy = UserPrincipal.id;
RepoSalesOrder.save(dbItem);
RepoAuditrail.saveKonfirmasiHistory(dbItem);
return(Json(response));
}
public JsonResult SaveTimeAlert(TimeAlert model)
{
Context.TimeAlert dbitem = new Context.TimeAlert();
if (model.Id != 0)
{
dbitem = RepoTimeAlert.FindByPK(model.Id);
}
model.setDb(dbitem);
RepoTimeAlert.save(dbitem, UserPrincipal.id);
ResponeModel response = new ResponeModel(true);
return(Json(response));
}
public JsonResult DeleteDp(int IdSo, int id)
{
Context.SalesOrder dbitem = RepoSalesOrder.FindByPickup(IdSo);
Context.SalesOrderPickupDp dbdp = dbitem.SalesOrderPickup.SalesOrderPickupDp.Where(d => d.Id == id).FirstOrDefault();
dbitem.SalesOrderPickup.SalesOrderPickupDp.Remove(dbdp);
ResponeModel response = new ResponeModel(true);
var query = "DELETE FROM \"dbo\".\"SalesOrderPickupDp\" WHERE \"Id\"= " + id + ";";
RepoSalesOrder.save(dbitem);
RepoAuditrail.SetAuditTrail(query, "Input DP", "Delete SO Pickup", UserPrincipal.id);
return(Json(response));
}
public ResponeModel saveReference(string act, string contr, string kolom, string HideShow)
{
ResponeModel model = new ResponeModel();
Context.UserReference dbitem = RepoUserReference.find(UserPrincipal.id, act, contr, kolom) != null?RepoUserReference.find(UserPrincipal.id, act, contr, kolom) : new Context.UserReference();
dbitem.Action = act;
dbitem.Controller = contr;
dbitem.Coloumn = kolom;
dbitem.HideShow = HideShow;
dbitem.IdUser = UserPrincipal.id;
RepoUserReference.save(dbitem, UserPrincipal.id);
return(model);
}
public static string CancellingSubscription(string cellPhone, string token)
{
string isCancelled = string.Empty;
string msidsdn = cellPhone;
var model = new ResponeModel();
if (msidsdn.Substring(0, 1) == "0")
{
msidsdn = "+27" + msidsdn.Substring(1);
}
var subscriptionId = BusinessLogic.TokenRepositary.GetSubscriptionId(msidsdn);
if (!String.IsNullOrWhiteSpace(msidsdn))
{
using (var http = new HttpClient())
{
var url = "baseUrl/subscription/{msidsdn}";
http.DefaultRequestHeaders.Add("Authorization", String.Format("Bearer {0}", token));
var response = http.GetAsync(url);
var request = response.Result.Content.ReadAsStringAsync().Result;
JObject jObject = JObject.Parse(request);
model.Success = Convert.ToString(jObject.SelectToken("success"));
model.Error = Convert.ToString(jObject.SelectToken("error"));
if (model.Success == "Successully cancelled subscription with cancellation reason")
{
string message = $"Please note that your subcription was canceled. Customer: {subscriptionId} , Phone Number: {msidsdn}";
var sendMessageResponse = HTMLPosters.SendSMSMessage(cellPhone, message);
if (sendMessageResponse == "Message accepted")
{
var successMessage = model.Success + ", subscription canceled";
BusinessLogic.TokenRepositary.CancelSusbscription(subscriptionId, cellPhone, model.Success, baseUrl);
}
return(isCancelled = model.Success);
}
else
{
var errorMessage = model.Error + " unable to cancel subscription";
BusinessLogic.TokenRepositary.CancelSusbscription(subscriptionId, cellPhone, errorMessage, baseUrl);
return(isCancelled = model.Error);
}
}
}
return(isCancelled);
}
public JsonResult Delete(int id)
{
ResponeModel response = new ResponeModel(true);
if (RepoDataTruck.IsValidDelete(id))
{
Context.DataTruck dbItem = RepoDataTruck.FindByPK(id);
RepoDataTruck.delete(dbItem, UserPrincipal.id);
}
else
{
response.SetFail("Data truck terpasang Box,Gps atau Pendingin, data tidak dapat dihapus.");
}
return(Json(response));
}
