public HttpResponseMessage SavePOSpecificTandC(TEPOSpecificTCDetail specTC)
{
try
{
string temp = string.Empty;
temp = specTC.Description.Trim();
specTC.IsDeleted = false;
specTC.LastModifiedOn = DateTime.Now;
specTC.CreatedOn = DateTime.Now;
specTC.Description = temp.Replace("<br/>", "").Replace("<br>", "");
specTC.SpecificTCTitleMasterId = specTC.SpecificTCTitleMasterId;
db.TEPOSpecificTCDetails.Add(specTC);
db.SaveChanges();
sinfo.errorcode = 0;
sinfo.errormessage = "Successfully Saved";
return(new HttpResponseMessage()
{
Content = new JsonContent(new { info = sinfo })
});
}
catch (Exception ex)
{
ExceptionObj.RecordUnHandledException(ex);
sinfo.errorcode = 1;
sinfo.errormessage = "Fail To Save";
return(new HttpResponseMessage()
{
Content = new JsonContent(new { info = sinfo })
});
}
}
public HttpResponseMessage UpdatePOSpecificTandC(TEPOSpecificTCDetail specTC)
{
try
{
String temp = specTC.Description;
specTC.Description = temp.Replace("<br/>", "").Replace("<br>", "");
TEPOSpecificTCDetail specTCExist = new TEPOSpecificTCDetail();
specTCExist = db.TEPOSpecificTCDetails.Where(a => a.IsDeleted == false && a.SpecificTCId == specTC.SpecificTCId).FirstOrDefault();
if (specTCExist != null)
{
specTCExist.Description = specTC.Description;
specTCExist.LastModifiedOn = DateTime.Now;
specTCExist.SpecificTCSubTitleMasterId = specTC.SpecificTCSubTitleMasterId;
specTCExist.SpecificTCTitleMasterId = specTC.SpecificTCTitleMasterId;
db.Entry(specTCExist).CurrentValues.SetValues(specTCExist);
db.SaveChanges();
sinfo.errorcode = 0;
sinfo.errormessage = "Successfully Updated";
return(new HttpResponseMessage()
{
Content = new JsonContent(new { info = sinfo })
});
}
else
{
sinfo.errorcode = 0;
sinfo.errormessage = "Unable to Update";
return(new HttpResponseMessage()
{
Content = new JsonContent(new { info = sinfo })
});
}
}
catch (Exception ex)
{
ExceptionObj.RecordUnHandledException(ex);
sinfo.errorcode = 1;
sinfo.errormessage = "Fail To Update";
return(new HttpResponseMessage()
{
Content = new JsonContent(new { info = sinfo })
});
}
}
public HttpResponseMessage DeletePOSpecificTandC(TEPOSpecificTCTitleMaster specTitleTC)
{
try
{
var specTCListIds = (from tcDetail in db.TEPOSpecificTCDetails
join subtitle in db.TEPOSpecificTCSubTitleMasters on tcDetail.SpecificTCSubTitleMasterId equals subtitle.SpecificTCSubTitleMasterId
where subtitle.SpecificTCTitleMasterId == specTitleTC.SpecificTCTitleMasterId && subtitle.IsDeleted == false
select new { tcDetail.SpecificTCId }).ToList();
foreach (var specData in specTCListIds)
{
TEPOSpecificTCDetail specTCExist = new TEPOSpecificTCDetail();
specTCExist = db.TEPOSpecificTCDetails.Where(a => a.IsDeleted == false && a.SpecificTCId == specData.SpecificTCId).FirstOrDefault();
if (specTCExist != null)
{
specTCExist.LastModifiedOn = DateTime.Now;
specTCExist.IsDeleted = true;
db.Entry(specTCExist).CurrentValues.SetValues(specTCExist);
db.SaveChanges();
}
else
{
//sinfo.errorcode = 0;
//sinfo.errormessage = "Unable to Delete";
//return new HttpResponseMessage() { Content = new JsonContent(new { info = sinfo }) };
}
}
}
catch (Exception ex)
{
ExceptionObj.RecordUnHandledException(ex);
sinfo.errorcode = 1;
sinfo.errormessage = "Fail To Delete";
return(new HttpResponseMessage()
{
Content = new JsonContent(new { info = sinfo })
});
}
sinfo.errorcode = 0;
sinfo.errormessage = "Successfully Deleted";
return(new HttpResponseMessage()
{
Content = new JsonContent(new { info = sinfo })
});
}
public HttpResponseMessage DeletePOSpecificTandC_SingleDelete(TEPOSpecificTCDetail specTC)
{
try
{
TEPOSpecificTCDetail specTCExist = new TEPOSpecificTCDetail();
specTCExist = db.TEPOSpecificTCDetails.Where(a => a.IsDeleted == false && a.SpecificTCId == specTC.SpecificTCId).FirstOrDefault();
// specTCExist = db.TEPOSpecificTCDetails.Where(a => a.IsDeleted == false && a.SpecificTCId == specTC.SpecificTCSubTitleMasterId).FirstOrDefault();
if (specTCExist != null)
{
specTCExist.LastModifiedOn = DateTime.Now;
specTCExist.IsDeleted = true;
db.Entry(specTCExist).CurrentValues.SetValues(specTCExist);
db.SaveChanges();
sinfo.errorcode = 0;
sinfo.errormessage = "Successfully Deleted";
return(new HttpResponseMessage()
{
Content = new JsonContent(new { info = sinfo })
});
}
else
{
sinfo.errorcode = 0;
sinfo.errormessage = "Unable to Delete";
return(new HttpResponseMessage()
{
Content = new JsonContent(new { info = sinfo })
});
}
}
catch (Exception ex)
{
ExceptionObj.RecordUnHandledException(ex);
sinfo.errorcode = 1;
sinfo.errormessage = "Fail To Delete";
return(new HttpResponseMessage()
{
Content = new JsonContent(new { info = sinfo })
});
}
}