public IHttpActionResult GetQouationDetailByPartNumber(object obj)
{
try
{
Bis.QouationDetailMethod BisQouationDetail = new Bis.QouationDetailMethod();
ViewModel.tblQouationDetail getQouationDetail = new ViewModel.tblQouationDetail();
JObject JsonObject = JObject.Parse(obj.ToString());
getQouationDetail.PartNumber = JsonObject["PartNumber"].ToString();
JArray JsonPurchaseOrder = BisQouationDetail.GetQouationDetailByPartNumber(getQouationDetail);
return(Ok(JsonPurchaseOrder));
}
catch (Exception ex)
{
return(NotFound());
}
}
public IHttpActionResult DeleteSelectedQouationDetail(object obj)
{
try
{
Bis.QouationDetailMethod BisQouationDetail = new Bis.QouationDetailMethod();
ViewModel.tblQouationDetail getQouationDetail = new ViewModel.tblQouationDetail();
JObject JsonObject = JObject.Parse(obj.ToString());
getQouationDetail.ItemsSelected = JsonObject["ItemsSelected"].ToString();
bool JsonQouation = BisQouationDetail.DeleteSelectedQouationDetail(getQouationDetail);
return(Ok(JsonQouation));
}
catch
{
return(NotFound());
}
}
public IHttpActionResult GetSumsColumnsOfQouationDetail(object obj)
{
try
{
Bis.QouationDetailMethod BisQouationDetail = new Bis.QouationDetailMethod();
ViewModel.tblQouationDetail getQouationDetail = new ViewModel.tblQouationDetail();
JObject JsonObject = JObject.Parse(obj.ToString());
getQouationDetail.IDQouationFile = JsonObject["IDQouationFile"].ToString().StringToGuid();
JArray JsonQouation = BisQouationDetail.GetSumsColumnsOfQouationDetail(getQouationDetail);
return(Ok(JsonQouation));
}
catch
{
return(NotFound());
}
}
public IHttpActionResult AddAllQouationDetail(object obj)
{
try
{
AuthorizationUser AuUser = new AuthorizationUser();
Bis.QouationDetailMethod BisQouationDetail = new Bis.QouationDetailMethod();
ViewModel.tblQouationDetail getQouationDetail = new ViewModel.tblQouationDetail();
JObject JsonObject = JObject.Parse(obj.ToString());
getQouationDetail.AllDetailJson = JsonObject["AllDetailJson"].ToString();
getQouationDetail.IDQouationFile = JsonObject["IDQouationFile"].ToString().StringToGuid();
getQouationDetail.IDPersonel = AuUser.ReturnIDUser(JsonObject["IDLogUser"].ToString().StringToGuid());
getQouationDetail.RatioChfToEu = JsonObject["RatioChfToEu"].ToString().StringToDecimal();
bool JsonQouation = BisQouationDetail.AddAllQouationDetail(getQouationDetail);
return(Ok(JsonQouation));
}
catch
{
return(NotFound());
}
}
public bool DeleteSelectedQouationDetail(ViewModel.tblQouationDetail QouationDetail)
{
return(sqlHelper.RunProcedure("sp_tblQouationDetail_DeleteSelectedQouationDetail", QouationDetail) > 0);
}
public bool AddAllQouationDetail(ViewModel.tblQouationDetail QouationDetail)
{
return(sqlHelper.RunProcedure("sp_tblQouationDetail_AddAllQouationDetail", QouationDetail, true) > 0);
}
public JArray GetQouationDetailByPartNumber(ViewModel.tblQouationDetail QouationDetail)
{
return(sqlHelper.ReturnJsonData("sp_tblQouationDetail_GetJsonDataByPartNumber", QouationDetail));
}
public JArray GetSumsColumnsOfQouationDetail(ViewModel.tblQouationDetail QouationDetail)
{
return(sqlHelper.ReturnJsonData("sp_tblQouationDetail_GetSumsColumns", QouationDetail));
}