public static AdjusterLicenseAppointmentType Save(AdjusterLicenseAppointmentType appointmentType) { if (appointmentType.LicenseAppointmentTypeID == 0) DbContextHelper.DbContext.AdjusterLicenseAppointmentType.Add(appointmentType); DbContextHelper.SaveChanges(); return appointmentType; }
protected void btnUpload_Click(object sender, EventArgs e) { string fileExtension = null; AdjusterMaster adjuster = null; string firstName = null; string lastName = null; AdjusterServiceArea serviceArea = null; AdjusterLicenseAppointmentType licenseAppointmentType = null; string licenseNumber = null; string licenseType = null; string licenseEffectiveDate = null; string licenseExpireDate = null; string appointmentType = null; StateMaster stateMaster = null; string str = null; lblMessage.Text = string.Empty; if (!fileUpload.HasFile) { lblMessage.Text = "No file selected."; lblMessage.CssClass = "error"; return; } // validate file fileExtension = System.IO.Path.GetExtension(fileUpload.PostedFile.FileName); if (!fileExtension.Equals(".csv", StringComparison.OrdinalIgnoreCase)) { lblMessage.Text = "CSV file format allowed only."; lblMessage.CssClass = "error"; return; } try { //save file in temp folder string destinationPath = Server.MapPath(string.Format("~//Temp//{0}.csv", Guid.NewGuid())); fileUpload.SaveAs(destinationPath); // load file for processing //DataTable table = CSVReader.ReadCSVFile(Server.MapPath("~//Temp//" + fileUpload.FileName), true); DataTable table = CSVHelper.ReadCSVFile(destinationPath); using (TransactionScope scope = new TransactionScope()) { for (int i = 0; i < table.Rows.Count; i++) { #region process each row adjuster = new AdjusterMaster(); adjuster.ClientId = clientID; adjuster.Status = true; adjuster.InsertBy = userID; adjuster.InsertDate = DateTime.Now; if (table.Rows[i]["First_Name"] != string.Empty) firstName = table.Rows[i]["First_Name"].ToString(); if (table.Rows[i]["Last_Name"] != string.Empty) lastName = table.Rows[i]["Last_Name"].ToString(); // skip blank rows if (string.IsNullOrEmpty(lastName) && string.IsNullOrEmpty(firstName)) continue; adjuster.FirstName = firstName.Length < 50 ? firstName : firstName.Substring(0, 50); adjuster.LastName = lastName.Length < 50 ? lastName : lastName.Substring(0, 50); if (table.Rows[i]["Middle_Initial"] != string.Empty) { str = table.Rows[i]["Middle_Initial"].ToString(); adjuster.MiddleInitial = str.Substring(0, 1); } adjuster.AdjusterName = string.Format("{0} {1} {2}", firstName, adjuster.MiddleInitial ?? "", lastName); if (table.Rows[i]["Suffix"] != string.Empty) adjuster.Suffix = table.Rows[i]["Suffix"].ToString().Substring(0,1); if (table.Rows[i]["Cell_Phone_Number"] != string.Empty) { str = table.Rows[i]["Cell_Phone_Number"].ToString(); if (str.Length > 20) adjuster.PhoneNumber = str.Substring(0, 20); else adjuster.PhoneNumber = str; } if (table.Rows[i]["Email"] != string.Empty) { str = table.Rows[i]["Email"].ToString(); adjuster.email = str.Length < 100 ? str : str.Substring(0, 100); } if (table.Rows[i]["Address_Line1"] != string.Empty) { str = table.Rows[i]["Address_Line1"].ToString(); adjuster.Address1 = str.Length < 100 ? str : str.Substring(0, 100); } if (table.Rows[i]["City"] != string.Empty) { str = table.Rows[i]["City"].ToString(); adjuster.Address1 = str.Length < 50 ? str : str.Substring(0, 50); } if (table.Rows[i]["State_Code"] != string.Empty) { str = table.Rows[i]["State_Code"].ToString(); stateMaster = State.Getstateid(str); if (stateMaster.StateId > 0) adjuster.StateID = stateMaster.StateId; else adjuster.StateID = null; } if (table.Rows[i]["ZIP_Code"] != string.Empty) { str = table.Rows[i]["ZIP_Code"].ToString(); adjuster.Address1 = str.Length < 10 ? str : str.Substring(0, 10); } // save adjuster adjuster = AdjusterManager.Save(adjuster); if (table.Rows[i]["License_Type"] != string.Empty) licenseType = table.Rows[i]["License_Type"].ToString(); if (table.Rows[i]["License_Number"] != string.Empty) licenseNumber = table.Rows[i]["License_Number"].ToString(); if (table.Rows[i]["License_Issue_Date"] != string.Empty) licenseEffectiveDate = table.Rows[i]["License_Issue_Date"].ToString(); if (table.Rows[i]["License_Expires_Date"] != string.Empty) licenseExpireDate = table.Rows[i]["License_Expires_Date"].ToString(); if (table.Rows[i]["Appointment_Type"] != string.Empty) { appointmentType = table.Rows[i]["Appointment_Type"].ToString(); if (!string.IsNullOrEmpty(appointmentType)) { licenseAppointmentType = AdjusterLicenseAppointmentTypeManager.Get(appointmentType, clientID); if (licenseAppointmentType == null) { licenseAppointmentType = new AdjusterLicenseAppointmentType(); licenseAppointmentType.IsActive = true; licenseAppointmentType.LicenseAppointmentType = appointmentType; licenseAppointmentType.ClientID = clientID; licenseAppointmentType = AdjusterLicenseAppointmentTypeManager.Save(licenseAppointmentType); } } } if (!string.IsNullOrEmpty(licenseType) && !string.IsNullOrEmpty(licenseNumber) && !string.IsNullOrEmpty(licenseEffectiveDate) && !string.IsNullOrEmpty(licenseExpireDate) && !string.IsNullOrEmpty(appointmentType)) { serviceArea = new AdjusterServiceArea(); serviceArea.AdjusterID = adjuster.AdjusterId; serviceArea.StateID = adjuster.StateID; serviceArea.LicenseNumber = licenseNumber.Length < 50 ? licenseNumber : licenseNumber.Substring(0, 50); serviceArea.LicenseType = licenseType.Length < 20 ? licenseType : licenseType.Substring(0, 20); DateTime effectiveDate = DateTime.MaxValue; DateTime expireDate = DateTime.MaxValue; if (DateTime.TryParse(licenseEffectiveDate, out effectiveDate)) serviceArea.LicenseEffectiveDate = effectiveDate; if (DateTime.TryParse(licenseExpireDate, out expireDate)) serviceArea.LicenseExpirationDate = expireDate; if (licenseAppointmentType != null) serviceArea.AppointmentTypeID = licenseAppointmentType.LicenseAppointmentTypeID; AdjusterStateLicenseManager.Save(serviceArea); } // create notes if (table.Rows[i]["Adjuster_Status_Code"] != string.Empty) { string adjuster_Status_Code = table.Rows[i]["Adjuster_Status_Code"].ToString(); addNote(adjuster.AdjusterId, adjuster_Status_Code); } if (table.Rows[i]["Adjuster_Reason_Code"] != string.Empty) { string sdjuster_Reason_Code = table.Rows[i]["Adjuster_Reason_Code"].ToString(); addNote(adjuster.AdjusterId, sdjuster_Reason_Code); } #endregion } scope.Complete(); lblMessage.Text = "Import completed successfully."; lblMessage.CssClass = "ok"; } } catch (Exception ex) { lblMessage.Text = "Import not completed successfully."; lblMessage.CssClass = "error"; Core.EmailHelper.emailError(ex); } }
/// <summary> /// Create a new AdjusterLicenseAppointmentType object. /// </summary> /// <param name="licenseAppointmentTypeID">Initial value of the LicenseAppointmentTypeID property.</param> /// <param name="licenseAppointmentType">Initial value of the LicenseAppointmentType property.</param> /// <param name="isActive">Initial value of the IsActive property.</param> public static AdjusterLicenseAppointmentType CreateAdjusterLicenseAppointmentType(global::System.Int32 licenseAppointmentTypeID, global::System.String licenseAppointmentType, global::System.Boolean isActive) { AdjusterLicenseAppointmentType adjusterLicenseAppointmentType = new AdjusterLicenseAppointmentType(); adjusterLicenseAppointmentType.LicenseAppointmentTypeID = licenseAppointmentTypeID; adjusterLicenseAppointmentType.LicenseAppointmentType = licenseAppointmentType; adjusterLicenseAppointmentType.IsActive = isActive; return adjusterLicenseAppointmentType; }
/// <summary> /// Deprecated Method for adding a new object to the AdjusterLicenseAppointmentTypes EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToAdjusterLicenseAppointmentTypes(AdjusterLicenseAppointmentType adjusterLicenseAppointmentType) { base.AddObject("AdjusterLicenseAppointmentTypes", adjusterLicenseAppointmentType); }