private void btnSaveHotLine_Click(object sender, EventArgs e) { TblConsultantLog cLog = new TblConsultantLog(); cLog.AnswerRef = currentInfo.InfoTitle; cLog.ClientCode = currentClient.ClientCode; cLog.ClientID = currentClient.ClientID; cLog.ClientName = currentClient.ClientName; cLog.ConsType = ConsultantType.PhoneCall; cLog.CreateDate = DateTime.Now; cLog.Descriptions = txtSearch.Text; cLog.FinishDate = DateTime.Now; cLog.TargetType = ConsultantType.PhoneCall; cLog.ID = currentClient.ClientCode + currentUser.UserName + DateTime.Now.ToBinary().ToString(); cLog.Question = txtSearch.Text; cLog.Status = ConsultantStatus.OK; cLog.TargetCount = 1; cLog.UserID = currentUser.UserID; cLog.UserName = currentUser.UserName; FrmSaveHotline frmSaveHotLine = new FrmSaveHotline(cLog); frmSaveHotLine.ShowDialog(); }
public APIResult UpdateConsultantLog(TblConsultantLog data) { APIResult res = new APIResult(); using (Sonartez_server db = new Sonartez_server(connectionString)) { var matchedObj = (from c in db.TblConsultantLog where c.ID == data.ID select c).SingleOrDefault(); if (matchedObj == null) { try { // does not exist Table<TblConsultantLog> TblObj = db.TblConsultantLog; data.ServerUpdate = DateTime.Now; TblObj.InsertOnSubmit(data); TblObj.Context.SubmitChanges(); res.UpdateDate = data.ServerUpdate.Value; res.Success = true; } catch (Exception ex) { res.Message = ex.Message; res.Success = false; } } else { try { matchedObj.AnswerRef = data.AnswerRef; matchedObj.ClientCode = data.ClientCode; matchedObj.ClientID = data.ClientID; matchedObj.ClientName = data.ClientName; matchedObj.ConsType = data.ConsType; matchedObj.CreateDate = data.CreateDate; matchedObj.Descriptions = data.Descriptions; matchedObj.FinishDate = data.FinishDate; matchedObj.FinishType = data.FinishType; matchedObj.Question = data.Question; matchedObj.Status = data.Status; matchedObj.SubmitDate = data.SubmitDate; matchedObj.TargetCount = data.TargetCount; matchedObj.TargetCountry = data.TargetCountry; matchedObj.TargetEmail = data.TargetEmail; matchedObj.TargetName = data.TargetName; matchedObj.TargetPhoneNumber = data.TargetPhoneNumber; matchedObj.TargetType = data.TargetType; matchedObj.UserID = data.UserID; matchedObj.UserName = data.UserName; matchedObj.ServerUpdate = DateTime.Now; matchedObj.UpdateDate = data.UpdateDate; db.SubmitChanges(); res.UpdateDate = data.ServerUpdate.Value; res.Success = true; } catch (Exception ex) { res.Message = ex.Message; res.Success = false; } } } return res; }
partial void DeleteTblConsultantLog(TblConsultantLog instance);
partial void UpdateTblConsultantLog(TblConsultantLog instance);
partial void InsertTblConsultantLog(TblConsultantLog instance);
public TblConsultantLog InsertOrUpdate(TblConsultantLog data) { Exception cex = null; TblConsultantLog res = null; var conn = new System.Data.SqlServerCe.SqlCeConnection(connectionString); using (Sonartez_server db = new Sonartez_server(conn)) { var matchedObj = (from c in db.TblConsultantLog where c.ID == data.ID select c).SingleOrDefault(); if (matchedObj == null) { try { // does not exist Table<TblConsultantLog> TblObj = db.TblConsultantLog; data.UpdateDate = DateTime.Now; data.SubmitDate = DateTime.Now; data.IsDeleted = 0; TblObj.InsertOnSubmit(data); TblObj.Context.SubmitChanges(); res = data; } catch (Exception ex) { cex = ex; } } else { try { matchedObj.AnswerRef = data.AnswerRef; matchedObj.CreateDate = data.CreateDate; matchedObj.ClientCode = data.ClientCode; matchedObj.ClientID = data.ClientID; matchedObj.ClientName = data.ClientName; matchedObj.ConsType = data.ConsType; matchedObj.CreateDate = data.CreateDate; matchedObj.Descriptions = data.Descriptions; matchedObj.Status = data.Status; matchedObj.FinishDate = data.FinishDate; matchedObj.FinishType = data.FinishType; matchedObj.IsDeleted = data.IsDeleted; matchedObj.Question = data.Question; matchedObj.SubmitDate = data.SubmitDate; matchedObj.TargetCount = data.TargetCount; matchedObj.SubmitDate = data.SubmitDate; matchedObj.TargetCountry = data.TargetCountry; matchedObj.TargetEmail = data.TargetEmail; matchedObj.TargetName = data.TargetName; matchedObj.TargetPhoneNumber = data.TargetPhoneNumber; matchedObj.TargetType = data.TargetType; matchedObj.UserID = data.UserID; matchedObj.UserName = data.UserName; matchedObj.UpdateDate = DateTime.Now; db.SubmitChanges(); res = matchedObj; } catch (Exception ex) { cex = ex; } } } if (cex != null) throw cex; else return res; }
private bool Delete(TblConsultantLog data) { Exception cex = null; bool res = false; var conn = new System.Data.SqlServerCe.SqlCeConnection(connectionString); using (Sonartez_server db = new Sonartez_server(conn)) { var matchedObj = (from c in db.TblConsultantLog where c.ID == data.ID select c).SingleOrDefault(); if (matchedObj != null) { try { // does not exist db.TblConsultantLog.DeleteOnSubmit(matchedObj); db.SubmitChanges(); res = true; } catch (Exception ex) { cex = ex; res = false; } } else { res = true; } } if (cex != null) throw cex; else return res; }