public JsonResult RelateCustomerVendor([FromBody] dynamic id)
{
try
{
int idCustomer = Convert.ToInt32(id.idCustomer.Value);
int idVendor = Convert.ToInt32(id.idVendor.Value);
var customerVendor = ocmde.CustomerVendor.SingleOrDefault(cv => cv.CustomerId.Equals(idCustomer) && cv.VendorId.Equals(idVendor));
if (customerVendor != null)
{
//Delete relationship
ocmde.CustomerVendor.Remove(customerVendor);
}
else
{
customerVendor = new CustomerVendor()
{
CustomerId = idCustomer,
VendorId = idVendor,
DateCreate = DateTime.Now
};
ocmde.CustomerVendor.Add(customerVendor);
}
ocmde.SaveChanges();
return(Json(new { success = true }));
// return RedirectToAction("EditCustomer", "Customer", new { id = idCustomer});
}
catch (Exception e)
{
throw;
}
}
public bool UpdateAmountDue(string uniqueID)
{
CustomerVendor customerVendor = dataContext.CustomerVendors.First(cus => cus.UniqueID.Equals(uniqueID));
customerVendor.AmountDue = 0;
return(dataContext.SaveChanges() > 0);
}
internal async Task <ResponseModel> SaveCustomerVendor(CustomerVendor source, int loginUserId)
{
ResponseModel response = new ResponseModel();
using (IDbConnection conn = _dbConnection.Connection)
{
DynamicParameters param = new DynamicParameters();
if (source.customervendorid > 0)
{
param.Add("@Id", source.customervendorid, DbType.Int32);
}
param.Add("@Name", source.name.Trim(), DbType.String);
param.Add("@Type", source.type.Trim(), DbType.String);
param.Add("@LoginUserId", loginUserId, DbType.Int32);
var data = await conn.QueryAsync <int>(Constants.StoredProcedure.MANAGECUSTOMERVENDOR, param, null, null, CommandType.StoredProcedure);
int result = 0;
if (data.ToList().Count > 0)
{
result = data.ToList()[0];
}
response.ResultStatus = result;
response.RequestType = Constants.RequestType.POST;
response.SuccessMessage = result == 0 ? string.Empty : "Customer/Vendor saved successfully.";
response.ErrorMessage = result == 0 ? "Error occurred while saving. Please try again." : string.Empty;
}
return(response);
}
public async Task <HttpResponseMessage> SaveCustomerVendor(CustomerVendor source)
{
ResponseModel result = null;
int? loginId = Common.GetLoginId(Request.Headers);
result = await CommonDal.Instance.SaveCustomerVendor(source, Convert.ToInt32(loginId));
return(SendResult(result));
}
public bool UpdateCustomerVendorForConsistency(string uniqueID, int customerID)
{
CustomerVendor cv = dataContext.CustomerVendors.First(cus => cus.UniqueID.Equals(uniqueID));
if (cv != null)
{
cv.CustomerID = customerID;
return(dataContext.SaveChanges() > 0);
}
else
{
return(false);
}
}
