private Decimal getProgramAmount(Guid? stuguid, Guid? progGuid) { Decimal result = 0; BestField p1 = new BestField() { fieldName = "studentguid", fieldType = "System.Guid", fieldSize = 40, paramOledbType = System.Data.OleDb.OleDbType.Guid }; p1.fieldValue = stuguid.ToString(); BestField p2 = new BestField() { fieldName = "guidfield", fieldType = "System.Guid", fieldSize = 40, paramOledbType = System.Data.OleDb.OleDbType.Guid }; p2.fieldValue = progGuid.ToString(); List<BestField> bparams = new List<BestField>(); bparams.Add(p1); bparams.Add(p2); BestStudentPrograms bstdProgs = new BestStudentPrograms(); bstdProgs.LoadRows("studentguid=? and guidfield=?", bparams); if (bstdProgs.HasRows) { bstdProgs.currentRowId = 0; result = bstdProgs.Amount; } return result; }
private void SavePrograms(Guid studentGuid) { string programsData = Request.Form["programsData"]; if (!string.IsNullOrEmpty(programsData)) { string[] aryProgs = programsData.Split('\n'); for (int i = 0; i < aryProgs.Length; i++) { string[] aryFields = aryProgs[i].Split('\t'); Decimal ddamt; if (aryFields[0].Length > 16) { /* Edit or Delete */ BestStudentPrograms bstdProg = new BestStudentPrograms(); 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 = aryFields[0]; bparams.Add(guid); if (!string.IsNullOrEmpty(guid.fieldValue)) { bstdProg.LoadRows("guidfield=?", bparams); } bstdProg.programguid = (Guid)Utils.getNullableGuid(aryFields[1]); Decimal.TryParse(aryFields[2], out ddamt); bstdProg.Amount = ddamt; bstdProg.CurrentRow.IsDelete = aryFields[3].Equals("true\r"); bstdProg.CurrentRow.Save(); } else if(aryFields[0].Length != 0) { /* Add */ Guid? programguid = Utils.getNullableGuid(aryFields[1]); if (programguid != null) { BestStudentPrograms bstdProg = new BestStudentPrograms(); bstdProg.studentGuid = studentGuid; bstdProg.programguid = new Guid(aryFields[1]); Decimal.TryParse(aryFields[2], out ddamt); bstdProg.Amount = ddamt; bstdProg.StudentId = this.StudentId.Value; bstdProg.CenterId = this.CenterId.Value; bstdProg.CurrentRow.Save(); } } } } }
private string StudentPrograms() { StringBuilder sbprog = new StringBuilder(); BestStudentPrograms bstdProg = new BestStudentPrograms(); bstdProg.LoadRows("CenterId=? and programguid in (select guidfield from bestprograms where amountType not in ('OneTime', 'Year'))", Utils.User.CIdParam, "studentguid"); sbprog.AppendLine("StudentProgs = ["); string firstguid = ""; int sequence = 0; for (int i = 0; i < bstdProg.TableRows.Count; i++) { bstdProg.currentRowId = i; if (!firstguid.Equals(bstdProg.studentGuid.ToString())) { sequence = 0; firstguid = bstdProg.studentGuid.ToString(); } sequence++; sbprog.Append("{guidfield:\"" + bstdProg.guidfield.ToString() + "\",studentguid:\"" + bstdProg.studentGuid.ToString() + "\", progGuid:\"" + bstdProg.programguid.ToString() + "\", Amount:" + bstdProg.Amount.ToString("0.00") + ", Index:" + sequence.ToString() + "}"); if (i < bstdProg.TableRows.Count - 1) sbprog.Append(","); } sbprog.AppendLine("]"); sbprog.AppendLine("jsProg=["); BestPrograms bps = new BestPrograms(); bps.LoadRows(); for (int rnum = 0; rnum < bps.TableRows.Count; rnum++) { bps.currentRowId = rnum; sbprog.Append("{guid:\"" + bps.guidfield.ToString() + "\",amount:\"" + bps.amount + "\",amountType:\"" + bps.amountType + "\",progName:\"" + bps.programName + "\",progType:\"" + bps.programType + "\"}"); if (rnum < bps.TableRows.Count - 1) sbprog.Append(","); } sbprog.Append("]"); return sbprog.ToString(); }