public PaymentDetails()
{
this.TableName = "BestPaymentDetails";
this.SecurityPage = "Payment - Details";
TableFields.Add(new BestField() { fieldName = "paymentTypeGuid", fieldHeader = "Program Type", displayField = true, fieldSize = 128, IsRequired = true, fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid,
displayFormatFunc = new Func<BestRow, object>((obj) =>
{
BestRow pd = (BestRow)obj;
List<BestField> bparams = new List<BestField>();
BestField guid = new BestField() { fieldName = "paymentTypeGuid", fieldSize = 40, fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid, displayField = false };
guid.fieldValue = pd.Fields["paymentTypeGuid"].fieldValue;
bparams.Add(guid);
PaymentTypes bptype = new PaymentTypes();
bptype.LoadRows("guidfield=?", bparams);
return bptype.paymentType;
})
});
TableFields.Add(new BestField() { fieldName = "studentGuid", fieldHeader = "Student", displayField = true, fieldSize = 128, IsRequired = true, fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid,
displayFormatFunc = new Func<BestRow,object>((obj)=>
{
BestRow pd = (BestRow)obj;
List<BestField> bparams = new List<BestField>();
BestField guid = new BestField() { fieldName = "studentGuid", fieldSize = 40, fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid, displayField = false };
guid.fieldValue = pd.Fields["studentGuid"].fieldValue;
bparams.Add(guid);
BestStudents bpstd = new BestStudents();
bpstd.LoadRows("guidfield=?", bparams);
return bpstd.firstName + " " + bpstd.lastName;
})
});
TableFields.Add(new BestField() { fieldName = "amount", fieldHeader = "Amount", displayField = true, fieldSize = 18, IsRequired = false, fieldType = "System.Decimal", paramOledbType = System.Data.OleDb.OleDbType.Decimal });
TableFields.Add(new BestField() { fieldName = "paymentDate", fieldHeader = "Payment Date", displayField = true, fieldSize = 10, IsRequired = false, fieldType = "System.DateTime", paramOledbType = System.Data.OleDb.OleDbType.DBTimeStamp,
displayFormatFunc = new Func<BestRow,object>((obj)=>
{
BestRow br = (BestRow) obj;
DateTime dt = Convert.ToDateTime(br.Fields["paymentDate"].fieldValue);
return dt.ToString("MM/dd/yyyy");
})
});
TableFields.Add(new BestField() { fieldName = "guidfield", fieldHeader = "guid", displayField = false, fieldSize = 40, IsRequired = false, fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid });
TableFields.Add(new BestField() { fieldName = "lastChange", fieldHeader = "Last Change", displayField = false, fieldSize = 20, IsRequired = false, fieldType = "System.DateTime", paramOledbType = System.Data.OleDb.OleDbType.DBTimeStamp });
TableFields.Add(new BestField() { fieldName = "lastChangeUser", fieldHeader = "Last Change User", displayField = false, fieldSize = 128, IsRequired = false, fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar });
TableFields.Add(new BestField() { fieldName = "hours", fieldHeader = "Hours", displayField = true, fieldSize = 18, IsRequired = false, fieldType = "System.Decimal", paramOledbType = System.Data.OleDb.OleDbType.Decimal, Precision = 18, scale = 2 });
TableFields.Add(new BestField() { fieldName = "CenterId", displayField = true, fieldHeader = "Center Id", fieldType = "System.String", paramOledbType = System.Data.OleDb.OleDbType.VarChar, fieldSize = 50 });
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
if (HttpContext.Current.Session["CurrentUser"] == null)
{
Response.Redirect("Logout.aspx");
}
ltrSubMenu.Text = UtilMenu.PaymentMenu("paymentdetails");
if (!Utils.User.UserRoleByName("Payment - Details").allowView)
{
ltrGrid.Text = "You do not have rights to view.";
return;
}
string ms = Request.QueryString["ms"];
ltrMScript.Text = Utils.MenuSelectScript(ms);
string saveClicked = Request.Form["SaveClicked"] ?? "";
if (IsPostBack && saveClicked.Equals("1"))
{
PaymentDetails bs = new PaymentDetails();
string isnew = Request.Form["isnew"];
bool cansave = true;
if (string.IsNullOrEmpty(isnew))
{
List<BestField> bparams = new List<BestField>();
BestField guid = new BestField() { fieldName = "guidfield", fieldSize = 40, fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid, displayField = false };
guid.fieldValue = Request.Form["guidfield"];
bparams.Add(guid);
if (!string.IsNullOrEmpty(guid.fieldValue))
{
bs.LoadRows("guidfield=?", bparams);
}
else
{
string delguid = Request.Form["deleteguid"];
if (!string.IsNullOrEmpty(delguid))
{
bparams[0].fieldValue = delguid;
bs.LoadRows("guidfield=?", bparams);
bs.CurrentRow.IsDelete = true;
bs.CurrentRow.Save();
}
cansave = false;
}
}
if (cansave)
{
string stdguid = Request.Form["g_studentGuid"];
string payguid = Request.Form["g_paymentTypeGuid"];
string amt = Request.Form["g_amount"];
string paydate = Request.Form["g_paymentDate"];
string hours = Request.Form["g_hours"];
if (string.IsNullOrEmpty(payguid))
{
ltrValidateMsg.Text = Utils.WarningMessage("Payment Type is Required.");
cansave = false;
}
if (string.IsNullOrEmpty(stdguid))
{
ltrValidateMsg.Text = Utils.WarningMessage("Student is Required.");
cansave = false;
}
if (string.IsNullOrEmpty(paydate))
{
ltrValidateMsg.Text = Utils.WarningMessage("Payment Date is Required.");
cansave = false;
}
if (cansave)
{
bs.studentGuid = new Guid(stdguid);
bs.paymentTypeGuid = new Guid(payguid);
bs.amount = amt;
Decimal dhours;
Decimal.TryParse(hours, out dhours);
bs.hours = dhours;
bs.paymentDate = Convert.ToDateTime(paydate);
bs.CenterId = Utils.User.CenterId;
if (!bs.CurrentRow.Save())
{
ltrValidateMsg.Text = Utils.WarningMessage(bs.CurrentRow.lastError);
}
}
}
}
PaymentTypes bpayTypes = new PaymentTypes();
bpayTypes.LoadRows();
StringBuilder sbc = new StringBuilder();
sbc.Append("<option value=\"\"></option>");
for (int rnum = 0; rnum < bpayTypes.TableRows.Count; rnum++)
{
string paytype = bpayTypes.TableRows[rnum].Fields["paymentType"].fieldValue;
string guid = bpayTypes.TableRows[rnum].Fields["guidfield"].fieldValue;
sbc.Append("<option value=\"" + HttpUtility.HtmlEncode(guid) + "\">" + HttpUtility.HtmlEncode(paytype) + "</option>");
}
ltrPayTypes.Text = sbc.ToString();
/* Auto Student */
string autoSample = "{value:\"[paramValue]\", label:[paramLabel]}";
StringBuilder sb = new StringBuilder();
sb.AppendLine("autoStudents = [");
BestStudents bstd = new BestStudents();
bstd.LoadRows("CenterId=?", Utils.User.CIdParam);
for (int s = 0; s < bstd.TableRows.Count; s++)
{
string result = autoSample;
result = result.Replace("[paramValue]", bstd.TableRows[s].Fields["guidfield"].fieldValue);
result = result.Replace("[paramLabel]", Utils.EnquoteJS((bstd.TableRows[s].Fields["firstName"].fieldValue ?? "") + " " +
(bstd.TableRows[s].Fields["lastName"].fieldValue ?? "")));
sb.Append(result);
if (s < bstd.TableRows.Count - 1) sb.AppendLine(",");
}
sb.AppendLine("];");
ltrScript.Text = @"<script type=""text/javascript"">
$(document).ready(function(){ " + sb.ToString() + @"
$('#studentTag1').autocomplete( { source:autoStudents, delay: 0, select : function( event, ui){
$('#studentGuid').val( ui.item.value );
$( this ).val( ui.item.label );
return false;
} } ); }); </script>";
BestGrid bsGrid = new BestGrid();
bsGrid.PageRequest = Page.Request;
bsGrid.Title = "Payment Details";
bsGrid.GridTable = new PaymentDetails();
bsGrid.securityPage = "Payment - Details";
ltrGrid.Text = bsGrid.ToHTML();
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
if (HttpContext.Current.Session["CurrentUser"] == null)
{
Response.Redirect("Logout.aspx");
}
ltrSubMenu.Text = UtilMenu.PaymentMenu("paymenttypes");
if (!Utils.User.UserRoleByName("Payment - Types").allowView)
{
ltrGrid.Text = "You do not have rights to view.";
return;
}
string ms = Request.QueryString["ms"];
ltrMScript.Text = Utils.MenuSelectScript(ms);
string saveClicked = Request.Form["SaveClicked"] ?? "";
if (IsPostBack && saveClicked.Equals("1"))
{
PaymentTypes bs = new PaymentTypes();
string isnew = Request.Form["isnew"];
bool cansave = true;
if (string.IsNullOrEmpty(isnew))
{
List<BestField> bparams = new List<BestField>();
BestField guid = new BestField() { fieldName = "guidfield", fieldSize = 40, fieldType = "System.Guid", paramOledbType = System.Data.OleDb.OleDbType.Guid, displayField = false };
guid.fieldValue = Request.Form["guidfield"];
bparams.Add(guid);
if (!string.IsNullOrEmpty(guid.fieldValue))
{
bs.LoadRows("guidfield=?", bparams);
}
else
{
string delguid = Request.Form["deleteguid"];
if (!string.IsNullOrEmpty(delguid))
{
bparams[0].fieldValue = delguid;
bs.LoadRows("guidfield=?", bparams);
bs.CurrentRow.IsDelete = true;
bs.CurrentRow.Save();
}
cansave = false;
}
}
if (cansave)
{
bs.paymentType = Request.Form["g_paymentType"];
if (string.IsNullOrEmpty(bs.paymentType))
{
ltrValidateMsg.Text = Utils.WarningMessage("Payment Type is Required.");
cansave = false;
}
if (cansave)
{
if (!bs.CurrentRow.Save())
{
ltrValidateMsg.Text = Utils.WarningMessage(bs.CurrentRow.lastError);
}
}
}
}
BestGrid bsGrid = new BestGrid();
bsGrid.PageRequest = Page.Request;
bsGrid.Title = "Payment Types";
bsGrid.securityPage = "Payment - Types";
bsGrid.GridTable = new PaymentTypes();
ltrGrid.Text = bsGrid.ToHTML();
}