public void Save(DataTable dt, BatchDetail batchDet, string sessionid) { BatchRecordDetail det; string strDate, strTime; int iPass = 0, iFail = 0, iBlank = 0, iType = 0; foreach (DataRow dr in dt.Rows) { det = new BatchRecordDetail(); try { if (DataUtils.GetColumnValue(dr, BatchUploadConstants.Name).Length > 0) { det.BatchID = batchDet.ID; det.CompanyID = batchDet.CompanyID; strDate = DataUtils.GetColumnValue(dr, BatchUploadConstants.ReceivedDate); strTime = DataUtils.GetColumnValue(dr, BatchUploadConstants.ReceivedTime); det.ReceivedDate = Convert.ToDateTime(strDate); det.CustomerRefNo = DataUtils.GetColumnValue(dr, BatchUploadConstants.CustomerRefNo); det.LeadNo = GMConvert.GetInt32(DataUtils.GetColumnValue(dr, BatchUploadConstants.LeadNumber)); det.CountyID = GMConvert.GetInt32(DataUtils.GetColumnValue(dr, BatchUploadConstants.CountyID)); det.Name = DataUtils.GetColumnValue(dr, BatchUploadConstants.Name); det.DOB = Convert.ToDateTime(DataUtils.GetColumnValue(dr, BatchUploadConstants.DOB)); iType = GMConvert.GetInt32(DataUtils.GetColumnValue(dr, BatchUploadConstants.CaseTypeID)); if (iType > 0) { det.CaseTypeID = iType; } det.RecordStatusID = Convert.ToInt32(BatchUploadConstants.EnumRecordStatusType.RESEARCH); det.Years = GMConvert.GetInt32(DataUtils.GetColumnValue(dr, BatchUploadConstants.Years)); det.SSN = DataUtils.GetColumnValue(dr, BatchUploadConstants.SSN); det.ClientRemarks = DataUtils.GetColumnValue(dr, BatchUploadConstants.ClientRemarks); det.ClientSplRemarks = DataUtils.GetColumnValue(dr, BatchUploadConstants.ClientSplRemarks); det.ActualCaseType = DataUtils.GetColumnValue(dr, BatchUploadConstants.ActualCaseType); Save(det); SaveRecordHistory(det.ID, det.RecordStatusID, batchDet.UserID); iPass += 1; } else { iBlank += 1; } } catch (Exception ex) { iFail += 1; m_msg.Add(string.Format(ErrorConstants.BatchSaveFailed, det.Name)); Logger.LogException(ex); } } batchDet.FailCount = iFail; batchDet.PassCount = iPass; batchDet.TotalCount = dt.Rows.Count - iBlank; }
public void ChangePassword(string sessionid, string userid, string oldpwd, string newpwd) { DCUser2 dcusr = GetCache(sessionid); if (string.Compare(dcusr.Password, CryptoUtils.EncryptSHA(oldpwd), true) != 0) { throw new ApplicationException(ErrorConstants.ExistingPassword); } User2Detail detusr = new User2Detail(); detusr.ID = (Int32?)GMConvert.GetInt32(userid); detusr.Password = CryptoUtils.EncryptSHA(newpwd); detusr.LastPassword = CryptoUtils.EncryptSHA(oldpwd); detusr.PasswordChangeDate = DateTime.Now; detusr.IsChangePasssword = false; detusr.ModifiedDate = DateTime.Now; Save(detusr); dcusr.Password = CryptoUtils.EncryptSHA(newpwd); dcusr.IsChangePasssword = false; }
public DCCase2(DataRow dr) : this(GMConvert.GetInt32(dr[Case2Record.ID.ToString()]), dr[Case2Record.Description.ToString()].ToString(), GMConvert.GetInt32(dr[Case2Record.LevelTypeID.ToString()]), GMConvert.GetInt32(dr[Case2Record.PleaTypeID.ToString()]), GMConvert.GetInt32(dr[Case2Record.DispositionTypeID.ToString()])) { }
protected void OnDelete(object sender, GridViewDeleteEventArgs e) { grvCountyRate.Rows[e.RowIndex].Visible = false; m_biz.Delete(GMConvert.GetInt32(grvCountyRate.DataKeys[e.RowIndex].Value)); Bind(); }
public DCCase2(GridView gv, GridViewRow gvr) : this(GMConvert.GetInt32(gv.DataKeys[gvr.RowIndex].Value), DataUtils.GetText(gvr, (int)Case2Record.Description), DataUtils.GetID(gvr, (int)Case2Record.LevelTypeID), DataUtils.GetID(gvr, (int)Case2Record.PleaTypeID), DataUtils.GetID(gvr, (int)Case2Record.DispositionTypeID)) { }