public Boolean nullCheck(activitystatus activitystatus) { Boolean status = false; if(activitystatus == null) status = true; else { if (activitystatus.status == null || activitystatus.status == "") { status = true; } else status = false; } return status; }
public void saveOrUpdateActivityStatus(string caseid, string activity, string status) { activitystatus actstatus = null; try { dbDataContext ct = new dbDataContext(); //retrieve existing activity status var queryActivityStatus = from actst in ct.activitystatus where actst.caseid == caseid && actst.activity == activity select actst; foreach (activitystatus a in queryActivityStatus) { actstatus = a; } if (actstatus == null) { //adding new status activitystatus actStatus = new activitystatus(); actStatus.caseid = caseid; actStatus.activity = activity; actStatus.status = status; ct.activitystatus.InsertOnSubmit(actStatus); } else { //update activity status actstatus.status = status; } ct.SubmitChanges(); } catch (Exception e) { string str = e.Message; } }
partial void Updateactivitystatus(activitystatus instance);
partial void Deleteactivitystatus(activitystatus instance);
partial void Insertactivitystatus(activitystatus instance);