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);
