public ActionResult EditVendor()
{
var SuplierTypes = _capitaContext.SuplierTypes.ToList();
var viewModelVendor = new VendorMasterModel
{
supplierTypes = SuplierTypes
};
return(View(viewModelVendor));
}
public ActionResult Edit(VendorMasterModel vendor)
{
if (vendor.vendorMaster.S_No != 0)
{
var vendorIbDB = _capitaContext.VendorMasters.Single(v => v.S_No == vendor.vendorMaster.S_No);
vendor.vendorMaster.VendorCode = vendor.vendorMaster.VendorName.Substring(0, 4) + "00" + vendor.vendorMaster.SuplierGstNo.Substring(0, 3);
vendorIbDB.VendorName = vendor.vendorMaster.VendorName;
vendorIbDB.VendorCode = vendor.vendorMaster.VendorCode;
vendorIbDB.VendorAddress = vendor.vendorMaster.VendorAddress;
vendorIbDB.SuplierGstNo = vendor.vendorMaster.SuplierGstNo;
vendorIbDB.SuplierTypeId = vendor.vendorMaster.SuplierTypeId;
vendorIbDB.ContactPerson = vendor.vendorMaster.ContactPerson;
vendorIbDB.ContactNo = vendor.vendorMaster.ContactNo;
}
_capitaContext.SaveChanges();
return(RedirectToAction("CreateVendor", "Vendor"));
}
public ActionResult VendorEdit(int id)
{
var vendorEdit = _capitaContext.VendorMasters.SingleOrDefault(v => v.S_No == id);
if (vendorEdit == null)
{
return(HttpNotFound());
}
var vendorVM = new VendorMasterModel
{
vendorMaster = vendorEdit,
supplierTypes = _capitaContext.SuplierTypes.ToList()
};
return(View("EditVendor", vendorVM));
}
public ActionResult CreateVendor(VendorMasterModel vendor)
{
var getRm = _capitaContext.VendorMasters.ToList();
foreach (var item in getRm)
{
if (item.VendorName.Trim().ToLower() == vendor.vendorMaster.VendorName.Trim().ToLower())
{
return(View("VendorExist"));
}
}
if (vendor.vendorMaster.S_No == 0)
{
vendor.vendorMaster.VendorCode = vendor.vendorMaster.VendorName.Substring(0, 4) + "00" + vendor.vendorMaster.SuplierGstNo.Substring(0, 3);
var vendorVM = new VendorMasterModel
{
vendorMaster = vendor.vendorMaster,
supplierTypes = _capitaContext.SuplierTypes.ToList()
};
_capitaContext.VendorMasters.Add(vendor.vendorMaster);
}
else
{
var vendorIbDB = _capitaContext.VendorMasters.Single(v => v.S_No == vendor.vendorMaster.S_No);
vendor.vendorMaster.VendorCode = vendor.vendorMaster.VendorName.Substring(0, 4) + "00" + vendor.vendorMaster.SuplierGstNo.Substring(0, 3);
vendorIbDB.VendorName = vendor.vendorMaster.VendorName;
vendorIbDB.VendorCode = vendor.vendorMaster.VendorCode;
vendorIbDB.VendorAddress = vendor.vendorMaster.VendorAddress;
vendorIbDB.SuplierGstNo = vendor.vendorMaster.SuplierGstNo;
vendorIbDB.SuplierTypeId = vendor.vendorMaster.SuplierTypeId;
vendorIbDB.ContactPerson = vendor.vendorMaster.ContactPerson;
}
_capitaContext.SaveChanges();
return(RedirectToAction("CreateVendor", "Vendor"));
}
public string Update(/*string reqType*/)
{
DanpheHTTPResponse <object> responseData = new DanpheHTTPResponse <object>();
InventoryDbContext inventoryDBContext = new InventoryDbContext(connString);
try
{
//string str = Request.Form.Keys.First<string>();
string str = this.ReadPostData();
string reqType = this.ReadQueryStringData("reqType");
if (!String.IsNullOrEmpty(str))
{
if (reqType == "UpdateVendors")
{
VendorMasterModel vendor = DanpheJSONConvert.DeserializeObject <VendorMasterModel>(str);
inventoryDBContext.Vendors.Attach(vendor);
inventoryDBContext.Entry(vendor).State = EntityState.Modified;
inventoryDBContext.Entry(vendor).Property(x => x.CreatedOn).IsModified = false;
inventoryDBContext.Entry(vendor).Property(x => x.CreatedBy).IsModified = false;
inventoryDBContext.SaveChanges();
responseData.Results = vendor;
responseData.Status = "OK";
}
else if (reqType == "UpdateInventoryTerms")
{
InventoryTermsModel termsconditions = DanpheJSONConvert.DeserializeObject <InventoryTermsModel>(str);
inventoryDBContext.InventoryTerms.Attach(termsconditions);
inventoryDBContext.Entry(termsconditions).State = EntityState.Modified;
inventoryDBContext.Entry(termsconditions).Property(x => x.CreatedOn).IsModified = false;
inventoryDBContext.Entry(termsconditions).Property(x => x.CreatedBy).IsModified = false;
inventoryDBContext.SaveChanges();
responseData.Results = termsconditions;
responseData.Status = "OK";
}
if (reqType == "UpdateItemCategory")
{
ItemCategoryMasterModel itemcategoryModel = DanpheJSONConvert.DeserializeObject <ItemCategoryMasterModel>(str);
inventoryDBContext.ItemCategoryMaster.Attach(itemcategoryModel);
inventoryDBContext.Entry(itemcategoryModel).State = EntityState.Modified;
inventoryDBContext.Entry(itemcategoryModel).Property(x => x.CreatedOn).IsModified = false;
inventoryDBContext.Entry(itemcategoryModel).Property(x => x.CreatedBy).IsModified = false;
inventoryDBContext.SaveChanges();
responseData.Results = itemcategoryModel;
responseData.Status = "OK";
}
if (reqType == "UpdateItemSubCategory")
{
ItemSubCategoryMasterModel itemsubcategoryModel = DanpheJSONConvert.DeserializeObject <ItemSubCategoryMasterModel>(str);
inventoryDBContext.ItemSubCategoryMaster.Attach(itemsubcategoryModel);
inventoryDBContext.Entry(itemsubcategoryModel).State = EntityState.Modified;
inventoryDBContext.Entry(itemsubcategoryModel).Property(x => x.CreatedOn).IsModified = false;
inventoryDBContext.Entry(itemsubcategoryModel).Property(x => x.CreatedBy).IsModified = false;
inventoryDBContext.SaveChanges();
responseData.Results = itemsubcategoryModel;
responseData.Status = "OK";
}
if (reqType == "UpdateUnitOfMeasurement")
{
UnitOfMeasurementMasterModel unitofmeasurementModel = DanpheJSONConvert.DeserializeObject <UnitOfMeasurementMasterModel>(str);
inventoryDBContext.UnitOfMeasurementMaster.Attach(unitofmeasurementModel);
inventoryDBContext.Entry(unitofmeasurementModel).State = EntityState.Modified;
inventoryDBContext.Entry(unitofmeasurementModel).Property(x => x.CreatedOn).IsModified = false;
inventoryDBContext.Entry(unitofmeasurementModel).Property(x => x.CreatedBy).IsModified = false;
inventoryDBContext.SaveChanges();
responseData.Results = unitofmeasurementModel;
responseData.Status = "OK";
}
if (reqType == "UpdatePackagingType")
{
PackagingTypeMasterModel packagingtypeModel = DanpheJSONConvert.DeserializeObject <PackagingTypeMasterModel>(str);
inventoryDBContext.PackagingTypeMaster.Attach(packagingtypeModel);
inventoryDBContext.Entry(packagingtypeModel).State = EntityState.Modified;
inventoryDBContext.Entry(packagingtypeModel).Property(x => x.CreatedOn).IsModified = false;
inventoryDBContext.Entry(packagingtypeModel).Property(x => x.CreatedBy).IsModified = false;
inventoryDBContext.SaveChanges();
responseData.Results = packagingtypeModel;
responseData.Status = "OK";
}
if (reqType == "UpdateAccountHead")
{
AccountHeadMasterModel accountheadModel = DanpheJSONConvert.DeserializeObject <AccountHeadMasterModel>(str);
inventoryDBContext.AccountHeadMaster.Attach(accountheadModel);
inventoryDBContext.Entry(accountheadModel).State = EntityState.Modified;
inventoryDBContext.Entry(accountheadModel).Property(x => x.CreatedOn).IsModified = false;
inventoryDBContext.Entry(accountheadModel).Property(x => x.CreatedBy).IsModified = false;
inventoryDBContext.SaveChanges();
responseData.Results = accountheadModel;
responseData.Status = "OK";
}
if (reqType == "UpdateItem")
{
ItemMasterModel itemModel = DanpheJSONConvert.DeserializeObject <ItemMasterModel>(str);
inventoryDBContext.Items.Attach(itemModel);
inventoryDBContext.Entry(itemModel).State = EntityState.Modified;
inventoryDBContext.Entry(itemModel).Property(x => x.CreatedOn).IsModified = false;
inventoryDBContext.Entry(itemModel).Property(x => x.CreatedBy).IsModified = false;
inventoryDBContext.SaveChanges();
responseData.Results = itemModel;
responseData.Status = "OK";
}
if (reqType == "UpdateCurrency")
{
CurrencyMasterModel currencyModel = DanpheJSONConvert.DeserializeObject <CurrencyMasterModel>(str);
inventoryDBContext.CurrencyMaster.Attach(currencyModel);
inventoryDBContext.Entry(currencyModel).State = EntityState.Modified;
inventoryDBContext.Entry(currencyModel).Property(x => x.CreatedOn).IsModified = false;
inventoryDBContext.Entry(currencyModel).Property(x => x.CreatedBy).IsModified = false;
inventoryDBContext.SaveChanges();
responseData.Results = currencyModel;
responseData.Status = "OK";
}
}
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message + " exception details:" + ex.ToString();
}
return(DanpheJSONConvert.SerializeObject(responseData, true));
}
public string Post()
{
//if reqtype=employee, then use masterdbcontext.employee.add and so on for others.
DanpheHTTPResponse <object> responseData = new DanpheHTTPResponse <object>(); //type 'object' since we have variable return types
responseData.Status = "OK"; //by default status would be OK, hence assigning at the top
InventoryDbContext inventoryDBContext = new InventoryDbContext(connString);
try
{
//string str = Request.Form.Keys.First<string>();
string str = this.ReadPostData();
string reqType = this.ReadQueryStringData("reqType");
string vendorName = this.ReadQueryStringData("vendorName");
int itemId = ToInt(this.ReadQueryStringData("itemId"));
if (reqType == "AddVendors")
{
VendorMasterModel vendorModel = DanpheJSONConvert.DeserializeObject <VendorMasterModel>(str);
vendorModel.CreatedOn = System.DateTime.Now;
inventoryDBContext.Vendors.Add(vendorModel);
inventoryDBContext.SaveChanges();
responseData.Results = vendorModel;
responseData.Status = "OK";
}
else if (reqType == "AddItemCategory")
{
ItemCategoryMasterModel itemcategoryModel = DanpheJSONConvert.DeserializeObject <ItemCategoryMasterModel>(str);
itemcategoryModel.CreatedOn = System.DateTime.Now;
inventoryDBContext.ItemCategoryMaster.Add(itemcategoryModel);
inventoryDBContext.SaveChanges();
responseData.Results = itemcategoryModel;
responseData.Status = "OK";
}
else if (reqType == "AddItemSubCategory")
{
ItemSubCategoryMasterModel itemsubcategoryModel = DanpheJSONConvert.DeserializeObject <ItemSubCategoryMasterModel>(str);
itemsubcategoryModel.CreatedOn = System.DateTime.Now;
inventoryDBContext.ItemSubCategoryMaster.Add(itemsubcategoryModel);
inventoryDBContext.SaveChanges();
responseData.Results = itemsubcategoryModel;
responseData.Status = "OK";
}
//posting to inventory terms & conditions
else if (reqType == "PostInventoryTerms")
{
InventoryTermsModel termsconditions = DanpheJSONConvert.DeserializeObject <InventoryTermsModel>(str);
termsconditions.CreatedOn = System.DateTime.Now;
inventoryDBContext.InventoryTerms.Add(termsconditions);
inventoryDBContext.SaveChanges();
responseData.Results = termsconditions;
responseData.Status = "OK";
}
else if (reqType == "AddUnitOfMeasurement")
{
UnitOfMeasurementMasterModel unitofmeasurementModel = DanpheJSONConvert.DeserializeObject <UnitOfMeasurementMasterModel>(str);
unitofmeasurementModel.CreatedOn = System.DateTime.Now;
inventoryDBContext.UnitOfMeasurementMaster.Add(unitofmeasurementModel);
inventoryDBContext.SaveChanges();
responseData.Results = unitofmeasurementModel;
responseData.Status = "OK";
}
else if (reqType == "AddPackagingType")
{
PackagingTypeMasterModel packagingtypeModel = DanpheJSONConvert.DeserializeObject <PackagingTypeMasterModel>(str);
packagingtypeModel.CreatedOn = System.DateTime.Now;
inventoryDBContext.PackagingTypeMaster.Add(packagingtypeModel);
inventoryDBContext.SaveChanges();
responseData.Results = packagingtypeModel;
responseData.Status = "OK";
}
else if (reqType == "AddAccountHead")
{
AccountHeadMasterModel accountheadModel = DanpheJSONConvert.DeserializeObject <AccountHeadMasterModel>(str);
accountheadModel.CreatedOn = System.DateTime.Now;
inventoryDBContext.AccountHeadMaster.Add(accountheadModel);
inventoryDBContext.SaveChanges();
responseData.Results = accountheadModel;
responseData.Status = "OK";
}
else if (reqType == "AddItem")
{
ItemMasterModel itemModel = DanpheJSONConvert.DeserializeObject <ItemMasterModel>(str);
itemModel.CreatedOn = System.DateTime.Now;
inventoryDBContext.Items.Add(itemModel);
inventoryDBContext.SaveChanges();
responseData.Results = itemModel;
responseData.Status = "OK";
}
else if (reqType == "AddCurrency")
{
CurrencyMasterModel currencyModel = DanpheJSONConvert.DeserializeObject <CurrencyMasterModel>(str);
currencyModel.CreatedOn = System.DateTime.Now;
inventoryDBContext.CurrencyMaster.Add(currencyModel);
inventoryDBContext.SaveChanges();
responseData.Results = currencyModel;
responseData.Status = "OK";
}
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message + " exception details:" + ex.ToString();
}
return(DanpheJSONConvert.SerializeObject(responseData, true));
}
