public IHttpActionResult DeletePeyvastPriceFile(Object obj)
{
try
{
JObject json = JObject.Parse(obj.ToString());
//Bis.PreparationPriceListMethod BisPreparationPriceList = new Bis.PreparationPriceListMethod();
//ViewModel.tblPreparationPriceList getPreparationByPeyvast = new ViewModel.tblPreparationPriceList();
//getPreparationByPeyvast.IDPeyvastPriceFile = json["IDPeyvastPriceFile"].ToString().StringToGuid();
//JArray JsongetPreparationByPeyvast = BisPreparationPriceList.GetPreparationPriceListByIDPeyvastPriceFile(getPreparationByPeyvast);
Bis.PeyvastPriceFileMethod BisPeyvastPrice = new Bis.PeyvastPriceFileMethod();
ViewModel.tblPeyvastPriceFile delete = new ViewModel.tblPeyvastPriceFile();
delete.IDPeyvastPriceFile = json["IDPeyvastPriceFile"].ToString().StringToGuid();
bool ret = BisPeyvastPrice.DeletePeyvastPriceFile(delete);
if (ret)
{
File.Delete(AppDomain.CurrentDomain.BaseDirectory + json["FileUrlExcel"].ToString());
return(Ok(ret));
}
else
{
return(NotFound());
}
}
catch
{
return(NotFound());
}
}
public IHttpActionResult UpdatePeyvastPriceFile(object obj)
{
try
{
AuthorizationUser AuUser = new AuthorizationUser();
Bis.PeyvastPriceFileMethod BisPeyvastPrice = new Bis.PeyvastPriceFileMethod();
JObject JsonObject = JObject.Parse(obj.ToString());
JsonObject.Add("IDPersonel", AuUser.ReturnIDUser(JsonObject["IDLogUser"].ToString().StringToGuid()));
ViewModel.tblPeyvastPriceFile Update = JsonObject.ToObject <ViewModel.tblPeyvastPriceFile>();
bool ret = BisPeyvastPrice.UpdatePeyvastPriceFile(Update);
if (ret)
{
return(Ok(ret));
}
else
{
return(NotFound());
}
}
catch
{
return(NotFound());
}
}
public IHttpActionResult AddPeyvastPriceFile()
{
AuthorizationUser AuUser = new AuthorizationUser();
Bis.PeyvastPriceFileMethod BisPeyvastPrice = new Bis.PeyvastPriceFileMethod();
try
{
var File = HttpContext.Current.Request.Files["excelFileUploadPeyvastPrice"];
string FileType = File.FileName.Substring(File.FileName.LastIndexOf("."));
var IDPeyvastPriceFile = HttpContext.Current.Request["IDPeyvastPriceFile"];
var IDLogUser = HttpContext.Current.Request["IDLogUser"];
var TitlePeyvastPrice = HttpContext.Current.Request["TitlePeyvastPrice"];
var IDSupplier = HttpContext.Current.Request["IDSupplier"];
var IDCurrency = HttpContext.Current.Request["IDCurrency"];
var OrigDate = HttpContext.Current.Request["OrigDate"];
var ExcelJsonPeyvastPrice = HttpContext.Current.Request["ExcelJsonPeyvastPrice"];
ViewModel.tblPeyvastPriceFile Add = new ViewModel.tblPeyvastPriceFile();
Add.IDPeyvastPriceFile = IDPeyvastPriceFile.ToString().StringToGuid();
Add.IDPersonel = AuUser.ReturnIDUser(IDLogUser.ToString().StringToGuid());
Add.IDSupplier = IDSupplier.ToString().StringToGuid();
Add.IDCurrency = IDCurrency.ToString().StringToGuid();
Add.Title = TitlePeyvastPrice.ToString();
Add.OrigDate = OrigDate.ToString().StringToDateTime();
Add.FileSizeExcel = File.ContentLength; //byte
Add.FileUrlExcel = @"File\AttachCrm\" + Add.IDPeyvastPriceFile + "@" + File.FileName;
Add.ExcelJsonPeyvastPrice = ExcelJsonPeyvastPrice.ToString();
bool ret = BisPeyvastPrice.AddPeyvastPriceFile(Add);
if (ret)
{
try
{
File.SaveAs(AppDomain.CurrentDomain.BaseDirectory + Add.FileUrlExcel);
return(Ok(ret));
}
catch (Exception)
{
ViewModel.tblPeyvastPriceFile delete = new ViewModel.tblPeyvastPriceFile();
delete.IDPeyvastPriceFile = Add.IDPeyvastPriceFile;
bool ret2 = BisPeyvastPrice.DeletePeyvastPriceFile(delete);
return(NotFound());
}
}
else
{
return(NotFound());
}
}
catch
{
return(NotFound());
}
}
public IHttpActionResult ChangeSortInPeyvastFile(object obj)
{
try
{
Bis.PeyvastPriceFileMethod BisPeyvastFile = new Bis.PeyvastPriceFileMethod();
ViewModel.tblPeyvastPriceFile update = new ViewModel.tblPeyvastPriceFile();
update.JsonPeyvastFile = obj.ToString();
bool ret = BisPeyvastFile.ChangeSortInPeyvastFile(update);
return(Ok(ret));
}
catch
{
return(NotFound());
}
}
public IHttpActionResult CheckPartNumberInPeyvastPriceFile(object obj)
{
try
{
Bis.PeyvastPriceFileMethod BisPeyvastPriceFile = new Bis.PeyvastPriceFileMethod();
ViewModel.tblPeyvastPriceFile check = new ViewModel.tblPeyvastPriceFile();
check.JsonPartNumberInFile = obj.ToString();
JArray ret = BisPeyvastPriceFile.CheckPartNumberInPeyvastPriceFile(check);
return(Ok(ret));
}
catch
{
return(NotFound());
}
}
public IHttpActionResult GetStockValuePeyvast(object obj)
{
try
{
Bis.PeyvastPriceFileMethod BisPeyvastPrice = new Bis.PeyvastPriceFileMethod();
ViewModel.tblPeyvastPriceFile getPeyvastPrice = new ViewModel.tblPeyvastPriceFile();
JObject JsonObject = JObject.Parse(obj.ToString());
getPeyvastPrice.IDSupplier = JsonObject["IDSupplier"].ToString().StringToGuid();
JArray JsonPeyvastPrice = BisPeyvastPrice.GetStockValuePeyvast(getPeyvastPrice);
return(Ok(JsonPeyvastPrice));
}
catch
{
return(NotFound());
}
}
public IHttpActionResult UpdateRaioPeyvastPriceFile(object obj)
{
try
{
Bis.PeyvastPriceFileMethod BisPeyvastPriceFile = new Bis.PeyvastPriceFileMethod();
JObject JsonObject = JObject.Parse(obj.ToString());
ViewModel.tblPeyvastPriceFile Update = JsonObject.ToObject <ViewModel.tblPeyvastPriceFile>();
bool ret = BisPeyvastPriceFile.UpdateRatioPeyvastPriceFile(Update);
if (ret)
{
return(Ok(ret));
}
else
{
return(NotFound());
}
}
catch
{
return(NotFound());
}
}