public ReturnValueInfo DeleteRecord(ProjectStopReason_pjsr_Info reasonInfo)
{
ReturnValueInfo returnInfo = new ReturnValueInfo(false);
if (reasonInfo != null)
{
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
ProjectStopReason_pjsr deleteData = db.ProjectStopReason_pjsr.FirstOrDefault(t => t.pjsr_RecordID == reasonInfo.pjsr_RecordID);
if (deleteData != null)
{
db.ProjectStopReason_pjsr.DeleteOnSubmit(deleteData);
db.SubmitChanges();
returnInfo.boolValue = true;
}
}
}
catch (Exception Ex)
{
returnInfo.messageText = Ex.Message;
}
}
return returnInfo;
}
public Model.General.ReturnValueInfo DeleteRecord(ProjectStopReason_pjsr_Info reasonInfo)
{
throw new NotImplementedException();
}
public ReturnValueInfo UpdateRecord_Sqlite(ProjectStopReason_pjsr_Info reasonInfo)
{
throw new NotImplementedException();
//try
//{
// return this._IProjectStopReasonDA_Sqlite.Update(reasonInfo);
//}
//catch (Exception ex)
//{
// throw ex;
//}
}
public List<ProjectStopReason_pjsr_Info> SearchRecord_Sqlite(ProjectStopReason_pjsr_Info searchInfo)
{
throw new NotImplementedException();
//try
//{
// Dictionary<string, object> param = new Dictionary<string, object>();
// if (searchInfo.pjsr_RecordID != Guid.Empty)
// {
// param.Add("pjsr_RecordID", searchInfo.pjsr_RecordID);
// }
// if (searchInfo.pjsr_PSRDID != Guid.Empty)
// {
// param.Add("pjsr_PSRDID", searchInfo.pjsr_PSRDID);
// }
// if (searchInfo.pjsr_iSRMID != Common.DefineConstantValue.Int32DefaultValue)
// {
// param.Add("pjsr_iSRMID", searchInfo.pjsr_iSRMID);
// }
// if (searchInfo.pjsr_lSync)
// {
// param.Add("pjsr_lSync", searchInfo.pjsr_lSync);
// }
// IList<ProjectStopReason_pjsr_Info> listResonRecords = this._IProjectStopReasonDA_Sqlite.GetEntities<ProjectStopReason_pjsr_Info>(param);
// return listResonRecords.ToList();
//}
//catch (Exception ex)
//{
// throw ex;
//}
}
public ProjectStopReason_pjsr_Info SearchRecord_Sqlite(Guid iRecordID)
{
try
{
ProjectStopReason_pjsr_Info searchInfo = new ProjectStopReason_pjsr_Info();
searchInfo.pjsr_RecordID = iRecordID;
IList<ProjectStopReason_pjsr_Info> IPjsrList = SearchRecord_Sqlite(searchInfo);
ProjectStopReason_pjsr_Info pjsrInfo = new ProjectStopReason_pjsr_Info();
if (IPjsrList != null)
{
pjsrInfo = IPjsrList.FirstOrDefault();
}
else
{
pjsrInfo = null;
}
return pjsrInfo;
}
catch (Exception ex)
{
throw ex;
}
}
public ReturnValueInfo InsertRecord(ProjectStopReason_pjsr_Info reasonInfo)
{
ReturnValueInfo returnInfo = new ReturnValueInfo(false);
if (reasonInfo != null)
{
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
ProjectStopReason_pjsr insertData = Common.General.CopyObjectValue<ProjectStopReason_pjsr_Info, ProjectStopReason_pjsr>(reasonInfo);
db.ProjectStopReason_pjsr.InsertOnSubmit(insertData);
db.SubmitChanges();
reasonInfo.pjsr_RecordID = insertData.pjsr_RecordID;
returnInfo.boolValue = true;
}
}
catch (Exception Ex)
{
returnInfo.messageText = Ex.Message;
}
}
return returnInfo;
}
public ReturnValueInfo UpdateRecord(ProjectStopReason_pjsr_Info reasonInfo)
{
ReturnValueInfo returnInfo = new ReturnValueInfo(false);
if (reasonInfo != null)
{
try
{
using (MainDBDataContext db = new MainDBDataContext())
{
ProjectStopReason_pjsr updateData = db.ProjectStopReason_pjsr.FirstOrDefault(t => t.pjsr_RecordID == reasonInfo.pjsr_RecordID);
if (updateData != null)
{
updateData.pjsr_PSRDID = reasonInfo.pjsr_PSRDID;
updateData.pjsr_iSRMID = reasonInfo.pjsr_iSRMID;
updateData.pjsr_dLastDate = reasonInfo.pjsr_dLastDate;
db.SubmitChanges();
returnInfo.boolValue = true;
}
}
}
catch (Exception Ex)
{
returnInfo.messageText = Ex.Message;
}
}
return returnInfo;
}
public List<ProjectStopReason_pjsr_Info> SearchRecords(ProjectStopReason_pjsr_Info searchCondition)
{
throw new NotImplementedException();
}
