///<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();
}
