///<summary></summary> public static long Insert(Deposit dep) { if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) { dep.DepositNum=Meth.GetLong(MethodBase.GetCurrentMethod(),dep); return dep.DepositNum; } return Crud.DepositCrud.Insert(dep); }
///<summary>Also handles detaching all payments and claimpayments. Throws exception if deposit is attached as a source document to a transaction. The program should have detached the deposit from the transaction ahead of time, so I would never expect the program to throw this exception unless there was a bug.</summary> public static void Delete(Deposit dep){ if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) { Meth.GetVoid(MethodBase.GetCurrentMethod(),dep); return; } //check dependencies string command=""; if(dep.DepositNum !=0){ command="SELECT COUNT(*) FROM transaction WHERE DepositNum ="+POut.Long(dep.DepositNum); if(PIn.Long(Db.GetCount(command))>0) { throw new ApplicationException(Lans.g("Deposits","Cannot delete deposit because it is attached to a transaction.")); } } /*/check claimpayment command="SELECT COUNT(*) FROM claimpayment WHERE DepositNum ="+POut.PInt(DepositNum); if(PIn.PInt(Db.GetCount(command))>0){ throw new InvalidProgramException(Lans.g("Deposits","Cannot delete deposit because it has payments attached")); }*/ //ready to delete command="UPDATE payment SET DepositNum=0 WHERE DepositNum="+POut.Long(dep.DepositNum); Db.NonQ(command); command="UPDATE claimpayment SET DepositNum=0 WHERE DepositNum="+POut.Long(dep.DepositNum); Db.NonQ(command); Crud.DepositCrud.Delete(dep.DepositNum); }
///<summary></summary> public static void Update(Deposit dep){ if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) { Meth.GetVoid(MethodBase.GetCurrentMethod(),dep); return; } Crud.DepositCrud.Update(dep); }
///<summary></summary> public FormDepositEdit(Deposit depositCur) { // // Required for Windows Form Designer support // InitializeComponent(); Lan.F(this); DepositCur=depositCur; }
private static void FillFieldsForDepositSlip(Sheet sheet,Deposit deposit) { List <Payment> PatPayList=Payments.GetForDeposit(deposit.DepositNum); ClaimPayment[] ClaimPayList=ClaimPayments.GetForDeposit(deposit.DepositNum); List<string[]> depositList=new List<string[]> (); int[] colSize=new int[] {11,33,15,14,0}; for(int i=0;i<PatPayList.Count;i++){ string amount=PatPayList[i].PayAmt.ToString("F"); colSize[4]=Math.Max(colSize[4],amount.Length); } for(int i=0;i<ClaimPayList.Length;i++){ string amount=ClaimPayList[i].CheckAmt.ToString("F"); colSize[4]=Math.Max(colSize[4],amount.Length); } for(int i=0;i<PatPayList.Count;i++){ string[] depositItem=new string[5]; string date=PatPayList[i].PayDate.ToShortDateString(); if(date.Length>colSize[0]){ date=date.Substring(0,colSize[0]); } depositItem[0]=date.PadRight(colSize[0],' ')+" "; Patient pat=Patients.GetPat(PatPayList[i].PatNum); string name=pat.GetNameLF(); if(name.Length>colSize[1]){ name=name.Substring(0,colSize[1]); } depositItem[1]=name.PadRight(colSize[1],' ')+" "; string checkNum=PatPayList[i].CheckNum; if(checkNum.Length>colSize[2]){ checkNum=checkNum.Substring(0,colSize[2]); } depositItem[2]=checkNum.PadRight(colSize[2],' ')+" "; string bankBranch=PatPayList[i].BankBranch; if(bankBranch.Length>colSize[3]){ bankBranch=bankBranch.Substring(0,colSize[3]); } depositItem[3]=bankBranch.PadRight(colSize[3],' ')+" "; depositItem[4]=PatPayList[i].PayAmt.ToString("F").PadLeft(colSize[4],' '); depositList.Add(depositItem); } for(int i=0;i<ClaimPayList.Length;i++){ string[] depositItem=new string[5]; string date=ClaimPayList[i].CheckDate.ToShortDateString(); if(date.Length>colSize[0]){ date=date.Substring(0,colSize[0]); } depositItem[0]=date.PadRight(colSize[0],' ')+" "; string name=ClaimPayList[i].CarrierName; if(name.Length>colSize[1]){ name=name.Substring(0,colSize[1]); } depositItem[1]=name.PadRight(colSize[1],' ')+" "; string checkNum=ClaimPayList[i].CheckNum; if(checkNum.Length>colSize[2]){ checkNum=checkNum.Substring(0,colSize[2]); } depositItem[2]=checkNum.PadRight(colSize[2],' ')+" "; string bankBranch=ClaimPayList[i].BankBranch; if(bankBranch.Length>colSize[3]){ bankBranch=bankBranch.Substring(0,colSize[3]); } depositItem[3]=bankBranch.PadRight(colSize[3],' ')+" "; depositItem[4]=ClaimPayList[i].CheckAmt.ToString("F").PadLeft(colSize[4],' '); depositList.Add(depositItem); } foreach(SheetField field in sheet.SheetFields) { switch(field.FieldName) { case "deposit.BankAccountInfo": field.FieldValue=deposit.BankAccountInfo; break; case "deposit.DateDeposit": field.FieldValue=deposit.DateDeposit.ToShortDateString(); break; case "depositList": StringBuilder depositListB=new StringBuilder("Date Name Check Number Bank-Branch Amount"+Environment.NewLine); for(int i=0;i<depositList.Count;i++){ if(i>0){ depositListB.Append(Environment.NewLine); } for(int j=0;j<5;j++){ depositListB.Append(depositList[i][j]); } } field.FieldValue=depositListB.ToString(); break; case "depositTotal": decimal total=0; for(int i=0;i<PatPayList.Count;i++){ total+=(decimal)PatPayList[i].PayAmt; } for(int i=0;i<ClaimPayList.Length;i++){ total+=(decimal)ClaimPayList[i].CheckAmt; } field.FieldValue=total.ToString("n").PadLeft(12,' '); break; case "depositItemCount": field.FieldValue=(PatPayList.Count+ClaimPayList.Length).ToString().PadLeft(2,'0'); break; case "depositItem01": if(depositList.Count>=1){ field.FieldValue=depositList[0][4].PadLeft(12,' '); } break; case "depositItem02": if(depositList.Count>=2){ field.FieldValue=depositList[1][4].PadLeft(12,' '); } break; case "depositItem03": if(depositList.Count>=3){ field.FieldValue=depositList[2][4].PadLeft(12,' '); } break; case "depositItem04": if(depositList.Count>=4){ field.FieldValue=depositList[3][4].PadLeft(12,' '); } break; case "depositItem05": if(depositList.Count>=5){ field.FieldValue=depositList[4][4].PadLeft(12,' '); } break; case "depositItem06": if(depositList.Count>=6){ field.FieldValue=depositList[5][4].PadLeft(12,' '); } break; case "depositItem07": if(depositList.Count>=7){ field.FieldValue=depositList[6][4].PadLeft(12,' '); } break; case "depositItem08": if(depositList.Count>=8){ field.FieldValue=depositList[7][4].PadLeft(12,' '); } break; case "depositItem09": if(depositList.Count>=9){ field.FieldValue=depositList[8][4].PadLeft(12,' '); } break; case "depositItem10": if(depositList.Count>=10){ field.FieldValue=depositList[9][4].PadLeft(12,' '); } break; case "depositItem11": if(depositList.Count>=11){ field.FieldValue=depositList[10][4].PadLeft(12,' '); } break; case "depositItem12": if(depositList.Count>=12){ field.FieldValue=depositList[11][4].PadLeft(12,' '); } break; case "depositItem13": if(depositList.Count>=13){ field.FieldValue=depositList[12][4].PadLeft(12,' '); } break; case "depositItem14": if(depositList.Count>=14){ field.FieldValue=depositList[13][4].PadLeft(12,' '); } break; case "depositItem15": if(depositList.Count>=15){ field.FieldValue=depositList[14][4].PadLeft(12,' '); } break; case "depositItem16": if(depositList.Count>=16){ field.FieldValue=depositList[15][4].PadLeft(12,' '); } break; case "depositItem17": if(depositList.Count>=17){ field.FieldValue=depositList[16][4].PadLeft(12,' '); } break; case "depositItem18": if(depositList.Count>=18){ field.FieldValue=depositList[17][4].PadLeft(12,' '); } break; } } }
///<summary>Only available in selection mode.</summary> private void butOK_Click(object sender,EventArgs e) { if(grid.GetSelectedIndex()==-1){ MsgBox.Show(this,"Please select a deposit first."); return; } SelectedDeposit=DList[grid.GetSelectedIndex()]; DialogResult=DialogResult.OK; }
///<summary>Not available in selection mode.</summary> private void butAdd_Click(object sender, System.EventArgs e) { Deposit deposit=new Deposit(); deposit.DateDeposit=DateTime.Today; deposit.BankAccountInfo=PrefC.GetString(PrefName.PracticeBankNumber); FormDepositEdit FormD=new FormDepositEdit(deposit); FormD.IsNew=true; FormD.ShowDialog(); if(FormD.DialogResult==DialogResult.Cancel){ return; } FillGrid(); }
private void grid_CellDoubleClick(object sender, OpenDental.UI.ODGridClickEventArgs e) { if(IsSelectionMode){ SelectedDeposit=DList[e.Row]; DialogResult=DialogResult.OK; return; } //not selection mode. FormDepositEdit FormD=new FormDepositEdit(DList[e.Row]); FormD.ShowDialog(); if(FormD.DialogResult==DialogResult.Cancel){ return; } FillGrid(); }