private Boolean Save()
{
try
{
var x = new order_hiv_rapid_test_kit_PhysicalCount
{
FacilityCode = mFacilityCode,
DateOfPhysicalCount = mDateOfPhysicalCount,
// string Expiry_Date = temp.ExpiryDate.ToString();
//DateTime ExpiryTime = DateTime.Parse(Expiry_Date);
//obj.ExpiryDate = ExpiryTime;
product_code = mproduct_code,
BatchNo = mBatchNo,
Quantity_Dispensary = mQuantity_Dispensary,
Quantity_Store = mQuantity_Store,
ExpiryDate = mExpiryDate,
Total = (mQuantity_Dispensary + mQuantity_Store),
Comment = mComment,
AddedBy = new UserManagement().getCurrentuser(),
DateAdded = DateTime.Now,
record_status = true
};
context.order_hiv_rapid_test_kit_PhysicalCount.Add(x);
context.SaveChanges();
return(true);
}
//catch (Exception x)
//{
// throw (x);
//}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
public ActionResult BatchUpdateHIV(string key, List <order_hiv_rapid_test_kit_PhysicalCount> changed, List <order_hiv_rapid_test_kit_PhysicalCount> added, List <order_hiv_rapid_test_kit_PhysicalCount> deleted)
{
mascisEntities dbCase = new mascisEntities();
//Performing insert operation
if (added != null && added.Count() > 0)
{
foreach (var temp in added)
{
string iDate = temp.DateOfPhysicalCount.ToString();
DateTime oDate = DateTime.Parse(iDate);
temp.DateOfPhysicalCount = oDate;
order_hiv_rapid_test_kit_PhysicalCount old = dbCase.order_hiv_rapid_test_kit_PhysicalCount.
FirstOrDefault(o => o.FacilityCode == temp.FacilityCode && o.DateOfPhysicalCount == temp.DateOfPhysicalCount && o.product_code == temp.product_code && o.BatchNo == temp.BatchNo);
if (old != null)
{
dbCase.order_hiv_rapid_test_kit_PhysicalCount.Add(temp);
temp.Total = temp.Quantity_Dispensary + temp.Quantity_Store;
temp.DateAdded = DateTime.Now;
temp.AddedBy = new UserManagement().getCurrentuser();
temp.record_status = true;
}
else
{
dbCase.order_hiv_rapid_test_kit_PhysicalCount.Add(temp);
temp.Total = temp.Quantity_Dispensary + temp.Quantity_Store;
temp.DateAdded = DateTime.Now;
temp.AddedBy = new UserManagement().getCurrentuser();
temp.record_status = true;
}
}
}
//dbCase.SaveChanges();
if (changed != null && changed.Count() > 0)
{
foreach (var temp in changed)
{
string iDate = temp.DateOfPhysicalCount.ToString();
DateTime oDate = DateTime.Parse(iDate);
temp.DateOfPhysicalCount = oDate;
order_hiv_rapid_test_kit_PhysicalCount old = dbCase.order_hiv_rapid_test_kit_PhysicalCount.
FirstOrDefault(o => o.FacilityCode == temp.FacilityCode && o.DateOfPhysicalCount == temp.DateOfPhysicalCount && o.product_code == temp.product_code && o.BatchNo == temp.BatchNo);
if (old != null)
{
dbCase.Entry(old).CurrentValues.SetValues(temp);
temp.Total = temp.Quantity_Dispensary + temp.Quantity_Store;
temp.DateAdded = DateTime.Now;
temp.AddedBy = new UserManagement().getCurrentuser();
temp.record_status = true;
}
else
{
dbCase.order_hiv_rapid_test_kit_PhysicalCount.Add(temp);
temp.Total = temp.Quantity_Dispensary + temp.Quantity_Store;
temp.DateAdded = DateTime.Now;
temp.AddedBy = new UserManagement().getCurrentuser();
temp.record_status = true;
}
}
}
//dbCase.SaveChanges();
//Performing delete operation
if (deleted != null && deleted.Count() > 0)
{
foreach (var temp in deleted)
{
dbCase.order_hiv_rapid_test_kit_PhysicalCount.Remove(dbCase.order_hiv_rapid_test_kit_PhysicalCount.FirstOrDefault(o => o.FacilityCode == temp.FacilityCode && o.DateOfPhysicalCount == temp.DateOfPhysicalCount && o.product_code == temp.product_code && o.BatchNo == temp.BatchNo));
}
}
dbCase.SaveChanges();
return(RedirectToAction("BatchDataHIV"));
//var data = 0;
//return Json(data, JsonRequestBehavior.AllowGet);
}
//public ActionResult BatchDataKount(DataManager dataManager)
//{
// IEnumerable DataSource = context.WebTemplate_ARV_PhysicalCount.ToList();
// DataResult result = new DataResult();
// result.result = DataSource;
// result.count = context.WebTemplate_ARV_PhysicalCount.Count();
// return Json(result.count, JsonRequestBehavior.AllowGet);
//}
public int SavePC(int FacilityCode, DateTime DateOfPhysicalCount, int product_code, string BatchNo,
string Quantity_Dispensary, string Quantity_Store, DateTime?ExpiryDate, string Total, string Comment)
{
order_hiv_rapid_test_kit_PhysicalCount obj = new order_hiv_rapid_test_kit_PhysicalCount();
int recstat = 0;
obj.FacilityCode = FacilityCode;
obj.DateOfPhysicalCount = DateOfPhysicalCount;
obj.product_code = System.Convert.ToInt32(product_code);
obj.BatchNo = BatchNo;
if (Quantity_Dispensary != null && !string.IsNullOrEmpty(Quantity_Dispensary))
{
obj.Quantity_Dispensary = System.Convert.ToDouble(Quantity_Dispensary);
}
if (Quantity_Store != null && !string.IsNullOrEmpty(Quantity_Store))
{
obj.Quantity_Store = System.Convert.ToDouble(Quantity_Store);
}
obj.ExpiryDate = ExpiryDate;
if (Total != null && !string.IsNullOrEmpty(Total))
{
obj.Total = System.Convert.ToDouble(Total);
}
obj.Comment = Comment;
try
{
//Check for the existance of the record
var ca = context.order_hiv_rapid_test_kit_PhysicalCount.FirstOrDefault(c => c.FacilityCode == FacilityCode && c.DateOfPhysicalCount == DateOfPhysicalCount && c.product_code == product_code && c.BatchNo == BatchNo);
if (ca == null)
{
context.order_hiv_rapid_test_kit_PhysicalCount.Add(obj);
obj.DateAdded = DateTime.Now;
obj.AddedBy = new UserManagement().getCurrentuser();
recstat = context.SaveChanges();
// recstat = obj.household_number;
}
else
{
order_hiv_rapid_test_kit_PhysicalCount table = context.order_hiv_rapid_test_kit_PhysicalCount.FirstOrDefault(c => c.FacilityCode == FacilityCode && c.DateOfPhysicalCount == DateOfPhysicalCount && c.product_code == product_code && c.BatchNo == BatchNo);
// obj.household_number = ca.household_number ;
context.Entry(table).CurrentValues.SetValues(obj);
obj.DateAdded = DateTime.Now;
obj.AddedBy = new UserManagement().getCurrentuser();
context.Entry(table).State = EntityState.Modified;
recstat = context.SaveChanges();
//recstat = ca.household_number;
}
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
return(recstat);
}
