/// <summary>
/// Sets the User's location and access based on what is stored in the database. See UtilityCashFlow
/// </summary>
protected void SetUpUser()
{
this.isAdminUser = utility.GetIsAdminUser();
this.isCMUser = utility.GetIsCMUser();
this.isDeptUser = utility.GetIsDeptUser();
this.location = utility.GetLocation();
this.department = utility.GetDepartment();
if (!this.isAdminUser && !this.isCMUser && !this.isDeptUser)
{
Response.Redirect(VariablesCashManager.NO_ACCESS_PAGE);
}
if (isDeptUser)
{
LabelCMPriority.Visible = false;
RadioButtonListCMPriority.Visible = false;
if (this.location.Equals("All"))
{
RadioButtonListLocation.Visible = true;
LabelLocation.Visible = true;
}
else if (this.location.Equals("2"))
{
RadioButtonListLocation.Visible = true;
LabelLocation.Visible = true;
RadioButtonListLocation.Items.FindByValue("All").Attributes.Add("Style", "display: none");
RadioButtonListLocation.Items.FindByValue("1").Attributes.Add("Style", "display: none");
}
else
{
LabelLocation.Visible = false;
RadioButtonListLocation.Visible = false;
}
LabelPayFlag.Visible = false;
RadioButtonListPayFlag.Visible = false;
LabelPaymentMethod.Visible = false;
RadioButtonListPaymentMethod.Visible = false;
LabelDepartments.Visible = false;
CheckBoxDepartmentsAll.Visible = false;
}
if (isAdminUser || isCMUser)
{
RadioButtonListLocation.Visible = true;
LabelLocation.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
Page.MaintainScrollPositionOnPostBack = true;
String userName = Page.User.Identity.Name.ToString().Substring(8);
//userName = "******";
utility = new UtilityCashFlow(userName);
SetUpUser();
int totalRows = 0;
if (Request["loc"] != null)
{
utility.SetLocation(Request["loc"].ToString());
}
if (Request["dept"] != null)
{
utility.SetDepartment(Request["dept"].ToString());
}
try
{
totalRows = dataGridView.Rows.Count;
}
catch (SqlException sqle)
{
Logger.QuickLog(errorLogFileName, sqle.Message, "Page_Load()", "int totalRows = dataGridView.Rows.Count");
}
if (utility.GetIsDeptUser())
{
data.Attributes.Add("class", "cashManagerData cashManagerDataDept");
options.Attributes.Add("class", "optionsCashManagerDeptUser");
}
else if (utility.GetIsCMUser())
{
data.Attributes.Add("class", "cashManagerData cashManagerDataCM");
options.Attributes.Add("class", "optionsCashManagerCMUser");
}
else
{
data.Attributes.Add("class", "cashManagerData cashManagerDataAdmin");
options.Attributes.Add("class", "optionsCashManagerAdminUser");
}
utility.SetRowChanged(totalRows);
hasPagerRow.Value = "false";
//Set Tool Tips
buttonSave.Attributes.Add("onmouseover", "Tip('" + VariablesCashManager.TOOLTIP_SAVE_BUTTON + "')");
buttonSave.Attributes.Add("onmouseout", "UnTip()");
exitButton.Attributes.Add("onmouseout", "UnTip()");
if (utility.GetIsAdminUser() || utility.GetIsCMUser())
{
AmountSelectedHidden.Value = Convert.ToString(GetTotalChecked());
if (Session["amountToPay"] != null)
{
AmountToPay.Value = Session["amountToPay"].ToString();
}
else
{
AmountToPay.Value = "0";
}
}
else
{
divTotalToPay.Visible = false;
buttonAdminOptions.Visible = false;
}
LabelCurrentPage.Text = "Page " + Convert.ToString(dataGridView.PageIndex + 1) + " of " + dataGridView.PageCount;
if (!Page.IsPostBack)
{
LogUserAccess();
}
}
protected void Page_Load(object sender, EventArgs e)
{
Page.MaintainScrollPositionOnPostBack = true;
String userName = Page.User.Identity.Name.ToString().Substring(8);
//userName = "******";
utility = new UtilityCashFlow(userName);
SetUpUser();
int totalRows = 0;
if (Request["loc"] != null)
{
utility.SetLocation(Request["loc"].ToString());
}
if (Request["dept"] != null)
{
utility.SetDepartment(Request["dept"].ToString());
}
try
{
totalRows = dataGridView.Rows.Count;
}
catch (SqlException sqle)
{
Logger.QuickLog(errorLogFileName, sqle.Message, "Page_Load()", "int totalRows = dataGridView.Rows.Count");
}
if (utility.GetIsDeptUser())
{
data.Attributes.Add("class", "cashManagerData cashManagerDataDept");
options.Attributes.Add("class", "optionsCashManagerDeptUser");
}
else if (utility.GetIsCMUser())
{
data.Attributes.Add("class", "cashManagerData cashManagerDataCM");
options.Attributes.Add("class", "optionsCashManagerCMUser");
}
else
{
data.Attributes.Add("class", "cashManagerData cashManagerDataAdmin");
options.Attributes.Add("class", "optionsCashManagerAdminUser");
}
utility.SetRowChanged(totalRows);
hasPagerRow.Value = "false";
//Set Tool Tips
buttonSave.Attributes.Add("onmouseover", "Tip('" + VariablesCashManager.TOOLTIP_SAVE_BUTTON + "')");
buttonSave.Attributes.Add("onmouseout", "UnTip()");
exitButton.Attributes.Add("onmouseout", "UnTip()");
if (utility.GetIsAdminUser() || utility.GetIsCMUser())
{
AmountSelectedHidden.Value = Convert.ToString(GetTotalChecked());
if (Session["amountToPay"] != null)
{
AmountToPay.Value = Session["amountToPay"].ToString();
}
else
{
AmountToPay.Value = "0";
}
}
else
{
divTotalToPay.Visible = false;
buttonAdminOptions.Visible = false;
}
LabelCurrentPage.Text = "Page " + Convert.ToString(dataGridView.PageIndex + 1) + " of " + dataGridView.PageCount;
if (!Page.IsPostBack)
{
LogUserAccess();
}
}
/// <summary>
/// Called before the page is rendered. This is used for the save functionality.
/// See Code for SQL - this is a large dynamic sql that is built using C#.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_PreRender(object sender, EventArgs e)
{
String messageOutput = "";
bool updateMessage = false;
if (Page.IsPostBack)
{
String sessionResetCookie = "false";
if (Session["resetCookie"] != null)
{
sessionResetCookie = Session["resetCookie"].ToString();
}
if (sessionResetCookie.Equals("true"))
{
Session["resetCookie"] = "false";
}
int totalRows = dataGridView.Rows.Count;
for (int r = 0; r < totalRows; r++)
{
if (utility.GetRowChanged()[r])
{
updateMessage = true;
GridViewRow thisGridViewRow = dataGridView.Rows[r];
String barcode = "";
String source = "";
String invoiceNumber = "";
String invoiceDate = "";
String vendorNumber = "";
int payFlag = 0;
decimal amount = 0;
//String cmPriority = "4";
//String deptPriority = "4";
String cmPriority = "2";
String deptPriority = "2";
String cmNotes = "";
String deptNotes = "";
String payMethod = "";
String updateTimeAtLoad = "";
try
{
barcode = thisGridViewRow.Cells[columnBarcode].Text == "-" ? "-1" : thisGridViewRow.Cells[columnBarcode].Text;
source = thisGridViewRow.Cells[columnSource].Text;
invoiceNumber = thisGridViewRow.Cells[columnInvoiceNumberHidden].Text.Replace("'", "''").Replace(" ", "");
invoiceDate = thisGridViewRow.Cells[columnInvoiceDateHidden].Text;
vendorNumber = thisGridViewRow.Cells[columnVendorIdHidden].Text;
payFlag = ((CheckBox)thisGridViewRow.FindControl("review1CB")).Checked == true ? 1 : 0;
updateTimeAtLoad = thisGridViewRow.Cells[columnUpdateTimeHidden].Text;
try
{
amount = Convert.ToDecimal(thisGridViewRow.Cells[columnAmountHidden].Text);
}
catch (FormatException fe)
{
Logger.QuickLog(VariablesCashManager.ERROR_LOG_FILE_NAME, "Page_PreRender()", fe.Message, "converting amount from text to decimal: " + thisGridViewRow.Cells[columnAmountHidden].Text);
}
if (utility.GetIsDeptUser())
{
cmPriority = thisGridViewRow.Cells[columnPriorityCMHidden].Text;
payMethod = thisGridViewRow.Cells[columnPaymentMethodHidden].Text.Replace(" ", "");
}
else
{
cmPriority = ((RadioButtonList)thisGridViewRow.FindControl("cmPriorityRadioButtonList")).SelectedValue;
payMethod = ((DropDownList)thisGridViewRow.FindControl("DropDownListPayMthd")).SelectedValue;
}
if (utility.GetIsCMUser())
{
deptPriority = thisGridViewRow.Cells[columnPriorityDeptHidden].Text == "-1" ? "null" : thisGridViewRow.Cells[columnPriorityDeptHidden].Text;
}
else
{
deptPriority = ((RadioButtonList)thisGridViewRow.FindControl("deptPriorityRadioButtonList")).SelectedValue;
}
cmNotes = ((TextBox)thisGridViewRow.FindControl("cmNotesTB")).Text.Replace("'", "''");
deptNotes = ((TextBox)thisGridViewRow.FindControl("deptNotesTB")).Text.Replace("'", "''");
}
catch (FormatException)
{
//this is to catch when set to a nonNumber
//non numbers are converted to zero
}
catch (ArgumentOutOfRangeException ae)
{
//when using paging
Logger.QuickLog(errorLogFileName, ae.Message, "Page_PreRender()", "");
}
SqlConnection con = null;
String sqlDateCheck = " SELECT case when updateTime > '" + updateTimeAtLoad + "' then 0 else 1 end as okToSave "
+ " FROM BMcBEARCashFlowManager "
+ " WHERE barcode = " + barcode
+ " AND dataSource = '" + source + "' "
+ " AND invoiceNumber = '" + invoiceNumber + "' "
+ " AND invoiceDate = '" + invoiceDate + "' "
+ " AND vendorNumber = '" + vendorNumber + "' "
+ " AND amount = " + amount;
String sqlArchive = " INSERT INTO dbo.BMcBEARCashFlowManagerArchive "
+ " SELECT ID "
+ " ,barcode "
+ " ,dataSource "
+ " ,invoiceNumber "
+ " ,invoiceDate "
+ " ,vendorNumber "
+ " ,payFlag "
+ " ,amount "
+ " ,priorityCM "
+ " ,priorityDept"
+ " ,notesCM "
+ " ,notesDept "
+ " ,paymentMethod "
+ " ,updatedBy "
+ " ,updateTime "
+ " FROM dbo.BMcBEARCashFlowManager (nolock)"
+ " WHERE barcode = " + barcode
+ " AND dataSource = '" + source + "' "
+ " AND invoiceNumber = '" + invoiceNumber + "' "
+ " AND invoiceDate = '" + invoiceDate + "' "
+ " AND vendorNumber = '" + vendorNumber + "' "
+ " AND amount = " + amount;
String sqlSelectCount = " SELECT count(*) as count "
+ " FROM dbo.BMcBEARCashFlowManager (nolock) "
+ " WHERE barcode = " + barcode
+ " AND dataSource = '" + source + "' "
+ " AND invoiceNumber = '" + invoiceNumber + "' "
+ " AND invoiceDate = '" + invoiceDate + "' "
+ " AND vendorNumber = '" + vendorNumber + "' "
+ " AND amount = " + amount;
String sqlUpdate = " UPDATE BMcBEARCashFlowManager "
+ " SET updatedBy = '" + utility.GetUserName() + "' "
+ " , updateTime = '" + DateTime.Now + "' ";
if (!utility.GetIsDeptUser())
{
sqlUpdate = sqlUpdate
+ " , payFlag = " + payFlag
+ " , paymentMethod = '" + payMethod + "' "
+ " , notesCM = '" + cmNotes + "' "
+ " , priorityCM = " + cmPriority;
}
if (!utility.GetIsCMUser())
{
sqlUpdate = sqlUpdate
+ " , priorityDept = " + deptPriority
+ " , notesDept = '" + deptNotes + "' ";
}
sqlUpdate = sqlUpdate
+ " WHERE barcode = " + barcode
+ " AND dataSource = '" + source + "' "
+ " AND invoiceNumber = '" + invoiceNumber + "' "
+ " AND invoiceDate = '" + invoiceDate + "' "
+ " AND vendorNumber = '" + vendorNumber + "' "
+ " AND amount = " + amount;
String sqlInsert = " INSERT INTO dbo.BMcBEARCashFlowManager ( "
+ " barcode, dataSource, invoiceNumber, invoiceDate, vendorNumber, "
+ " payFlag, amount, priorityCM, priorityDept, notesCM, notesDept, "
+ " paymentMethod, updatedBy, updateTime "
+ " ) VALUES ( "
+ barcode
+ ", '" + source + "' "
+ ", '" + invoiceNumber + "' "
+ ", '" + invoiceDate + "' "
+ ", '" + vendorNumber + "' "
+ ", " + payFlag
+ ", " + amount;
if (cmPriority.Equals("-1"))
{
sqlInsert = sqlInsert
+ ", NULL ";
}
else
{
sqlInsert = sqlInsert
+ ", " + cmPriority;
}
sqlInsert = sqlInsert
+ ", " + deptPriority
+ ", '" + cmNotes + "' "
+ ", '" + deptNotes + "' "
+ ", '" + payMethod + "' "
+ ", '" + utility.GetUserName() + "' "
+ ", '" + DateTime.Now + "' "
+ " ) ";
try
{
con = new SqlConnection(
ConfigurationManager.ConnectionStrings["eliteConnectionString"].ConnectionString);
con.Open();
SqlCommand command = con.CreateCommand();
command.CommandType = CommandType.Text;
command.CommandText = sqlArchive;
command.ExecuteNonQuery();
int recordCount = 0;
try
{
command.CommandText = sqlSelectCount;
SqlDataReader readerCount = command.ExecuteReader();
if (readerCount.Read())
{
recordCount = Convert.ToInt16(readerCount["count"].ToString());
}
readerCount.Close();
}
catch (SqlException sqleSelectCount)
{
Logger.QuickLog(errorLogFileName, sqleSelectCount.Message, "Page_PreRender()", sqlSelectCount);
}
catch (Exception)
{
}
if (recordCount > 0)
{
int okToSave = 0;
try
{
command.CommandText = sqlDateCheck;
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
okToSave = Convert.ToInt16(reader["okToSave"].ToString());
}
reader.Close();
}
catch (SqlException sqleDateCheck)
{
Logger.QuickLog(errorLogFileName, sqleDateCheck.Message, "PagePreRender()", sqlDateCheck);
}
if (okToSave == 1)
{
try
{
command.CommandText = sqlUpdate;
command.ExecuteNonQuery();
}
catch (SqlException sqleUpdate)
{
Logger.QuickLog(errorLogFileName, sqleUpdate.Message, "Page_PreRender()", sqlUpdate);
}
}
else
{
if (messageOutput.Equals(""))
{
messageOutput = "Barcode(s): " + barcode;
}
else
{
messageOutput = messageOutput + ", " + barcode;
}
}
}
else
{
try
{
command.CommandText = sqlInsert;
command.ExecuteNonQuery();
}
catch (SqlException sqleInsert)
{
Logger.QuickLog(errorLogFileName, sqleInsert.Message, "Page_PreRender()", sqlInsert);
}
}
}
catch (SqlException sqleArchive)
{
Logger.QuickLog(errorLogFileName, sqleArchive.Message, "Page_PreRender()", sqlArchive);
}
finally
{
if (con != null)
{
con.Close();
}
}
utility.GetRowChanged()[r] = false;
} //end "if (rowChanged[r])"
} //end "for (int r = 0; r < totalRows; r++)"
if (!messageOutput.Equals(""))
{
messageOutput = messageOutput + " Not Saved due to being updated by someone else";
}
if (updateMessage)
{
if (messageOutput.Equals(""))
{
messageOutput = "All Records Saved";
LabelMessage.CssClass = "Green";
}
else
{
LabelMessage.CssClass = "Red";
}
LabelMessage.Text = messageOutput;
}
else if (LabelMessage.Text.Equals("All Records Saved"))
{
LabelMessage.Text = "";
}
dataGridView.DataBind();
if (utility.GetIsAdminUser() || utility.GetIsCMUser())
{
AmountSelectedHidden.Value = Convert.ToString(GetTotalChecked());
}
} //end if (Page.IsPostBack)
else
{
dataGridView.SelectedIndex = -1;
}
} //end Page_PreRender()