public void UpdateCaseStatus(int _CaseID, int NewStatusID)
{
using (GLBWeb_glbtsEntities ctx = new GLBWeb_glbtsEntities())
{
var singleCase = (from c in ctx.Cases
where c.CaseID == _CaseID
select c).First();
singleCase.StatusID = NewStatusID;
ctx.SaveChanges();
}
}
// CRUD UPDATE => Insert new
public string UpdateComment(int caseNumber, string commentToUpdate)
{
string updatedNotes;
using (var ctx = new GLBWeb_glbtsEntities())
{
var note = (from c in ctx.Cases
where c.CaseID == caseNumber
select c).First();
note.Notes = commentToUpdate;
try
{
ctx.SaveChanges();
}
catch (Exception ex)
{
Exception innerException = ex.InnerException;
throw;
}
updatedNotes = note.Notes;
}
return updatedNotes;
}
public int InsertNewCase()
{
try
{
using (GLBWeb_glbtsEntities ctx = new GLBWeb_glbtsEntities())
{
Case newCase = new Case();
newCase.FirstName = "Dulcie";
newCase.LastName = "Ammini";
newCase.SourceID = 8;
newCase.StatusID = 35;
newCase.SoldCase = false;
/*newCase.Address = " my address";
newCase.TaxProblem = "Unpaid Tax";
newCase.CasemanagerID = 1;
newCase.CaseworkerID = 5;
newCase.SetOfficerID = 1;
newCase.ServiceID = 1;
newCase.ServiceID2 = 2;
newCase.ServiceID3 = 1;
newCase.Source = Source.CreateSource(4);
newCase.MiddleName = "Veluthukaran";
newCase.DOB = DateTime.MaxValue;
newCase.MartialStatus = 2;
newCase.HomePhone = "210-269-6098";
newCase.WorkPhone = "210-269-6098";
newCase.CellPhone = "210-269-6098";
newCase.Fax = "210-269-6098";
newCase.Email = "*****@*****.**";
newCase.BestTimeToCall = "5pm";
newCase.SMS_Perm = true;
newCase.BusinessName = "GLB Tax Service";
newCase.BusinessOwnershipType = 2;
newCase.EmploymentTypeID = 1;
//Business Address
newCase.BusinessAddress = "Business address";
newCase.BusinessCity = "business city";
newCase.BusinessState = "Texas";
//General
newCase.TypeOfWork = "Programmer";
newCase.SignatureTitle = "Developer";
//company information
newCase.CompanyStatus = 1;
newCase.EmployeesPayRoll = 30; */
ctx.Cases.AddObject(newCase);
ctx.SaveChanges();
int caseid = newCase.CaseID;
return caseid;
}
}
catch (Exception ex)
{
throw;
}
}