private void SelectFactoryByRegion()
{
try {
lstFactory.SelectedIndex = -1;
int regionID = 0;
if (ddlFactoryRegion.SelectedIndex != -1)
{
regionID = Convert.ToInt32(ddlFactoryRegion.SelectedItem.Value);
}
if (regionID != 0)
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["BeetConn"].ToString())) {
using (SqlDataReader dr = WSCSecurity.RegionFactoryGetByRegion(conn, regionID)) {
while (dr.Read())
{
string factoryNo = dr.GetInt32(dr.GetOrdinal("fty_factory_no")).ToString();
foreach (ListItem li in lstFactory.Items)
{
if (li.Value == factoryNo)
{
li.Selected = true;
}
}
}
}
}
}
}
catch (System.Exception ex) {
Common.CException wex = new Common.CException("Security.SelectFactoryByRegion", ex);
throw (wex);
}
}
private void FillRoles(DropDownList ddl)
{
try {
ddl.Items.Clear();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["BeetConn"].ToString())) {
using (SqlDataReader dr = WSCSecurity.SecurityRoleGetAll(conn)) {
System.Web.UI.WebControls.ListItem item = new ListItem("All", "0");
ddl.Items.Add(item);
while (dr.Read())
{
int roleID = dr.GetInt16(dr.GetOrdinal("sro_role_id"));
item = new ListItem(dr.GetString(dr.GetOrdinal("sro_role_name")),
roleID.ToString());
ddl.Items.Add(item);
}
}
}
ddl.SelectedIndex = 0;
}
catch (Exception ex) {
Common.CException wex = new Common.CException("Security.FillRoles", ex);
throw (wex);
}
}
protected void btnPrintForm_Click(object sender, EventArgs e)
{
const string METHOD_NAME = "btnPrintForm_Click";
try {
if (UsrCntSelector.IsChangedSHID)
{
Common.AppHelper.ShowWarning((HtmlGenericControl)Master.FindControl("divWarning"), "You changed the SHID without pressing the Find button. Please press Find.");
return;
}
// Give client the url to open the pdf
string filePath = "";
WSCSecurity auth = Globals.SecurityState;
string logoUrl = Page.MapPath(WSCReportsExec.GetReportLogo());
string pdfTempFolder = Page.MapPath(WSCReportsExec.GetPDFFolderPath());
string fileName = auth.UserID + "_" + "Field Contracting".Replace(" ", "");
filePath = WSCReports.rptFieldContracting.ReportPackager(UsrCntSelector.CropYear, "", "", "", UsrCntSelector.FieldID.ToString(), auth.UserID, fileName, logoUrl, pdfTempFolder);
if (filePath.Length > 0)
{
// convert file system path to virtual path
filePath = filePath.Replace(Common.AppHelper.AppPath(), Page.ResolveUrl("~")).Replace(@"\", @"/");
}
locPDF.Text = filePath;
}
catch (Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((PrimaryTemplate)Page.Master).ShowWarning(ex);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
const string METHOD_NAME = "btnSave_Click";
WSCSecurity auth = Globals.SecurityState;
if (auth.SecurityGroupName.ToUpper().IndexOf("AG ADMIN") == -1)
{
Common.AppHelper.ShowWarning((HtmlGenericControl)Master.FindControl("divWarning"), "Sorry, you are not authorized to update this information");
return;
}
try {
int bankID = 0;
if (txtBankID.Text.Length > 0)
{
bankID = Convert.ToInt32(txtBankID.Text);
}
WSCBank.BankSave(ref bankID, txtBankName.Text, txtBankNumber.Text,
txtShortName.Text, txtAddrLine1.Text, txtAddrLine2.Text, txtCity.Text,
Common.UILib.GetDropDownText(ddlState), txtZip.Text, txtContactName.Text, txtPhone.Text, txtFax.Text,
txtEmail.Text, txtOther.Text, chkIsActive.Checked, (Globals.SecurityState).UserName);
if (bankID > 0)
{
ShowBankDetail(bankID);
}
}
catch (System.Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((PrimaryTemplate)Page.Master).ShowWarning(ex);
}
}
protected void btnSaveAddress_Click(object sender, EventArgs e)
{
const string METHOD_NAME = "btnSaveAddress_Click";
try {
if (UsrCntSelector.IsChangedSHID)
{
Common.AppHelper.ShowWarning((HtmlGenericControl)Master.FindControl("divWarning"), "You changed the SHID without pressing the Find button. Please press Find.");
return;
}
WSCSecurity auth = Globals.SecurityState;
if (!UsrCntSelector.IsOwner)
{
Common.AppHelper.ShowWarning((HtmlGenericControl)Master.FindControl("divWarning"), "Sorry, you are not authorized to update this information");
return;
}
string email = txtEmail.Text;
if (!Common.CodeLib.ValidateEmail(email))
{
Common.AppHelper.ShowWarning((HtmlGenericControl)Master.FindControl("divWarning"), "Please enter a valid email address.");
return;
}
WSCMember.UpdateAddress(UsrCntSelector.MemberID, email, UsrCntSelector.FaxNumber, Globals.SecurityState.UserName);
UsrCntSelector.EmailAddress = email;
}
catch (Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((PrimaryTemplate)Page.Master).ShowWarning(ex);
}
}
private void DoPrintReady(object sender, CommandEventArgs e)
{
const string METHOD_NAME = "DoPrintReady";
try {
WSCSecurity auth = Globals.SecurityState;
string logoUrl = Page.MapPath(WSCReportsExec.GetReportLogo());
string pdfTempFolder = Page.MapPath(WSCReportsExec.GetPDFFolderPath());
string fileName = auth.UserID + "_" + ((HarvestReportTemplate)Master).ReportName.Replace(" ", "");
int cropYear = Convert.ToInt32(((HarvestReportTemplate)Master).CropYear);
int memberID = ((HarvestReportTemplate)Master).MemberID;
int shid = ((HarvestReportTemplate)Master).SHID;
string busName = ((HarvestReportTemplate)Master).BusName;
string pdf = WSCReports.rptContractSummary.ReportPackager(cropYear, memberID, shid, busName, fileName, logoUrl, pdfTempFolder);
if (pdf.Length > 0)
{
// convert file system path to virtual path
pdf = pdf.Replace(Common.AppHelper.AppPath(), Page.ResolveUrl("~")).Replace(@"\", @"/");
}
((HarvestReportTemplate)sender).LocPDF = pdf;
}
catch (System.Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((HarvestReportTemplate)Page.Master).ShowWarning(ex);
}
}
private void PaymentDescriptionSave(Label lblPayNum, DropDownList ddlFinished,
DropDownList ddlRequired, TextBox txtTransmittalDate,
TextBox txtPaymentDesc, TextBox txtPaymentDescID)
{
try {
// validate data
if (txtTransmittalDate.Text.Length > 0)
{
if (!Common.CodeLib.IsDate(txtTransmittalDate.Text))
{
WSCIEMP.Common.CWarning warn = new WSCIEMP.Common.CWarning("If you enter a Transmittal Date for payment number " +
lblPayNum.Text + ", it must be a valid date (mm/dd/yyyy).");
throw warn;
}
}
WSCSecurity auth = Globals.SecurityState;
WSCPayment.PaymentDescriptionSave(Int32.Parse(txtPaymentDescID.Text),
Int32.Parse(lblPayNum.Text), _cropYear,
txtPaymentDesc.Text,
(Common.UILib.GetDropDownText(ddlRequired) == "Yes" ? true : false),
(Common.UILib.GetDropDownText(ddlFinished) == "Yes" ? true : false),
txtTransmittalDate.Text, auth.UserName);
}
catch (Exception ex) {
Common.CException wex = new Common.CException("PaymentDescription.PaymentDescriptionSave", ex);
throw (wex);
}
}
private void GetContractList(int shid, int cropYear)
{
try {
ddlContractNumber.Items.Clear();
ddlSequence.Items.Clear();
WSCSecurity auth = Globals.SecurityState;
ddlContractNumber.Items.Add("");
List <ListBeetContractIDItem> stateList = WSCReportsExec.GetContractListSecure(MemberID, cropYear, auth.UserID);
foreach (ListBeetContractIDItem state in stateList)
{
ddlContractNumber.Items.Add(state.ContractNumber);
}
if (ddlContractNumber.Items.Count == 1)
{
ContractNumber = 0;
}
}
catch (Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + ".GetContractList", ex);
throw (wex);
}
}
private void DoPrintReady(object sender, CommandEventArgs e) {
const string METHOD_NAME = "DoPrintReady";
try {
WSCSecurity auth = Globals.SecurityState;
string logoUrl = Page.MapPath(WSCReportsExec.GetReportLogo());
string pdfTempFolder = Page.MapPath(WSCReportsExec.GetPDFFolderPath());
string fileName = auth.UserID + "_" + ((MasterReportTemplate)Master).ReportName.Replace(" ", "");
string cropYear = ((MasterReportTemplate)Master).CropYear;
string pdf = WSCReports.rptFieldAgronomy.ReportPackager(Convert.ToInt32(cropYear), _factoryList, _stationList, _contractList,
"", auth.UserID, fileName, logoUrl, pdfTempFolder);
if (pdf.Length > 0) {
// convert file system path to virtual path
pdf = pdf.Replace(Common.AppHelper.AppPath(), Page.ResolveUrl("~")).Replace(@"\", @"/");
}
((MasterReportTemplate)sender).LocPDF = pdf;
}
catch (System.Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((MasterReportTemplate)Page.Master).ShowWarning(ex);
}
}
protected void btnNew_Click(object sender, EventArgs e)
{
try {
if (UsrCntSelector.IsChangedSHID)
{
Common.AppHelper.ShowWarning((HtmlGenericControl)Master.FindControl("divWarning"), "You changed the SHID without pressing the Find button. Please press Find.");
return;
}
WSCSecurity auth = Globals.SecurityState;
if (!UsrCntSelector.IsOwner)
{
Common.AppHelper.ShowWarning((HtmlGenericControl)Master.FindControl("divWarning"), "Sorry, you are not authorized to update this information");
return;
}
NewContractAlertOn();
// This process creates a temporary new field, but Does Not clear or reset
// the sequence list for any current contract.
int seqMax = UsrCntSelector.SequenceNumberMax;
UsrCntSelector.ResetField();
UsrCntSelector.SetSequenceNumber(seqMax, 0);
ClearFieldDetail();
//txtOtherLldContracts.Text = "";
}
catch (Exception ex) {
ShowError(ex, "Unable to generate a New Field at this time.");
}
}
private void DoPrintReady(object sender, CommandEventArgs e)
{
const string METHOD_NAME = "DoPrintReady";
try {
WSCSecurity auth = Globals.SecurityState;
string logoUrl = Page.MapPath(WSCReportsExec.GetReportLogo());
string pdfTempFolder = Page.MapPath(WSCReportsExec.GetPDFFolderPath());
string fileName = auth.UserID + "_" + ((HarvestReportTemplate)Master).ReportName.Replace(" ", "");
int cropYear = Convert.ToInt32(((HarvestReportTemplate)Master).CropYear);
string shid = ((HarvestReportTemplate)Master).SHID.ToString();
DateTime activityFromDate = DateTime.MinValue;
DateTime activityToDate = DateTime.MinValue;
bool isLienInfoWanted = false;
WSCReports.rptEquityStatement rptEqStmt = new WSCReports.rptEquityStatement();
string pdf = rptEqStmt.ReportPackager(cropYear, DateTime.Now, shid, false, fileName, logoUrl, pdfTempFolder,
activityFromDate, activityToDate, isLienInfoWanted);
if (pdf.Length > 0)
{
// convert file system path to virtual path
pdf = pdf.Replace(Common.AppHelper.AppPath(), Page.ResolveUrl("~")).Replace(@"\", @"/");
}
((HarvestReportTemplate)sender).LocPDF = pdf;
}
catch (System.Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((HarvestReportTemplate)Page.Master).ShowWarning(ex);
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
const string METHOD_NAME = "btnDelete_Click";
WSCSecurity auth = Globals.SecurityState;
if (auth.SecurityGroupName.ToUpper().IndexOf("AG ADMIN") == -1)
{
Common.AppHelper.ShowWarning((HtmlGenericControl)Master.FindControl("divWarning"), "Sorry, you are not authorized to update this information");
return;
}
try {
int bankID = 0;
if (txtBankID.Text.Length > 0)
{
bankID = Convert.ToInt32(txtBankID.Text);
}
WSCBank.BankDelete(bankID, Globals.SecurityState.UserName);
ClearBankDetail();
}
catch (System.Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((PrimaryTemplate)Page.Master).ShowWarning(ex);
}
}
private void DoPrintReady(object sender, CommandEventArgs e)
{
const string METHOD_NAME = "DoPrintReady";
try {
WSCSecurity auth = Globals.SecurityState;
string logoUrl = Page.MapPath(WSCReportsExec.GetReportLogo());
string pdfTempFolder = Page.MapPath(WSCReportsExec.GetPDFFolderPath());
string fileName = txtFileName.Text;
// Get File Name
if (fileName.Length == 0)
{
Common.CWarning warn = new Common.CWarning("Please enter a file name.");
throw (warn);
}
string pdf = "";
string cropYear = ((MasterReportTemplate)Master).CropYear;
pdf = WSCReports.rptBeet1099.ReportPackager(cropYear, fileName, logoUrl, pdfTempFolder);
if (pdf.Length > 0)
{
// convert file system path to virtual path
pdf = pdf.Replace(Common.AppHelper.AppPath(), Page.ResolveUrl("~")).Replace(@"\", @"/");
}
((MasterReportTemplate)sender).LocPDF = pdf;
}
catch (System.Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((MasterReportTemplate)Page.Master).ShowWarning(ex);
}
}
private void DoPrintReady(object sender, CommandEventArgs e)
{
const string METHOD_NAME = "DoPrintReady";
try {
WSCSecurity auth = Globals.SecurityState;
string logoUrl = Page.MapPath(WSCReportsExec.GetReportLogo());
string pdfTempFolder = Page.MapPath(WSCReportsExec.GetPDFFolderPath());
string fileName = auth.UserID + "_" + ((MasterReportTemplate)Master).ReportName.Replace(" ", "");
string reportDate = txtCpsReportDate.Text;
string cropYear = ((MasterReportTemplate)Master).CropYear;
string shid = txtCpsSHID.Text;
if (reportDate == null || reportDate.Length == 0 || !Common.CodeLib.IsDate(reportDate))
{
Common.CWarning warn = new Common.CWarning("You must enter a valid report date, mm/dd/yyyy");
throw (warn);
}
WSCReports.rptContractPayeeSummary rpt = new WSCReports.rptContractPayeeSummary();
string pdf = rpt.ReportPackager(Int32.Parse(cropYear), DateTime.Parse(reportDate), shid, fileName, logoUrl, pdfTempFolder);
if (pdf.Length > 0)
{
// convert file system path to virtual path
pdf = pdf.Replace(Common.AppHelper.AppPath(), Page.ResolveUrl("~")).Replace(@"\", @"/");
}
((MasterReportTemplate)sender).LocPDF = pdf;
}
catch (System.Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((MasterReportTemplate)Page.Master).ShowWarning(ex);
}
}
private void DoPrintReady(object sender, CommandEventArgs e)
{
const string METHOD_NAME = "DoPrintReady";
try {
WSCSecurity auth = Globals.SecurityState;
string logoUrl = Page.MapPath(WSCReportsExec.GetReportLogo());
string pdfTempFolder = Page.MapPath(WSCReportsExec.GetPDFFolderPath());
string fileName = auth.UserID + "_" + ((HarvestReportTemplate)Master).ReportName.Replace(" ", "");
string contractNumber = Common.UILib.GetListText(lstCdsContract, ",");
// Check required fields: contract number
if (String.IsNullOrEmpty(contractNumber))
{
Common.CWarning warn = new Common.CWarning("You must select a Contract.");
throw (warn);
}
string cropYear = ((HarvestReportTemplate)Master).CropYear;
string pdf = WSCReports.rptContractDeliverySummary.ReportPackager(Convert.ToInt32(cropYear), Convert.ToInt32(contractNumber), fileName, logoUrl, pdfTempFolder);
if (pdf.Length > 0)
{
// convert file system path to virtual path
pdf = pdf.Replace(Common.AppHelper.AppPath(), Page.ResolveUrl("~")).Replace(@"\", @"/");
}
((HarvestReportTemplate)sender).LocPDF = pdf;
}
catch (System.Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((HarvestReportTemplate)Page.Master).ShowWarning(ex);
}
}
protected void btnUserEditSave_Click(object sender, EventArgs e)
{
const string METHOD_NAME = "btnUserEditSave_Click";
try {
int userID = 0;
if (grdUserResults.SelectedRow == null)
{
WSCIEMP.Common.CWarning warn = new WSCIEMP.Common.CWarning("Please select a user from the User Search Results");
throw (warn);
}
else
{
userID = Convert.ToInt32(grdUserResults.SelectedRow.Cells[0].Text);
}
// Save User's Region assignments and Role assignments
bool isActive = chkUserEditIsActive.Checked;
string roles = "";
foreach (ListItem li in lstUserEditRole.Items)
{
if (li.Selected)
{
if (roles.Length == 0)
{
roles = li.Value;
}
else
{
roles += "," + li.Value;
}
}
}
string regions = "";
foreach (ListItem li in lstUserEditRegion.Items)
{
if (li.Selected)
{
if (regions.Length == 0)
{
regions = li.Value;
}
else
{
regions += "," + li.Value;
}
}
}
WSCSecurity.UserSecuritySave(userID, isActive, roles, regions);
FillUserSearchGrid();
}
catch (System.Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((PrimaryTemplate)Page.Master).ShowWarning(ex);
}
}
private void DoPrintReady(object sender, CommandEventArgs e)
{
const string METHOD_NAME = "DoPrintReady";
try {
WSCSecurity auth = Globals.SecurityState;
string logoUrl = Page.MapPath(WSCReportsExec.GetReportLogoIconOnly());
string pdfTempFolder = Page.MapPath(WSCReportsExec.GetPDFFolderPath());
string fileName = auth.UserID + "_" + ((MasterReportTemplate)Master).ReportName.Replace(" ", "");
string cropYear = ((MasterReportTemplate)Master).CropYear;
string fromDateTest = txtFromDate.Text;
if (fromDateTest.Length == 0)
{
Common.CWarning warn = new Common.CWarning("Please enter a From Date.");
throw (warn);
}
DateTime fromDate;
try {
fromDate = Convert.ToDateTime(fromDateTest);
}
catch {
Common.CWarning warn = new Common.CWarning("Please enter a valid From Date.");
throw (warn);
}
string toDateTest = txtToDate.Text;
if (toDateTest.Length == 0)
{
Common.CWarning warn = new Common.CWarning("Please enter a To Date.");
throw (warn);
}
DateTime toDate;
try {
toDate = Convert.ToDateTime(toDateTest);
}
catch {
Common.CWarning warn = new Common.CWarning("Please enter a valid To Date.");
throw (warn);
}
string shid = txtShid.Text;
string pdf = WSCReports.rptDirectDeliveryStatement.ReportPackager(Convert.ToInt32(cropYear), fromDate, toDate,
shid, fileName, logoUrl, pdfTempFolder);
if (pdf.Length > 0)
{
// convert file system path to virtual path
pdf = pdf.Replace(Common.AppHelper.AppPath(), Page.ResolveUrl("~")).Replace(@"\", @"/");
}
((MasterReportTemplate)sender).LocPDF = pdf;
}
catch (System.Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((MasterReportTemplate)Page.Master).ShowWarning(ex);
}
}
private void DoPrintReady(object sender, CommandEventArgs e)
{
const string METHOD_NAME = "DoPrintReady";
try {
WSCSecurity auth = Globals.SecurityState;
string logoUrl = Page.MapPath(WSCReportsExec.GetReportLogo());
string pdfTempFolder = Page.MapPath(WSCReportsExec.GetPDFFolderPath());
string fileName = auth.UserID + "_" + ((MasterReportTemplate)Master).ReportName.Replace(" ", "");
string cropYear = ((MasterReportTemplate)Master).CropYear;
// Minimally you must at least pick a factory
if (_factoryList.Length == 0)
{
Common.CWarning warn = new Common.CWarning("You must select at least one Factory");
throw (warn);
}
// Must enter a valid from date
string fromDateTemp = txtFromDate.Text;
DateTime fromDate;
if (String.IsNullOrEmpty(fromDateTemp) || !DateTime.TryParse(fromDateTemp, out fromDate))
{
Common.CWarning warn = new Common.CWarning("You must enter a valid From Date.");
throw (warn);
}
string toDateTemp = txtToDate.Text;
DateTime toDate;
if (String.IsNullOrEmpty(toDateTemp) || !DateTime.TryParse(toDateTemp, out toDate))
{
Common.CWarning warn = new Common.CWarning("You must enter a valid To Date.");
throw (warn);
}
bool isPosted = chkPosted.Checked;
bool isPreview = chkPreview.Checked;
bool isHardCopy = chkWebHardCopyOnly.Checked;
bool isEmail = chkEmail.Checked;
bool isFax = false; // chkFax.Checked;
string pdf = WSCReports.rptDailyGrowerTareDetailMaster.ReportPackager(Convert.ToInt32(cropYear), fromDate, toDate, _factoryList,
_stationList, _contractList, isPosted, isPreview, isHardCopy, isEmail, isFax, fileName, logoUrl, pdfTempFolder);
if (pdf.Length > 0)
{
// convert file system path to virtual path
pdf = pdf.Replace(Common.AppHelper.AppPath(), Page.ResolveUrl("~")).Replace(@"\", @"/");
}
((MasterReportTemplate)sender).LocPDF = pdf;
}
catch (System.Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((MasterReportTemplate)Page.Master).ShowWarning(ex);
}
}
protected void btnChange_Click(object sender, EventArgs e)
{
const string METHOD_NAME = "btnChange_Click";
try {
// Did page load already throw an error?
if (((HtmlGenericControl)Master.FindControl("divWarning")).InnerHtml.Length > 0)
{
return;
}
if (SHID.ToString() != txtSHID.Text)
{
Common.CWarning wex = new Common.CWarning("Please press the Find button to ensure you're editing the correct Shareholder before trying to Save.");
throw (wex);
}
if (SHID == 0)
{
Common.CWarning wex = new Common.CWarning("Please enter a SHID and press the Find button.");
throw (wex);
}
WSCSecurity auth = Globals.SecurityState;
if (auth.AuthorizeShid(SHID, CropYear) < WSCSecurity.ShsPermission.shsReadWrite)
{
Common.CWarning warn = new Common.CWarning("Sorry, you are not authorized to update this information");
throw (warn);
}
if (EmailAddress.Length == 0)
{
Common.CWarning warn = new Common.CWarning("Please create an email address for this member.");
throw (warn);
}
string warnMsg = null;
WSCMember.ResetPassword(SHID.ToString(), EmailAddress, ref warnMsg);
if (warnMsg == null)
{
Common.AppHelper.ShowConfirmation((HtmlGenericControl)Master.FindControl("divWarning"), "Password has been reset and sent to you via email.");
}
else
{
Common.CWarning warn = new Common.CWarning(warnMsg);
throw (warn);
}
}
catch (System.Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((PrimaryTemplate)Page.Master).ShowWarning(ex);
}
}
protected void btnAddField_Click(object sender, EventArgs e)
{
try {
if (UsrCntSelector.IsChangedSHID)
{
Common.AppHelper.ShowWarning((HtmlGenericControl)Master.FindControl("divWarning"), "You changed the SHID without pressing the Find button. Please press Find.");
return;
}
WSCSecurity auth = Globals.SecurityState;
if (!UsrCntSelector.IsOwner)
{
Common.AppHelper.ShowWarning((HtmlGenericControl)Master.FindControl("divWarning"), "Sorry, you are not authorized to update this information");
return;
}
// Add the field if it has a valid lld_id
if (UsrCntSelector.LldID == 0)
{
Common.AppHelper.ShowWarning((HtmlGenericControl)Master.FindControl("divWarning"), "You must first Save this field before adding it to the Contract.");
return;
}
if (UsrCntSelector.CntLLDID > 0)
{
Common.AppHelper.ShowWarning((HtmlGenericControl)Master.FindControl("divWarning"), "This field is already contracted for this season.");
return;
}
if (!(UsrCntSelector.ContractID > 0))
{
Common.AppHelper.ShowWarning((HtmlGenericControl)Master.FindControl("divWarning"), "You must first select a contract before adding a field to the contract.");
return;
}
// okay, add the field to the contract.
int cntlld_cntlld_id_out = 0;
WSCField.CntLldAddField(UsrCntSelector.ContractID, UsrCntSelector.LldID, UsrCntSelector.CropYear,
auth.UserName, ref cntlld_cntlld_id_out);
// Bounce sequence number to max value
if (cntlld_cntlld_id_out > 0)
{
int newMaxSeq = UsrCntSelector.SequenceNumberMax + 1;
UsrCntSelector.SetSequenceNumber(newMaxSeq, newMaxSeq);
}
ShowContractFieldDetail();
}
catch (Exception ex) {
ShowError(ex, "Unable to Add this Field to this Contract at this time.");
}
}
private void FillEditArea()
{
try {
int userID = Convert.ToInt32(grdUserResults.SelectedRow.Cells[0].Text);
// Add User's Roles
lstUserEditRole.SelectedIndex = -1;
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["BeetConn"].ToString())) {
using (SqlDataReader dr = WSCSecurity.SecurityGetUserRoles(conn, userID)) {
while (dr.Read())
{
string roleID = dr.GetInt32(dr.GetOrdinal("sro_role_id")).ToString();
foreach (ListItem li in lstUserEditRole.Items)
{
if (li.Value == roleID)
{
li.Selected = true;
break;
}
}
}
}
// Add User's Regions
lstUserEditRegion.SelectedIndex = -1;
using (SqlDataReader dr = WSCSecurity.SecurityGetUserRegions(conn, userID)) {
while (dr.Read())
{
string regionID = dr.GetInt32(dr.GetOrdinal("rgn_region_id")).ToString();
foreach (ListItem li in lstUserEditRegion.Items)
{
if (li.Value == regionID)
{
li.Selected = true;
break;
}
}
}
}
}
// Check whether user is active
string isActive = grdUserResults.SelectedRow.Cells[3].Text;
chkUserEditIsActive.Checked = (isActive == "Y");
}
catch (Exception ex) {
Common.CException wex = new Common.CException("Security.FillEditArea", ex);
throw (wex);
}
}
protected void btnPost_Click(object sender, EventArgs e)
{
const string METHOD_NAME = "btnPost_Click";
/*
* <?xml version="1.0" standalone="yes" ?>
* <NewDataSet>
* <Table>
* <Contract>10018</Contract>
* <Amount>43.22</Amount>
* <Deduction>1,2</Deduction>
* </Table>
* </NewDataSet>
*/
try {
string xmlData = "";
// Retrieve the xml document of deductions: contract, amount, and deduction.
string selectedPath = lblOrigPath.Text;
if (selectedPath.StartsWith(FILE_LABEL))
{
selectedPath = selectedPath.Substring(FILE_LABEL.Length);
}
string fileName = System.IO.Path.GetFileName(selectedPath);
string filePath = Server.MapPath(@"~/PDF") + @"\" + fileName;
string xmlFilePath = filePath.Replace(System.IO.Path.GetExtension(filePath), ".xml");
using (System.IO.StreamReader reader = new StreamReader(xmlFilePath)) {
xmlData = reader.ReadToEnd().Replace("\r\n", "");
}
int cropYear = Convert.ToInt32(Common.UILib.GetDropDownText(ddlCropYear));
// Send this xml document, the crop year, and user name to the database.
WSCSecurity auth = Globals.SecurityState;
WSCAdmin.ContractDeductionSave(cropYear, auth.UserName, xmlData);
// We only get here if everything works.
lblOrigPath.Visible = true;
lblOrigPath.Text = "Successfully Posted Deductions for: " + fileName;
}
catch (Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((PrimaryTemplate)Page.Master).ShowWarning(ex);
}
}
private void DoPrintReady(object sender, CommandEventArgs e)
{
const string METHOD_NAME = "DoPrintReady";
try {
WSCSecurity auth = Globals.SecurityState;
string logoUrl = Page.MapPath(WSCReportsExec.GetReportLogo());
string pdfTempFolder = Page.MapPath(WSCReportsExec.GetPDFFolderPath());
string fileName = auth.UserID + "_" + ((MasterReportTemplate)Master).ReportName.Replace(" ", "");
string cropYear = ((MasterReportTemplate)Master).CropYear;
string letterDate = txtLlLetterDate.Text;
DateTime dtLetterDate = DateTime.Now;
try {
dtLetterDate = Convert.ToDateTime(letterDate);
}
catch {
Common.CWarning warn = new WSCIEMP.Common.CWarning("Please enter a valid Leter Date.");
throw(warn);
}
string deadlineDate = txtLlDeadlineDate.Text;
DateTime dtDeadlineDate = DateTime.Now;
try {
dtDeadlineDate = Convert.ToDateTime(deadlineDate);
}
catch {
Common.CWarning warn = new WSCIEMP.Common.CWarning("Please enter a valid Deadline Date.");
throw(warn);
}
string pdf = WSCReports.rptLandownerLetter.ReportPackager(Convert.ToInt32(cropYear), dtLetterDate, dtDeadlineDate,
_factoryList, _stationList, _contractList, fileName, logoUrl, pdfTempFolder);
if (pdf.Length > 0)
{
// convert file system path to virtual path
pdf = pdf.Replace(Common.AppHelper.AppPath(), Page.ResolveUrl("~")).Replace(@"\", @"/");
}
((MasterReportTemplate)sender).LocPDF = pdf;
}
catch (System.Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((MasterReportTemplate)Page.Master).ShowWarning(ex);
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try {
if (UsrCntSelector.IsChangedSHID)
{
Common.AppHelper.ShowWarning((HtmlGenericControl)Master.FindControl("divWarning"), "You changed the SHID without pressing the Find button. Please press Find.");
return;
}
WSCSecurity auth = Globals.SecurityState;
if (!UsrCntSelector.IsOwner)
{
Common.AppHelper.ShowWarning((HtmlGenericControl)Master.FindControl("divWarning"), "Sorry, you are not authorized to update this information");
return;
}
// Delete this Field \ Land Description when it has a valid LLD_ID.
// Otherwise just blow it off and do a little reset.
int lld_id = UsrCntSelector.LldID;
if (lld_id > 0)
{
WSCField.LegalLandDescDelete(lld_id);
}
else
{
Common.AppHelper.ShowWarning((HtmlGenericControl)Master.FindControl("divWarning"), "You must be viewing a field already in the system in order to delete it.");
return;
}
int seq = 0;
int seqMax = 0;
if (UsrCntSelector.SequenceNumber > 0)
{
seq = 1;
seqMax = UsrCntSelector.SequenceNumberMax - 1;
}
ClearFieldDetail();
UsrCntSelector.InitControl(UsrCntSelector.SHID, UsrCntSelector.CropYear, UsrCntSelector.ContractNumber, seq);
}
catch (Exception ex) {
ShowError(ex, @"Unable to Delete this Land Description \ Field at this time.");
}
}
private void DoPrintReady(object sender, CommandEventArgs e)
{
const string METHOD_NAME = "DoPrintReady";
try {
WSCSecurity auth = Globals.SecurityState;
string logoUrl = Page.MapPath(WSCReportsExec.GetReportLogo());
string pdfTempFolder = Page.MapPath(WSCReportsExec.GetPDFFolderPath());
string fileName = txtCcFileName.Text;
// Check required fields: crop year, start #, stop #, file name.
string contractNumberStart = txtCcContractNumberStart.Text;
if (contractNumberStart.Length == 0)
{
Common.CWarning warn = new Common.CWarning("Please enter the First Contract Number.");
throw (warn);
}
string contractNumberStop = txtCcContractNumberStop.Text;
if (contractNumberStop.Length == 0)
{
Common.CWarning warn = new Common.CWarning("Please enter the Last Contract Number.");
throw (warn);
}
if (fileName.Length == 0)
{
Common.CWarning warn = new Common.CWarning("Please enter a file name.");
throw (warn);
}
string cropYear = ((MasterReportTemplate)Master).CropYear;
string pdf = WSCReports.rptContractCards.ReportPackager(cropYear, contractNumberStart, contractNumberStop, fileName, logoUrl, pdfTempFolder);
if (pdf.Length > 0)
{
// convert file system path to virtual path
pdf = pdf.Replace(Common.AppHelper.AppPath(), Page.ResolveUrl("~")).Replace(@"\", @"/");
}
((MasterReportTemplate)sender).LocPDF = pdf;
}
catch (System.Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((MasterReportTemplate)Page.Master).ShowWarning(ex);
}
}
protected void btnCYOk_Click(object sender, EventArgs e)
{
const string METHOD_NAME = "btnCYOk_Click";
try {
string pdfFile = "";
int cropYear = Convert.ToInt32(Common.UILib.GetDropDownText(ddlCropYear)); // txtCYFirstCropYear
string lastcy = txtLastCropYear.Text;
if (lastcy == "")
{
lastcy = cropYear.ToString();
}
int lastCropYear = Convert.ToInt32(lastcy); // if we didn't capture the last crop year, let the guy print using from/to cy equal
// the current crop year. Then user can print and report this as a bug.
GridViewRow row = grdTransfers.SelectedRow;
if (row == null)
{
Common.CWarning warn = new WSCIEMP.Common.CWarning("Before printing, please select a transfer from the Transferee -- Temp Transfer listing.");
throw (warn);
}
int shareTransferID = Convert.ToInt32(row.Cells[(int)TempTransferCols.colShareTransferID].Text);
WSCSecurity auth = Globals.SecurityState;
pdfFile = ConfigurationManager.AppSettings["appControl.rptServer"].ToString() +
"?RPTSEL=TEMPTRANSFER" +
"&USR="******"&PRMS=" + Common.CodeLib.EncodeString(ConfigurationManager.ConnectionStrings["BeetConn"].ToString()) +
"^" + cropYear.ToString() + // int first crop year: actual crop year.
"^" + lastCropYear.ToString() + // int last crop year
"^-1" + // int contractID; -1 when no contract
"^" + shareTransferID.ToString() + // int shareTransferID
"^"; // string save path
locPDF.Text = pdfFile.Replace("localhost", System.Environment.MachineName);
//uplCropYearFinder.Update();
//CloseAndPrint();
}
catch (System.Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((PrimaryTemplate)Page.Master).ShowWarning(ex);
}
}
private void DoPrintReady(object sender, CommandEventArgs e)
{
const string METHOD_NAME = "DoPrintReady";
try {
WSCSecurity auth = Globals.SecurityState;
string logoUrl = Page.MapPath(WSCReportsExec.GetReportLogo());
string pdfTempFolder = Page.MapPath(WSCReportsExec.GetPDFFolderPath());
string fileName = auth.UserID + "_" + ((HarvestReportTemplate)Master).ReportName.Replace(" ", "");
int memberID = ((HarvestReportTemplate)Master).MemberID;
string cropYear = ((HarvestReportTemplate)Master).CropYear;
int shid = ((HarvestReportTemplate)Master).SHID;
string busName = ((HarvestReportTemplate)Master).BusName;
string deliveryDate = Common.UILib.GetListText(lstDdsDeliveryDay, ",");
if (shid == 0)
{
Common.CWarning warn = new Common.CWarning("Please select a SHID.");
throw (warn);
}
if (deliveryDate.Length == 0)
{
Common.CWarning warn = new Common.CWarning("Please select a Delivery Date.");
throw (warn);
}
string pdf = WSCReports.rptDeliveryByDaySummary.ReportPackager(Convert.ToInt32(cropYear), memberID, shid,
busName, deliveryDate, fileName, logoUrl, pdfTempFolder);
if (pdf.Length > 0)
{
// convert file system path to virtual path
pdf = pdf.Replace(Common.AppHelper.AppPath(), Page.ResolveUrl("~")).Replace(@"\", @"/");
}
((HarvestReportTemplate)sender).LocPDF = pdf;
}
catch (System.Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((HarvestReportTemplate)Page.Master).ShowWarning(ex);
}
}
protected void btnFactorySave_Click(object sender, EventArgs e)
{
const string METHOD_NAME = "btnFactorySave_Click";
try {
int regionID = 0;
if (ddlFactoryRegion.SelectedItem == null)
{
WSCIEMP.Common.CWarning warn = new WSCIEMP.Common.CWarning("Please select Region from the list.");
throw (warn);
}
else
{
if (ddlFactoryRegion.SelectedItem.Text.ToUpper() == "ALL COOP")
{
WSCIEMP.Common.CWarning warn = new WSCIEMP.Common.CWarning("Please do not associate factories to the region All Coop.");
throw (warn);
}
regionID = Convert.ToInt32(ddlFactoryRegion.SelectedItem.Value);
}
string factories = "";
foreach (ListItem li in lstFactory.Items)
{
if (li.Selected)
{
if (factories.Length == 0)
{
factories = li.Value;
}
else
{
factories += "," + li.Value;
}
}
}
WSCSecurity.UserSecurityRegionFactorySave(regionID, factories);
}
catch (System.Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((PrimaryTemplate)Page.Master).ShowWarning(ex);
}
}
protected void btnSaveContract_Click(object sender, EventArgs e)
{
const string METHOD_NAME = "btnSaveContract_Click";
try {
if (UsrCntSelector.IsChangedSHID)
{
Common.AppHelper.ShowWarning((HtmlGenericControl)Master.FindControl("divWarning"), "You changed the SHID without pressing the Find button. Please press Find.");
return;
}
if (UsrCntSelector.FieldID == 0)
{
Common.AppHelper.ShowWarning((HtmlGenericControl)Master.FindControl("divWarning"), " You cannot Save unless you are viewing a contracted field.");
return;
}
WSCSecurity auth = Globals.SecurityState;
if (!UsrCntSelector.IsOwner)
{
Common.AppHelper.ShowWarning((HtmlGenericControl)Master.FindControl("divWarning"), "Sorry, you are not authorized to update this information");
return;
}
WSCField.FieldContractingSave(UsrCntSelector.FieldID,
Common.UILib.GetDropDownText(ddlRotationLength),
Common.UILib.GetDropDownText(ddlPriorCrop), Common.UILib.GetDropDownText(ddlBeetYears),
chkRhizomania.Checked, chkAphanomyces.Checked, chkCurlyTop.Checked,
chkFusarium.Checked, chkRhizoctonia.Checked, chkNematode.Checked,
chkCercospora.Checked, chkRootAphid.Checked, chkPowderyMildew.Checked,
Common.UILib.GetDropDownText(ddlPostAphanomyces), Common.UILib.GetDropDownText(ddlPostCercospora), Common.UILib.GetDropDownText(ddlPostCurlyTop),
Common.UILib.GetDropDownText(ddlPostFusarium), Common.UILib.GetDropDownText(ddlPostNematode), Common.UILib.GetDropDownText(ddlPostPowderyMildew),
Common.UILib.GetDropDownText(ddlPostRhizoctonia), Common.UILib.GetDropDownText(ddlPostRhizomania), Common.UILib.GetDropDownText(ddlPostRootAphid),
chkPostWater.Checked, Common.UILib.GetDropDownText(ddlWaterSource), Common.UILib.GetDropDownText(ddlIrrigation),
Common.UILib.GetDropDownText(ddlLandOwnership), Common.UILib.GetDropDownText(ddlTillage), auth.UserName);
ShowFieldDetail(UsrCntSelector.CntLLDID);
}
catch (Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((PrimaryTemplate)Page.Master).ShowWarning(ex);
}
}
private void DoPrintReady(object sender, CommandEventArgs e)
{
const string METHOD_NAME = "DoPrintReady";
try {
WSCSecurity auth = Globals.SecurityState;
string logoUrl = Page.MapPath(WSCReportsExec.GetReportLogo());
string pdfTempFolder = Page.MapPath(WSCReportsExec.GetPDFFolderPath());
string fileName = auth.UserID + "_" + ((MasterReportTemplate)Master).ReportName.Replace(" ", "");
string cropYear = ((MasterReportTemplate)Master).CropYear;
string statementDate = txtStatementDate.Text.Trim();
string shid = txtPsSHID.Text;
string fromShid = txtPsFromSHID.Text;
string toShid = txtPsToSHID.Text;
string footerText = rptParam_Footer.Value;
string paymentDesc = Common.UILib.GetDropDownText(ddlPsPaymentDesc);
if (paymentDesc.StartsWith("None"))
{
Common.CWarning warn = new Common.CWarning("Please select a Payment having a Payment Date.");
throw (warn);
}
int paymentID = Convert.ToInt32(Common.UILib.GetDropDownValue(ddlPsPaymentDesc));
bool isCumulative = chkPsIsPaymentSummaryCumulative.Checked;
string pdf = WSCReports.rptPaymentSummary.ReportPackager(Convert.ToInt32(cropYear), statementDate, shid, fromShid, toShid,
paymentID, isCumulative, footerText, fileName, logoUrl, pdfTempFolder);
if (pdf.Length > 0)
{
// convert file system path to virtual path
pdf = pdf.Replace(Common.AppHelper.AppPath(), Page.ResolveUrl("~")).Replace(@"\", @"/");
}
((MasterReportTemplate)sender).LocPDF = pdf;
}
catch (System.Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((MasterReportTemplate)Page.Master).ShowWarning(ex);
}
}
