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);
}
