public IHttpActionResult UpdatePurchaseOrderFile(object obj)
{
try
{
AuthorizationUser AuUser = new AuthorizationUser();
Bis.PurchaseOrderFileMethod BisPurchaseOrderFile = new Bis.PurchaseOrderFileMethod();
JObject JsonObject = JObject.Parse(obj.ToString());
JsonObject.Add("IDPersonel", AuUser.ReturnIDUser(JsonObject["IDLogUser"].ToString().StringToGuid()));
ViewModel.tblPurchaseOrderFile Update = JsonObject.ToObject <ViewModel.tblPurchaseOrderFile>();
bool ret = BisPurchaseOrderFile.UpdatePurchaseOrderFile(Update);
if (ret)
{
return(Ok(ret));
}
else
{
return(NotFound());
}
}
catch
{
return(NotFound());
}
}
public IHttpActionResult ChangeSortInPurchaseOrderFile(object obj)
{
try
{
Bis.PurchaseOrderFileMethod BisPurchaseOrderFile = new Bis.PurchaseOrderFileMethod();
ViewModel.tblPurchaseOrderFile update = new ViewModel.tblPurchaseOrderFile();
update.JsonPurchaseOrderFile = obj.ToString();
bool ret = BisPurchaseOrderFile.UpdateSortInPurchaseOrderFile(update);
return(Ok(ret));
}
catch
{
return(NotFound());
}
}
public IHttpActionResult CheckPartNumberInPurchaseOrderFile(object obj)
{
try
{
Bis.PurchaseOrderFileMethod BisPurchaseOrderFile = new Bis.PurchaseOrderFileMethod();
ViewModel.tblPurchaseOrderFile check = new ViewModel.tblPurchaseOrderFile();
check.JsonPartNumberInFile = obj.ToString();
JArray ret = BisPurchaseOrderFile.CheckPartNumberInPurchaseOrderFile(check);
return(Ok(ret));
}
catch
{
return(NotFound());
}
}
public IHttpActionResult GetPurchaseOrderFileAndDetail(object obj)
{
try
{
Bis.PurchaseOrderFileMethod BisPurchaseorderFile = new Bis.PurchaseOrderFileMethod();
ViewModel.tblPurchaseOrderFile getPurchaseOrderFile = new ViewModel.tblPurchaseOrderFile();
JObject JsonObject = JObject.Parse(obj.ToString());
getPurchaseOrderFile.IDSupplier = JsonObject["IDSupplier"].ToString().StringToGuid();
JArray JsonPurchaseOrderFile = BisPurchaseorderFile.GetPurchaseOrderFileAndDetail(getPurchaseOrderFile);
return(Ok(JsonPurchaseOrderFile));
}
catch
{
return(NotFound());
}
}
public IHttpActionResult UpdateShow(object obj)
{
try
{
Bis.PurchaseOrderFileMethod BisPurchaseOrderFile = new Bis.PurchaseOrderFileMethod();
JObject JsonObject = JObject.Parse(obj.ToString());
ViewModel.tblPurchaseOrderFile Update = JsonObject.ToObject <ViewModel.tblPurchaseOrderFile>();
bool ret = BisPurchaseOrderFile.UpdateShow(Update);
if (ret)
{
return(Ok(ret));
}
else
{
return(NotFound());
}
}
catch
{
return(NotFound());
}
}
public IHttpActionResult DeletePurchaseOrderFile(Object obj)
{
try
{
JObject json = JObject.Parse(obj.ToString());
Bis.PurchaseOrderFileMethod BisPurchaseOrderFile = new Bis.PurchaseOrderFileMethod();
ViewModel.tblPurchaseOrderFile delete = new ViewModel.tblPurchaseOrderFile();
delete.IDPurchaseOrderFile = json["IDPurchaseOrderFile"].ToString().StringToGuid();
bool ret = BisPurchaseOrderFile.DeletePurchaseOrderFile(delete);
if (ret)
{
File.Delete(AppDomain.CurrentDomain.BaseDirectory + json["FileUrl"].ToString());
return(Ok(ret));
}
else
{
return(NotFound());
}
}
catch
{
return(NotFound());
}
}
public bool DeletePurchaseOrderFile(ViewModel.tblPurchaseOrderFile PurchaseOrderFile)
{
return(sqlHelper.RunProcedure("sp_tblPurchaseOrderFile_Delete", PurchaseOrderFile, true) > 0);
}
public bool UpdateShow(ViewModel.tblPurchaseOrderFile PurchaseOrderFile)
{
return(sqlHelper.RunProcedure("sp_tblPurchaseOrderFile_UpdateShow", PurchaseOrderFile) > 0);
}
public bool AddPurchaseOrderFile(ViewModel.tblPurchaseOrderFile PurchaseOrderFile)
{
return(sqlHelper.RunProcedure("sp_tblPurchaseOrderFile_Insert", PurchaseOrderFile, true) > 0);
}
public JArray CheckPartNumberInPurchaseOrderFile(ViewModel.tblPurchaseOrderFile PurchaseOrderFile)
{
return(sqlHelper.ReturnJsonData("sp_tblPurchaseOrderFile_CheckPartNumberInPurchaseOrderFile", PurchaseOrderFile));
}
public JArray GetPurchaseOrderFileAndDetail(ViewModel.tblPurchaseOrderFile PurchaseOrderFile)
{
return(sqlHelper.ReturnJsonData("sp_tblPurchaseOrderFile_GetPurchaseOrderFileAndDetail", PurchaseOrderFile));
}
public IHttpActionResult AddPurchaseOrderFile()
{
AuthorizationUser AuUser = new AuthorizationUser();
Bis.PurchaseOrderFileMethod BisPurchaseOrderFile = new Bis.PurchaseOrderFileMethod();
try
{
var File = HttpContext.Current.Request.Files["excelFileUpload"];
string FileType = File.FileName.Substring(File.FileName.LastIndexOf("."));
var IDPurchaseOrderFile = HttpContext.Current.Request["IDPurchaseOrderFile"];
var IDLogUser = HttpContext.Current.Request["IDLogUser"];
var TitlePurchaseOrderFile = HttpContext.Current.Request["TitlePurchaseOrderFile"];
var IDSupplier = HttpContext.Current.Request["IDSupplier"];
var IDCurrency = HttpContext.Current.Request["IDCurrency"];
var DeliverDate = HttpContext.Current.Request["DeliverDate"];
var ExcelJson = HttpContext.Current.Request["ExcelJson"];
ViewModel.tblPurchaseOrderFile Add = new ViewModel.tblPurchaseOrderFile();
Add.IDPurchaseOrderFile = IDPurchaseOrderFile.ToString().StringToGuid();
Add.IDPersonel = AuUser.ReturnIDUser(IDLogUser.ToString().StringToGuid());
Add.IDSupplier = IDSupplier.ToString().StringToGuid();
Add.IDCurrency = IDCurrency.ToString().StringToGuid();
Add.Title = TitlePurchaseOrderFile.ToString();
if (DeliverDate == "undefined")
{
Add.DeliverDate = "";
}
else
{
Add.DeliverDate = DeliverDate.ToString();
}
Add.FileSize = File.ContentLength; //byte
Add.FileUrl = @"File\AttachCrm\" + Add.IDPurchaseOrderFile + "@" + File.FileName;
Add.ExcelJson = ExcelJson.ToString();
bool ret = BisPurchaseOrderFile.AddPurchaseOrderFile(Add);
if (ret)
{
try
{
File.SaveAs(AppDomain.CurrentDomain.BaseDirectory + Add.FileUrl);
return(Ok(ret));
}
catch (Exception)
{
ViewModel.tblPurchaseOrderFile delete = new ViewModel.tblPurchaseOrderFile();
delete.IDPurchaseOrderFile = Add.IDPurchaseOrderFile;
bool ret2 = BisPurchaseOrderFile.DeletePurchaseOrderFile(delete);
return(NotFound());
}
}
else
{
return(NotFound());
}
}
catch
{
return(NotFound());
}
}
