protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//TO-DO: Setting the session object which will be later removed
//Session["UserId"] = 2002;
// Remove the above portion
var companyBal = new CompanyBAL();
var company = companyBal.GetCompanyDetails(Convert.ToInt32(Session["UserId"]));
// Populate the Company Details Division
LabelCompanyId.Text = company.CompanyId.ToString();
LabelCompanyName.Text = company.CompanyName;
LabelAddress.Text = company.Address;
LabelCity.Text = new CityBAL().GetCity(company.CityId);
LabelContactPersonName.Text = company.ContactPersonName;
LabelContactPersonEmail.Text = company.ContactPersonEmail;
LabelContactPersonPhone.Text = company.ContactPersonPhone;
//Populating Job Details View Page
PopulateGridViewDisplayJobDetails(Convert.ToInt32(Session["UserId"]));
GridViewDisplayJobDetails.SelectedIndexChanged += GridViewDisplayJobDetails_SelectedIndexChanged;
//Populating Jobs Added Page
PopulateDropDownListJobCategory();
}
}
protected void ButtonSubmitCompany_Click(object sender, EventArgs e)
{
if (new CredentialBAL().IsCredentialPresent(TextBoxUsernameCompany.Text))
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "alert('Username taken!');", true);
TextBoxUsernameCompany.BorderColor = Color.Red;
return;
}
Credential credential = new Credential
{
UserName = TextBoxUsernameCompany.Text,
Password = TextBoxCompanyPassword.Text
};
Company company = new Company
{
CompanyName = TextBoxCompanyName.Text,
Address = TextBoxAddressCompany.Text,
ContactPersonName = TextBoxCompanyContactPersonName.Text,
ContactPersonEmail = TextBoxCompanyContactPersonEmail.Text,
ContactPersonPhone = TextBoxCompanyContactPersonPhone.Text,
CityId = Convert.ToInt32(DropDownListCompanyCity.SelectedValue)
};
CompanyBAL companyBal = new CompanyBAL();
companyBal.SaveCompany(company, credential);
//TO-DO: Check for the validity of username from the Credentials DB
//ScriptManager.RegisterStartupScript(this.Page,Page.GetType(),"text","alert('Registered Successfully! Please Login.');",true);
Response.Redirect("login.aspx");
}
public frmCompanyProfile()
{
InitializeComponent();
yearbal = new YearBAL();
year = new tbl_YEAR();
fxsp = new tbl_000_FXSP();
compbal = new CompanyBAL();
comp = new tbl_000_COMPANY();
err = new ErrorProviderExtended();
}
public ActionResult Create(BaseModel baseModel)
{
CompanyModel companyModel = new CompanyModel();
companyModel.CopyBaseModel(baseModel);
using (CompanyBAL companyBAL = new CompanyBAL(ContextInfo))
{
companyBAL.PrepareCompanyModel(companyModel);
}
return(View("Create", companyModel));
}
public JsonResult GetCompanies(DataTableSearchParameters <Nullable <bool> > dataTableSearchParameters)
{
GenericListModel <CompanyModel> baseListModel = new GenericListModel <CompanyModel>();
using (CompanyBAL companyBAL = new CompanyBAL(ContextInfo))
{
baseListModel = companyBAL.GetSearchCompaniesList(dataTableSearchParameters);
}
return(Json(new
{
baseModel = baseListModel
}, JsonRequestBehavior.AllowGet));
}
public JsonResult GetCompaniesBySelect2Parameters(Select2Parameters <bool> select2Parameters)
{
GenericListModel <CompanyModel> baseListModel = new GenericListModel <CompanyModel>();
using (CompanyBAL companyBAL = new CompanyBAL(ContextInfo))
{
baseListModel = companyBAL.GetCompanies(select2Parameters);
}
return(Json(new
{
baseModel = baseListModel
}, JsonRequestBehavior.AllowGet));
}
public ActionResult View(string id)
{
CompanyModel companyModel = new CompanyModel();
companyModel.Id = id;
using (CompanyBAL companyBAL = new CompanyBAL(ContextInfo))
{
companyBAL.GetCompanyModel(companyModel);
// companyBAL.PrepareCompanyModel(companyModel);
}
return(View(companyModel));
}
private void TestConnection()
{
try
{
AssignRecords(true);
SetBALConnection.SetConnectionString(AppConnectionString.ConnectionString);
compbal = new CompanyBAL();
comp = compbal.GetByID(1);
AppSettings.CompanyProfile = comp;
}
catch (Exception ex)
{
throw ex;
}
}
// GET: Company/Edit/5
public ActionResult Edit(string id, BaseModel baseModel)
{
CompanyModel companyModel = new CompanyModel();
companyModel.CopyBaseModel(baseModel);
companyModel.Id = id;
using (CompanyBAL companyBAL = new CompanyBAL(ContextInfo))
{
companyBAL.GetCompanyModel(companyModel);
companyBAL.PrepareCompanyModel(companyModel);
}
return(View(companyModel));
}
public ActionResult Delete(CompanyModel companyModel)
{
using (CompanyBAL companyBAL = new CompanyBAL(ContextInfo))
{
companyBAL.Delete(companyModel);
if (companyModel.HasErrorByType())
{
companyBAL.GetCompanyModel(companyModel);
// companyBAL.PrepareCompanyModel(companyModel);
}
}
return(View(companyModel));
}
public ActionResult Create(CompanyModel companyModel)
{
using (CompanyBAL companyBAL = new CompanyBAL(ContextInfo))
{
if (ModelState.IsValid)
{
companyBAL.Create(companyModel);
}
if (companyModel.HasErrorByType(LMYFrameWorkMVC.Common.LookUps.ErrorType.Critical) || companyModel.HasSuccess(LMYFrameWorkMVC.Common.LookUps.SuccessType.Full))
{
return(base.RedirectToActionWithData(new Dictionary <string, object> {
{ "baseModel", companyModel }
}));
}
companyBAL.PrepareCompanyModel(companyModel);
}
return(View("Create", companyModel));
}
protected void GridViewDisplayJobDetails_SelectedIndexChanged(object sender, EventArgs e)
{
//Display The Jobs applied here
//ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "alert('Index Changed!');",
// true);
var jobId = Convert.ToInt32(GridViewDisplayJobDetails.SelectedRow.Cells[1].Text.Trim());
CompanyBAL companyBal = new CompanyBAL();
var table = companyBal.GetJobApplicants(jobId);
if (table.Rows.Count > 0)
{
GridViewJobApplicants.DataSource = table;
GridViewJobApplicants.DataBind();
LabelJobApplicantsHeader.InnerText = "" + jobId + ":" +
GridViewDisplayJobDetails.SelectedRow.Cells[3].Text.Trim() + " - Job Applicants";
LabelHidden.InnerText = "divJobApplicants";
}
else
{
LabelHidden.InnerText = "divViewJobs";
}
}
private static void TestConnection()
{
Thread t = new Thread(new ThreadStart(Loading));
t.Start(); //open splash
try
{
CompanyBAL compbal;
compbal = new CompanyBAL();
AppSettings.CompanyProfile = compbal.GetByID(1);
AppSettings.AppConnected = true;
Preloader.Preload(); //Preload Report
//Cache.Refresh();
t.Abort(); //close splash
}
catch (Exception ex)
{
t.Abort(); //close splash
MessageHelpers.ShowError(ex.Message);
AppSettings.AppConnected = false;
}
}
private void ReportView()
{
try
{
CompanyBAL objCompanyBal = new CompanyBAL();
PaymentReviewBAL paymentBAL = new PaymentReviewBAL();
DataTable dtPaymentReview = new DataTable();
crPaymentReview1 crPayment = new crPaymentReview1();
frmPaymenrReportViewer paymentViewer = new frmPaymenrReportViewer();
LoadCommonInfo CmmInfo = new LoadCommonInfo();
BranchManagementBAL objBranchManagement = new BranchManagementBAL();
dtPaymentReview = paymentBAL.GneratePaymentReviewByBranchWise(dtpFromDate.Value, dtpToDate.Value);
//_filterdColumnName = dtPaymentReview.Columns[1].ToString();
//RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(dtPaymentReview, _filterdColumnName, ResourceName.Branch_wise_Payment_Review);
//dtPaymentReview = obj.GetRecordLevelFilteredData();
crPayment.SetDataSource(dtPaymentReview);
///// Load Company Name
((TextObject)crPayment.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = CmmInfo.ShowCompanyName();
///// Load Branch Name
((TextObject)crPayment.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = objCompanyBal.GetHeadofficeInfo();
////Load Date
((TextObject)crPayment.ReportDefinition.Sections[2].ReportObjects["txtReportDuration"]).Text = "Review Duration: " + dtpFromDate.Value.ToString("dd-MM-yyyy") + " " + dtpToDate.Value.ToString("dd-MM-yyyy");
((TextObject)crPayment.ReportDefinition.Sections[2].ReportObjects["txtBranch"]).Text = "Branch : " + objBranchManagement.GetBranchName();
paymentViewer.crvPaymentReview.ReportSource = crPayment;
paymentViewer.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void ReportView()
{
if (ddlCompanyShortCode.Text == string.Empty)
{
MessageBox.Show("Please Select Instrument Short Code");
return;
}
DataTable dt = new DataTable();
ShareBalanceBAL reportBAL = new ShareBalanceBAL();
LoadCommonInfo CmmInfo = new LoadCommonInfo();
CompanyBAL objCompanyBal = new CompanyBAL();
string compShortCode = ddlCompanyShortCode.Text;
DateTime fromDate = dtStartDate.Value;
DateTime toDate = dtEndDate.Value;
dt = reportBAL.GetCompanyWiseShareTradeList(compShortCode, fromDate, toDate);
crInstruwiseShareTradeList reportFile = new crInstruwiseShareTradeList();
reportFile.SetDataSource(dt);
((TextObject)reportFile.ReportDefinition.Sections[1].ReportObjects["txtCompanyName"]).Text = CmmInfo.ShowCompanyName();
((TextObject)reportFile.ReportDefinition.Sections[1].ReportObjects["txtBranchName"]).Text = objCompanyBal.GetHeadofficeInfo();
((TextObject)reportFile.ReportDefinition.Sections[1].ReportObjects["txtReportDate"]).Text = "From " + fromDate.ToShortDateString() + " To " + toDate.ToShortDateString();
((TextObject)reportFile.ReportDefinition.Sections[1].ReportObjects["txtInstruName"]).Text = Convert.ToString(dt.Rows[0][2]);
((TextObject)reportFile.ReportDefinition.Sections[1].ReportObjects["txtInstruCode"]).Text = Convert.ToString(dt.Rows[0][1]);
((TextObject)reportFile.ReportDefinition.Sections[1].ReportObjects["txtInstruGroup"]).Text = Convert.ToString(dt.Rows[0][3]);
frmInstruwiseShareTradeListViewer reportViewer = new frmInstruwiseShareTradeListViewer();
reportViewer.crvInstruWiseShareTradeList.ReportSource = reportFile;
reportViewer.Show();
}
