public string InsertEquipment(ClsEquipment data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
tblEquipment oNewRow = new tblEquipment()
{
idEquipment = (Int32)data.idEquipment,
Equipment = data.Equipment,
CreatedBy = data.CreatedBy,
CreatedOn = (DateTime?)data.CreatedOn,
//UpdatedBy = data.UpdatedBy,
//UpdatedOn = (DateTime?)data.UpdatedOn,
ActiveFlag = data.ActiveFlag
};
puroTouchContext.GetTable <tblEquipment>().InsertOnSubmit(oNewRow);
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
//newID = oNewRow.idTaskType;
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public Equipment_Data(int hardware, string model, string warranty, string warBegin, string warEnd, int state, int person)
{
tblWarranty tblw = new tblWarranty
{
warranty_name = warranty,
warranty_start = warBegin,
warranty_end = warEnd
};
db.tblWarranties.InsertOnSubmit(tblw);
db.SubmitChanges();
tblEquipment tble = new tblEquipment
{
hardware_code = hardware,
equipment_model = model,
warranty_code = tblw.warranty_code,
state_code = state,
equipment_freez = false
};
db.tblEquipments.InsertOnSubmit(tble);
db.SubmitChanges();
tblReport tblr = new tblReport
{
Equimpment_code = tble.equipment_code,
Person_code = person,
Data = DateTime.Now.ToShortDateString()
};
db.tblReports.InsertOnSubmit(tblr);
db.SubmitChanges();
}
public ActionResult CreateEdit(EquipmentModel model)
{
RequestResultModel requestModel = new RequestResultModel();
int returnId = 0;
try
{
if (ModelState.IsValid)
{
if (model.id > 0)
{
var user = oDB.tblEquipments.Where(m => m.id == model.id).FirstOrDefault();
user.Equipment_name = model.Equipment_name;
oDB.Entry(user).State = System.Data.Entity.EntityState.Modified;
oDB.SaveChanges();
returnId = (int)model.id;
}
else
{
tblEquipment equipment = new tblEquipment();
equipment.Equipment_name = model.Equipment_name;
equipment.COntractor_id = SessionManager.ContractorId;
oDB.tblEquipments.Add(equipment);
oDB.SaveChanges();
returnId = (int)equipment.id;
}
requestModel.Title = "Success!";
requestModel.Message = _login.GetMessage("save");
requestModel.InfoType = RequestResultInfoType.Success;
ViewBag.AllEquipments = (from p in oDB.tblEquipments
where p.COntractor_id == SessionManager.ContractorId
select new EquipmentModel
{
id = p.id,
Equipment_name = p.Equipment_name
}).ToList();
return(Json(new
{
returnId = returnId,
NotifyType = NotifyType.PageInline,
Html = this.RenderPartialView(@"_RequestResultPageInlineMessage", requestModel)
}, JsonRequestBehavior.AllowGet));
}
else
{
returnId = (int)model.id;
requestModel.Message = _login.GetValidationErrors();
}
}
catch (Exception)
{
requestModel.Message = _login.GetMessage("error");
}
ViewBag.Action = (model.id > 0) ? "Edit" : "Create";
requestModel.Title = "Error!";
requestModel.InfoType = RequestResultInfoType.ErrorOrDanger;
return(Json(new
{
returnId = returnId,
NotifyType = NotifyType.PageInline,
Html = this.RenderPartialView(@"_RequestResultPageInlineMessage", requestModel)
}, JsonRequestBehavior.AllowGet));
}
