protected void BindDropdownLists() { BindDropdownList.Countries(ddlCountryID); BindDropdownList.Countries(ddlCountryOfBirthID); BindDropdownList.Currencies(ddlDayRateCurrencyID); BindDropdownList.MaritalStatuses(ddlMaritalStatusID); OMMDataContext context = new OMMDataContext(); var roles = from P in context.Roles select new { P.ID, P.Name }; if (roles != null && roles.Count() > 0) { hdnRoles.Value = roles.ToList().ToJSON(); } var telephoneTypes = from P in context.TelephoneNumberTypes select new { P.ID, P.Name }; if (telephoneTypes != null && telephoneTypes.Count() > 0) { hdnTelephoneTypes.Value = telephoneTypes.ToList().ToJSON(); } var commTypes = from P in context.ContactCommsTypes select new { P.ID, P.Name }; if (commTypes != null && commTypes.Count() > 0) { hdnCommTypes.Value = commTypes.ToList().ToJSON(); } }
private static void MoveAttachedFiles(Enquiry enquiry, OMMDataContext context) { IList <EnquiryFile> files = SessionCache.CurrentEnquiryFiles; foreach (EnquiryFile file in files) { ///Move Files from Temp Directory to User Directory String tempFilePath = Path.Combine(HttpContext.Current.Server.MapPath(AppConstants.TEMP_DIRECTORY), file.FileName); String actualFilePath = HttpContext.Current.Server.MapPath(AppConstants.ENQUIRY_ATTACHMENTS); actualFilePath = Path.Combine(actualFilePath, enquiry.ID.ToString()); if (!Directory.Exists(actualFilePath)) { Directory.CreateDirectory(actualFilePath); } String fileName = String.Format("{0}_{1}", file.ID, file.FileName); actualFilePath = Path.Combine(actualFilePath, fileName); File.Copy(tempFilePath, actualFilePath, true); file.FileName = fileName; context.SubmitChanges(); ///Delete Temporay File if (File.Exists(tempFilePath)) { File.Delete(tempFilePath); } } }
/// <summary> /// Binds Enquiry Details for Edit Mode /// </summary> protected void BindEnquiryDetails() { if (_IsEditMode) { OMMDataContext context = new OMMDataContext(); Enquiry enquiry = context.Enquiries.SingleOrDefault(P => P.ID == _EnquiryID); if (enquiry == null) { ShowNotFoundMessage(); } else { ddlContact.SetSelectedItem(enquiry.ContactID.ToString()); _StatusID = enquiry.StatusID; txtClientName.Text = enquiry.ClientContact.Client.Name; txtContactName.Text = enquiry.ClientContact.Name; txtJobTitle.Text = enquiry.ClientContact.JobTitle; if (enquiry.ClientContact.Country != null) { txtCountry.Text = enquiry.ClientContact.Country.Name; } ddlEnquiryType.SetSelectedItem(enquiry.TypeID.ToString()); txtDetails.Text = enquiry.EnquiryLines.Count > 0 ? enquiry.EnquiryLines[0].Details : String.Empty; //Momin ddlEnquirySourceTypes.SetSelectedItem(enquiry.SourceTypeID.ToString()); txtEnguirySubject.Text = enquiry.EnguirySubject.TrimString(); BindAttachments(enquiry); SessionCache.CurrentEnquiryFiles = null; } } }
public static String SaveEnquiry(App.CustomModels.CustomEnquiry customEnquiry) { OMMDataContext context = new OMMDataContext(); Enquiry enquiry = null; if (customEnquiry.ID == 0) { enquiry = new Enquiry(); context.Enquiries.InsertOnSubmit(enquiry); } else { enquiry = context.Enquiries.SingleOrDefault(P => P.ID == customEnquiry.ID); } MapEnquiry(customEnquiry, enquiry, context); foreach (EnquiryFile file in SessionCache.CurrentEnquiryFiles) { enquiry.EnquiryFiles.Add(file); } context.SubmitChanges(); SaveEnquiryLineItems(customEnquiry, enquiry, context); MoveAttachedFiles(enquiry, context); SessionCache.CurrentEnquiryFiles = null; return(String.Format("{0}:{1}", enquiry.ID, enquiry.Number)); }
/// <summary> /// Loads Immediate Family Details from ContactNextOfKins Collection /// </summary> public void LoadImmediateFamilyDetails() { OMMDataContext context = new OMMDataContext(); var immediateFamily = context.ContactsNextOfKins.FirstOrDefault(P => P.ContactID == _ContactID); //if (_ImmediateFamily == null || _ContactID == 0) //{ // tbxSaveUpdate.Text = "Save"; //} //else if (immediateFamily == null) { lblChangedBy.Text = SessionCache.CurrentUser.UserName; lblChagedOn.Text = DateTime.Now.ToString(AppConstants.ValueOf.SHORT_DATE_FROMAT_WITH_TIME); } else { //tbxSaveUpdate.Text = "Update"; tbxMotherName.Text = immediateFamily.MothersName; //(_ImmediateFamily.MothersName.IsNullOrEmpty()) ? "" : //_ImmediateFamily.MothersName.ToString(); tbxFatherName.Text = immediateFamily.FathersName; //(_ImmediateFamily.FathersName.IsNullOrEmpty()) ? "" : //_ImmediateFamily.FathersName.ToString(); tbxChildName.Text = immediateFamily.ChildrensNames; //(_ImmediateFamily.ChildrensNames.IsNullOrEmpty()) ? "" : //_ImmediateFamily.ChildrensNames.ToString(); lblChangedBy.Text = immediateFamily.User == null ? String.Empty : immediateFamily.User.UserName; lblChagedOn.Text = immediateFamily.ChangedOn.ToString(AppConstants.ValueOf.SHORT_DATE_FROMAT_WITH_TIME); } }
/// <summary> /// Binds Next of Kin Information from Different Collection /// </summary> protected void BindNextOfKinInfo() { OMMDataContext context = new OMMDataContext(); //if (context.NextOfKins.FirstOrDefault(P => P.ContactID == _ContactID) == null) // ShowNotFoundMessage(); //else //{ if (_IsEditMode) { NextOfKin entity = context.NextOfKins.FirstOrDefault(P => P.ID == _ID && P.ContactID == _ContactID); if (entity == null) { ShowNotFoundMessage(); } else { tbxName.Text = entity.Name; tbxRelationShip.Text = entity.Relationship; tbxAddress.Text = entity.Address; tbxPostCode.Text = entity.Postcode; //ddlCountry.SetSelectedItem((entity.CountryID.ToString().Trim().IsNullOrEmpty()) ? //String.Empty : entity.CountryID.ToString().Trim()); ddlCountry.SetSelectedItem(entity.CountryID.ToString()); tbxHomeNumber.Text = entity.HomeNumber; tbxWorkNumber.Text = entity.WorkNumber; tbxMobile.Text = entity.MobileNumber; } } //} }
protected void SaveContactsNotes() { OMMDataContext context = new OMMDataContext(); ContactsNote entity = null; if (_IsEditMode) { entity = context.ContactsNotes.FirstOrDefault(P => P.ID == _ID && P.ContactID == _ContactID); //dao.GetByID(_ID); } else { entity = new ContactsNote(); entity.ContactID = _ContactID; context.ContactsNotes.InsertOnSubmit(entity); } //ddlContactID.SelectedValue.ToInt(); entity.Notes = txtNotes.Text; entity.ContactCommsTypeID = Convert.ToInt32(ddlCommType.SelectedValue); entity.ChangedByUserID = SessionCache.CurrentUser.ID; entity.ChangedOn = DateTime.Now; entity.CreatedByUsername = entity.ChangedByUsername = SessionCache.CurrentUser.UserName; context.SubmitChanges(); String url = String.Format("{0}?{1}={2}&{3}=True" , Request.Url.AbsolutePath , AppConstants.QueryString.CONTACT_ID , _ContactID , AppConstants.QueryString.SUCCESS_MSG); Response.Redirect(url); }
public static String SaveDecision(int quotationID, int decision) { OMMDataContext dataContext = new OMMDataContext(); var quotation = dataContext.Quotations.SingleOrDefault(Q => Q.ID == quotationID); if (quotation != null) { quotation.StatusID = decision; ///If Requote is Requested for this quotation if (decision == App.CustomModels.QuotationStatus.ReQquoteRequested) { quotation.Number = dataContext.GenerateNewQuotationNumber(quotation.EnquiryID, true); quotation.StatusID = App.CustomModels.QuotationStatus.NotSubmitted; } quotation.ChangedByUserID = SessionCache.CurrentUser.ID; quotation.ChangedByUsername = SessionCache.CurrentUser.UserName; //SessionCache.CurrentUser.UserNameWeb; quotation.ChangedOn = DateTime.Now; //if (decision == App.CustomModels.QuotationStatus.Successful || decision == App.CustomModels.QuotationStatus.Unsuccessful) // quotation.Enquiry.StatusID = App.CustomModels.EnquiryStatus.Closed; //else if (decision == App.CustomModels.QuotationStatus.ReQquoteRequested) //{ // //Create a New Quotation for this Enquiry with this objects data //} //if (decision == App.CustomModels.QuotationStatus.Successful) // quotation.Projects.Add(CreateProjectFromQuotation(quotation, dataContext)); dataContext.SubmitChanges(); return(String.Format("{0}:{1}", quotation.ID, quotation.Number)); } return(String.Empty); }
public static int SavePersonnel(App.CustomModels.Personnel personnel, List <App.CustomModels.PersonnelTelephone> telephones, List <App.CustomModels.ConNote> ConNotes, List <App.CustomModels.PersonnelEmail> emails, List <App.CustomModels.PersonnelRole> roles) { OMMDataContext context = new OMMDataContext(); Contact contact = populateContact(personnel, context); ///Roles if (roles != null && roles.Count > 0) { foreach (App.CustomModels.PersonnelRole role in roles) { ContactRole contactRole = null; if (role.ID > 0) { contactRole = context.ContactRoles.SingleOrDefault(P => P.ID == role.ID); } else { contactRole = new ContactRole(); contact.ContactRoles.Add(contactRole); } contactRole.RoleID = role.RoleID; contactRole.RoleOrder = role.Order; contactRole.ChangedByUserID = SessionCache.CurrentUser.ID; contactRole.ChangedOn = DateTime.Now; } } context.SubmitChanges(); return(contact.ID); }
/// <summary> /// Binds EmploymentHistory Info Requested through Query Strings /// </summary> protected void BindEmploymentHistoryInfo() { OMMDataContext context = new OMMDataContext(); if (context.Contacts.FirstOrDefault(P => P.ID == _ContactID) == null) { //pnlEmpHistory.Visible = true; ShowNotFoundMessage(); } else { //pnlEmpHistory.Visible = false; if (_IsEditMode) { EmploymentHistory entity = context.EmploymentHistories.FirstOrDefault(P => P.ID == _ID && P.ContactID == _ContactID);//dao.GetByID(_ID); if (entity == null) { //pnlEmpHistory.Visible = false; ShowNotFoundMessage(); } else { } } } }
public App.CustomModels.CustomContact GetClientContact(int id) { OMMDataContext context = new OMMDataContext(); ClientContact contact = context.ClientContacts.SingleOrDefault(P => P.ID == id); return(MapClientContactObject(contact)); }
public String SaveProject(App.CustomModels.CustomProject customProject) { OMMDataContext context = new OMMDataContext(); Project project = new Project(); if (customProject.ID > 0) { project = context.Projects.SingleOrDefault(P => P.ID == customProject.ID); project.ChangedByUserID = SessionCache.CurrentUser.ID; project.ChangedByUsername = SessionCache.CurrentUser.UserName; //SessionCache.CurrentUser.UserNameWeb; project.ChangedOn = DateTime.Now; } else { context.Projects.InsertOnSubmit(project); project.CreatedByUserID = project.ChangedByUserID = SessionCache.CurrentUser.ID; project.CreatedByUsername = project.ChangedByUsername = SessionCache.CurrentUser.UserName;//SessionCache.CurrentUser.UserNameWeb; project.CreatedOn = project.ChangedOn = DateTime.Now; project.Number = context.GenerateNewProjectNumber(); project.StatusID = App.CustomModels.ProjectStatus.InProgress; } project.QuotationID = customProject.QuotationID; project.Name = customProject.Name; project.Description = customProject.Description; project.StartDate = WebUtil.GetDate(customProject.StartDate); project.EndDate = WebUtil.GetDate(customProject.EndDate); context.SubmitChanges(); return(String.Format("{0}:{1}", project.ID, project.Number)); }
protected void CheckAndDeleteData() { if (_IsDeleteMode) { OMMDataContext context = new OMMDataContext(); var CertificationDetails = context.Certificates.FirstOrDefault(P => P.ID == _ID && P.ContactID == _ContactID); if (CertificationDetails == null) { WebUtil.ShowMessageBox(divMessage, "Sorry! requested Certification Details not found for delete. Delete Failed.", true); } else { context.Certificates.DeleteOnSubmit(CertificationDetails); try { context.SubmitChanges(); WebUtil.ShowMessageBox(divMessage, "Certification Details deleted successfully.", false); } catch { WebUtil.ShowMessageBox(divMessage, "Sorry! this Certification contains related information. Delete failed.", true); } } } }
/// <summary> /// Binds Quotations Info Requested through Query Strings /// </summary> protected void BindQuotationsInfo() { OMMDataContext dataContext = new OMMDataContext(); ///Bind Quotation First Quotation quotation = dataContext.Quotations.SingleOrDefault(E => E.ID == _QuotationID); if (quotation == null) { ShowErroMessag("Q", String.Empty); return; } else { ltrHeading.Text = String.Format("Quotation Submit Wizard - Quotation {0} Enquiry {1}", quotation.Number, quotation.Enquiry.Number); if (quotation.StatusID != App.CustomModels.QuotationStatus.NotSubmitted) { ShowErroMessag("V", quotation.Number); return; } else { BindClientContactInfo(quotation.Enquiry); } } Page.Title = ltrHeading.Text; }
/// <summary> /// Handles page load event /// </summary> /// <param name="e"></param> protected override void OnLoad(EventArgs e) { //SessionCache.CurrentUser = null; WebUtil.LoginUser(); base.OnLoad(e); if (SessionCache.CurrentUser == null) { if (User.Identity.Name.IsNullOrEmpty()) { Server.Transfer(AppConstants.Pages.ACCESS_DENIED); } else { OMMDataContext dataContext = new OMMDataContext(); User user = new User(); user.UserName = user.DisplayName = User.Identity.Name; user.Modified = DateTime.Now; user.Password = "******"; dataContext.Users.InsertOnSubmit(user); dataContext.SubmitChanges(); Response.Redirect(Request.Url.AbsoluteUri); } } }
protected void SaveContactsVisa() { OMMDataContext context = new OMMDataContext(); Visa entity = null; if (_IsEditMode) { entity = context.Visas.FirstOrDefault(P => P.ID == _ID && P.ContactID == _ContactID); } else { entity = new Visa(); entity.ContactID = _ContactID; context.Visas.InsertOnSubmit(entity); } //ddlContactID.SelectedValue.ToInt(); if (!ddlCountry.SelectedValue.IsNullOrEmpty()) { entity.CountryID = ddlCountry.SelectedValue.ToInt(); //Convert.ToInt32(ddlCountry.SelectedValue); } //entity.CountryID = Convert.ToInt32(tbxCountry.Text); entity.VisaType = tbxVisaType.Text; if (!tbxVisaExpDate.Text.IsNullOrEmpty()) //if (tbxExpiryDate.Text.Trim() != "") { entity.ExpiryDate = tbxVisaExpDate.Text.ToDateTime(ConfigReader.CSharpCalendarDateFormat); //Convert.ToDateTime(tbxExpiryDate.Text.Trim()); } entity.ChangedByUserID = SessionCache.CurrentUser.ID; entity.ChangedOn = DateTime.Now; //entity = entity.ChangedByUsername = SessionCache.CurrentUser.UserName; context.SubmitChanges(); RedirectToShowSuccessMessage(); }
public void loadImmediateFamilyDetails(int contactID) { OMMDataContext context = new OMMDataContext(); //IList<ContactCV> contactCV = (from P // in context.ContactCVs // where P.ContactID == contactID // select P).ToList(); //IList<ContactsNextOfKin> ContactsNextOfKin = (from P // in context.ContactsNextOfKins // where P.ContactID == contactID // select P).ToList(); var ContactsNextOfKins = context.ContactsNextOfKins.FirstOrDefault(P => P.ContactID == contactID); if (ContactsNextOfKins == null || contactID == 0) { btnUpload.Text = "Save"; } else { btnUpload.Text = "Update"; tbxMotherName.Text = (ContactsNextOfKins.MothersName.IsNullOrEmpty()) ? "" : ContactsNextOfKins.MothersName.ToString(); tbxFatherName.Text = (ContactsNextOfKins.FathersName.IsNullOrEmpty()) ? "" : ContactsNextOfKins.FathersName.ToString(); tbxChildName.Text = (ContactsNextOfKins.ChildrensNames.IsNullOrEmpty()) ? "" : ContactsNextOfKins.ChildrensNames.ToString(); //grdsearch.DataSource = ContactsNextOfKin; //grdsearch.DataBind(); } }
public void loadNextOfKinDetails(int contactID) { grdsearch.DataSource = null; grdsearch.DataBind(); OMMDataContext context = new OMMDataContext(); IList <NextOfKin> NextOfKin_ = (from P in context.NextOfKins where P.ContactID == contactID select P).ToList(); if (NextOfKin_ == null || contactID == 0) { grdsearch.DataSource = NextOfKin_; grdsearch.DataBind(); btnSaveNextKin.Text = "Save"; } else { btnUpload.Text = "Update"; //tbxMotherName.Text = (ContactsNextOfKins.MothersName.IsNullOrEmpty()) ? "" : ContactsNextOfKins.MothersName.ToString(); //tbxFatherName.Text = (ContactsNextOfKins.FathersName.IsNullOrEmpty()) ? "" : ContactsNextOfKins.FathersName.ToString(); //tbxChildName.Text = (ContactsNextOfKins.ChildrensNames.IsNullOrEmpty()) ? "" : ContactsNextOfKins.ChildrensNames.ToString(); grdsearch.DataSource = NextOfKin_; grdsearch.DataBind(); } }
protected void btnAddRoles_Click(object sender, EventArgs e) { if (Page.IsValid) { OMMDataContext context = new OMMDataContext(); if (context.ContactRoles.FirstOrDefault(P => P.ContactID == _ContactID && P.RoleID == Convert.ToInt32(ddlRoles.SelectedValue)) == null) { ContactRole entity = null; entity = new ContactRole(); entity.ContactID = _ContactID; entity.RoleID = Convert.ToInt32(ddlRoles.SelectedValue); entity.ChangedByUserID = SessionCache.CurrentUser.ID; entity.ChangedOn = DateTime.Now; entity.RoleOrder = Convert.ToInt32(RoleOrderNo.Text); context.ContactRoles.InsertOnSubmit(entity); context.SubmitChanges(); String url = String.Format("{0}?{1}={2}&{3}=True" , Request.Url.AbsolutePath , AppConstants.QueryString.CONTACT_ID, _ContactID , AppConstants.QueryString.SUCCESS_MSG); Response.Redirect(url); } } }
public static App.CustomModels.SendSmsStatus SendSms(String commaSeparaterTelephoneIDs, String messageText) { //return new App.CustomModels.SendSmsStatus(); _DataContext = new OMMDataContext(); _ErrorMessage = String.Empty; //Get Int array from the receipients list int[] telephoneIDs = WebUtil.GetIntArray(commaSeparaterTelephoneIDs); ///Create the Web Service Object for Sending SMS _SmsService = new SMSService.TextAnywhere_SMS(); //at first save the message to Messages Table Message message = SaveMessage(messageText.Trim()); //Now save details message for individual reciepents in : Message_Recipients TABLE SaveMessageRecipients(message.ID, telephoneIDs); //Finally send message to the reciepents mobile String sentCells = SendMessage(telephoneIDs, message); App.CustomModels.SendSmsStatus reply = new App.CustomModels.SendSmsStatus(); if (String.IsNullOrEmpty(_ErrorMessage)) { reply.StatusID = 1; reply.Message = sentCells; } else { reply.StatusID = -1; reply.Message = _ErrorMessage; } return(reply); }
public void loadReport() { //Select data from the LINQ object OMMDataContext dataContext = new OMMDataContext(); var query1 = from i in dataContext.reportMonthlyQuotations() where i.Year == Convert.ToInt32(ddlYear.Text) //orderby i.Price select i; //Get datatable from the LINQ dataset query DataTable dtEnqueryDetails = LINQToDataTable(query1); //Load report from the serverpath ReportDocument repDoc = new ReportDocument(); repDoc.Load(HttpContext.Current.Request.PhysicalApplicationPath.Trim() + @"\Reports\monthlyQuotationReport.rpt"); //Set datasource to the report object repDoc.SetDataSource(dtEnqueryDetails); //Now show the report in the reportviewer CrystalReportViewer1.ReportSource = repDoc; divReportContainer.Visible = true; }
protected void btnUpload_onclick(object sender, EventArgs e) { if (fileUploadCV.HasFile) { String uploadDirectory = Server.MapPath("/UploadedCV"); if (IsValidDocument(fileUploadCV.PostedFile)) { //Save information in the database OMMDataContext context = new OMMDataContext(); ContactCV contactCV = new ContactCV(); contactCV.ContactID = WebUtil.GetQueryStringInInt("ID"); contactCV.FileName = Path.GetFileName(fileUploadCV.FileName); contactCV.CreatedBy = SessionCache.CurrentUser.ID; contactCV.ChangedBy = SessionCache.CurrentUser.ID; contactCV.ChangedOn = DateTime.Now; context.ContactCVs.InsertOnSubmit(contactCV); context.SubmitChanges(); //Now upload the CV in the web server saveFile(uploadDirectory, contactCV.ID); loadUploadedDoc(WebUtil.GetQueryStringInInt("ID")); } else { WebUtil.ShowMessageBox(divAttachmentError, String.Format("Only Microsoft Word (*.doc, *.docx) and PDF (*.pdf) documents are allowed."), true); } } }
public static App.CustomModels.AjaxStatus ChangePassword(String newPassword, String oldPassword) { OMMDataContext dataContext = new OMMDataContext(); App.CustomModels.AjaxStatus status = new App.CustomModels.AjaxStatus(); User user = dataContext.Users.SingleOrDefault(U => U.ID == SessionCache.CurrentUser.ID); if (user != null) { ///Check whether the Current Password and User Supplied Old Password Matches. if (String.Compare(oldPassword, user.Password, false) == 0) { user.Password = newPassword; user.ModifiedBy = SessionCache.CurrentUser.ID; user.Modified = DateTime.Now; dataContext.SubmitChanges(); status.StatusID = 1; status.Message = "Your Password Changed Successfully."; } else { status.StatusID = -1; status.Message = "Sorry! Your Old Password do not match."; } } return(status); }
/// <summary> /// Binds Quotations Info Requested through Query Strings /// </summary> protected void BindQuotationsInfo() { OMMDataContext dataContext = new OMMDataContext(); ///Bind Quotation First Enquiry enquiry = dataContext.Enquiries.SingleOrDefault(E => E.ID == _EnquiryID); if (enquiry == null) { ShowErroMessag("E", String.Empty); return; } else { ltrHeading.Text = String.Format("Create New Quotation Wizard - Enquiry {0}", enquiry.Number); //if (enquiry.StatusID == App.CustomModels.EnquiryStatus.Quoted) //{ // ShowErroMessag("V", enquiry.Number); // return; //} //else if (enquiry.StatusID == App.CustomModels.EnquiryStatus.Closed) { ShowErroMessag("VC", enquiry.Number); return; } } Page.Title = ltrHeading.Text; if (_IsEditMode) { Quotation quotation = dataContext.Quotations.SingleOrDefault(Q => Q.EnquiryID == _EnquiryID && Q.ID == _ID); if (enquiry == null || quotation == null) { ShowErroMessag("Q", String.Empty); } else { if (quotation.StatusID == App.CustomModels.QuotationStatus.NotSubmitted) { txtSubcontractor.Text = quotation.Subcontractor; txtScopeOfWork.Text = quotation.ScopeOfWork; txtMainEquipment.Text = quotation.MainEquipment; txtValidityDays.Text = quotation.ValidityDays.ToString(); txtSchedule.Text = quotation.Schedule; txtSubmissionDate.Text = quotation.SubmissionDate.GetValueOrDefault().ToString(ConfigReader.CSharpCalendarDateFormat); txtDecisionDate.Text = quotation.DecisionDate == null ? String.Empty : quotation.DecisionDate.GetValueOrDefault().ToString(ConfigReader.CSharpCalendarDateFormat); ddlYear.Text = quotation.ProjectYear.ToString(); BindQuotationPricingList(dataContext); } else { ShowErroMessag("QCE", String.Empty); } } } }
public override void DataBind() { _DataContext = new OMMDataContext(); IList <ProjectNote> notes = (from P in _DataContext.ProjectNotes where P.ProjectID == this.ProjectID orderby P.CreatedDate select P).ToList(); rptProjectNotesList.DataSource = notes; rptProjectNotesList.DataBind(); }
/// <summary> /// Binds ContactsNotes Info Requested through Query Strings /// </summary> protected void BindContactsPassportInfo() { if (_OnTable == "PASSPORT") { OMMDataContext context = new OMMDataContext(); //if (context.Passports.FirstOrDefault(P => P.ContactID == _ContactID) == null) // ShowNotFoundMessage(); //else //{ if (_IsEditMode) { Passport entity = context.Passports.FirstOrDefault(P => P.ID == _ID && P.ContactID == _ContactID); if (entity == null) { ShowNotFoundMessage(); } else { tbxNumber.Text = entity.Number; tbxWhereIssued.Text = entity.WhereIssued; //tbxExpiryDate.Text = (entity.ExpiryDate.IsNotNull()) ? entity.ExpiryDate.ToString() : ""; tbxExpiryDate.Text = entity.ExpiryDate.HasValue ? entity.ExpiryDate.GetValueOrDefault().ToString(ConfigReader.CSharpCalendarDateFormat) : String.Empty; tbxNationality.Text = entity.Nationality; } } //} } ///Load VISA Information if (_OnTable == "VISA") { OMMDataContext context = new OMMDataContext(); //if (context.Visas.FirstOrDefault(P => P.ID == _ID && P.ContactID == _ContactID) == null) // ShowNotFoundMessage(); //else //{ if (_IsEditMode) { Visa entity = context.Visas.FirstOrDefault(P => P.ID == _ID && P.ContactID == _ContactID); if (entity == null) { ShowNotFoundMessage(); } else { //tbxCountry.Text = entity.CountryID.ToString(); ddlCountry.SetSelectedItem(entity.CountryID.ToString()); tbxVisaType.Text = entity.VisaType; //tbxVisaExpDate.Text = (entity.ExpiryDate.IsNotNull()) ? entity.ExpiryDate.ToString() : ""; tbxVisaExpDate.Text = entity.ExpiryDate.HasValue ? entity.ExpiryDate.GetValueOrDefault().ToString(ConfigReader.CSharpCalendarDateFormat) : String.Empty; } } //} } }
protected String GetPersonnelList(OMMDataContext context) { var personnels = from P in context.EmploymentHistories where P.ProjectID == _ProjectID select P; StringBuilder sb = new StringBuilder(10); sb.Append("<b>Personnel:</b> <br/>"); if (personnels != null && personnels.Count() > 0) { sb.Append("<table class='GridView' cellpadding='3' cellspacing='0' style='width:570px;'>"); //sb.Append(" <colgroup>"); //sb.Append(" <col style='width:10%;' />"); //sb.Append(" <col/>"); //sb.Append(" <col style='width:14%;' />"); //sb.Append(" <col style='width:12%;' />"); //sb.Append(" <col style='width:10%;' />"); //sb.Append(" <col style='width:10%;' />"); //sb.Append(" <col/>"); //sb.Append(" </colgroup>"); sb.Append("<tr>"); sb.Append(" <th>Last Name</th><th>First Name</th><th>Start Date</th><th>End Date</th><th>Role Name</th><th style='text-align:right;'>Day Rate</th><th style='text-align:center;'>Contract Days#</th>"); sb.Append("</tr>"); //String currencySymbol = quotation.Currency == null ? String.Empty : quotation.Currency.ShortCode; //decimal totalPrice = 0; int i = 0; foreach (EmploymentHistory personnel in personnels) { //sb.AppendFormat("<tr class='{0}'>", i % 2 == 0 ? "OddRowStyle" : "EventRowStyle"); sb.AppendFormat("<tr class='{0}'>", i % 2 == 0 ? "OddRowListing" : "EvenRowListing"); //sb.Append("<tr>"); sb.AppendFormat(" <td>{0}</td>", GetPersonnelLNLink(personnel)); //personnel.Contact.LastName.HtmlEncode()); sb.AppendFormat(" <td>{0}</td>", GetPersonnelLink(personnel)); sb.AppendFormat(" <td>{0}</td>", personnel.StartDate.GetValueOrDefault() == DateTime.MinValue ? "NA" : personnel.StartDate.GetValueOrDefault().ToString(AppConstants.ValueOf.DATE_FROMAT_DISPLAY)); sb.AppendFormat(" <td>{0}</td>", personnel.EndDate.GetValueOrDefault() == DateTime.MinValue ? "NA" : personnel.EndDate.GetValueOrDefault().ToString(AppConstants.ValueOf.DATE_FROMAT_DISPLAY)); sb.AppendFormat(" <td>{0}</td>", personnel.Role == null ? "NA" : personnel.Role.Name.HtmlEncode()); sb.AppendFormat(" <td style='text-align:right;'>{0}</td>", personnel.DayRate.GetValueOrDefault() > 0 ? String.Format(AppConstants.ValueOf.DECIMAL_FORMAT, personnel.DayRate.GetValueOrDefault()) : "NA"); sb.AppendFormat(" <td style='text-align:center;'>{0}</td>", personnel.Contract_days.GetValueOrDefault() > 0 ? personnel.Contract_days.GetValueOrDefault().ToString() : "NA"); sb.Append("</tr>"); i++; } sb.Append("</table>"); } else { sb.Append("NA <br/>"); } Project project = context.Projects.SingleOrDefault(P => P.ID == _ProjectID); sb.Append(" <a href='EmploymentHistory.aspx?ProjectID=" + project.ID + "&_controller=EmploymentHistory&_commandName=New&_commandArgument=createForm1' target='_blank'>Add Personnel</a><br/></br>"); return(sb.ToString()); }
public static void DeletePricingLine(int ID) { OMMDataContext dataContext = new OMMDataContext(); QuotationPricingLine qPricingLine = new QuotationPricingLine(); qPricingLine = dataContext.QuotationPricingLines.SingleOrDefault(P => P.ID == ID); dataContext.QuotationPricingLines.DeleteOnSubmit(qPricingLine); dataContext.SubmitChanges(); }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Delete") { int ID = Convert.ToInt32(e.CommandArgument); //Get detail information from the database OMMDataContext context = new OMMDataContext(); var nextOfKinDetails = context.NextOfKins.SingleOrDefault(P => P.ID == ID); if (nextOfKinDetails != null) { //Delete Next of Kin information from the database context.NextOfKins.DeleteOnSubmit(nextOfKinDetails); context.SubmitChanges(); //Now reload the list loadNextOfKinDetails(WebUtil.GetQueryStringInInt("ID")); } } if (e.CommandName == "Edit") { int ID = Convert.ToInt32(e.CommandArgument); //Get detail information from the database OMMDataContext context = new OMMDataContext(); var nextOfKinDetails = context.NextOfKins.SingleOrDefault(P => P.ID == ID); if (nextOfKinDetails != null) { tbxName.Text = (nextOfKinDetails.Name.ToString().Trim().IsNullOrEmpty()) ? "" : nextOfKinDetails.Name.ToString().Trim(); tbxRelationShip.Text = (nextOfKinDetails.Relationship.ToString().Trim().IsNullOrEmpty()) ? "" : nextOfKinDetails.Relationship.ToString().Trim(); tbxAddress.Text = (nextOfKinDetails.Address.ToString().Trim().IsNullOrEmpty()) ? "" : nextOfKinDetails.Address.ToString().Trim(); tbxPostCode.Text = ""; ddlCountry.SelectedValue = (nextOfKinDetails.CountryID.ToString().Trim().IsNullOrEmpty()) ? "0" : nextOfKinDetails.CountryID.ToString().Trim(); tbxHomeNumber.Text = (nextOfKinDetails.HomeNumber.ToString().Trim().IsNullOrEmpty()) ? "" : nextOfKinDetails.HomeNumber.ToString().Trim(); tbxWorkNumber.Text = (nextOfKinDetails.WorkNumber.ToString().Trim().IsNullOrEmpty()) ? "" : nextOfKinDetails.WorkNumber.ToString().Trim(); tbxMobile.Text = (nextOfKinDetails.MobileNumber.ToString().Trim().IsNullOrEmpty()) ? "" : nextOfKinDetails.MobileNumber.ToString().Trim(); tbxChangedBy.Text = (nextOfKinDetails.ChangedByUserID.ToString().Trim().IsNullOrEmpty()) ? "" : nextOfKinDetails.ChangedByUserID.ToString().Trim(); tbxChangeOn.Text = (nextOfKinDetails.ChangedOn.ToString().Trim().IsNullOrEmpty()) ? "" : nextOfKinDetails.ChangedOn.ToString().Trim(); tbxNextOfKinID.Text = nextOfKinDetails.ID.ToString().Trim(); btnSaveNextKin.Text = "Edit"; } else { clearControl(); } } }
public static void Countries(DropDownList ddl) { OMMDataContext context = new OMMDataContext(); var country = from P in context.Countries orderby P.Name select new { P.ID, P.Name }; ddl.DataSource = country; ddl.DataTextField = "Name"; ddl.DataValueField = "ID"; ddl.DataBind(); InsertBlankOption(ddl); }