///<summary></summary>
public static long Insert(Dunning dun) {
if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
dun.DunningNum=Meth.GetLong(MethodBase.GetCurrentMethod(),dun);
return dun.DunningNum;
}
return Crud.DunningCrud.Insert(dun);
}
///<summary></summary>
public static void Update(Dunning dun){
if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
Meth.GetVoid(MethodBase.GetCurrentMethod(),dun);
return;
}
Crud.DunningCrud.Update(dun);
}
///<summary></summary>
public FormDunningEdit(Dunning dunningCur)
{
//
// Required for Windows Form Designer support
//
DunningCur=dunningCur.Copy();
InitializeComponent();
Lan.F(this);
}
///<summary></summary>
public static void Delete(Dunning dun){
if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
Meth.GetVoid(MethodBase.GetCurrentMethod(),dun);
return;
}
string command="DELETE FROM dunning"
+" WHERE DunningNum = "+POut.Long(dun.DunningNum);
Db.NonQ(command);
}
///<summary></summary>
public static void Update(Dunning dun)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
Meth.GetVoid(MethodBase.GetCurrentMethod(), dun);
return;
}
Crud.DunningCrud.Update(dun);
}
///<summary></summary>
public static long Insert(Dunning dun)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
dun.DunningNum = Meth.GetLong(MethodBase.GetCurrentMethod(), dun);
return(dun.DunningNum);
}
return(Crud.DunningCrud.Insert(dun));
}
///<summary>Returns a copy of this Dunning.</summary>
public Dunning Copy()
{
Dunning d = new Dunning();
d.DunningNum = DunningNum;
d.DunMessage = DunMessage;
d.BillingType = BillingType;
d.AgeAccount = AgeAccount;
d.InsIsPending = InsIsPending;
return(d);
}
///<summary></summary>
public static void Delete(Dunning dun)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
Meth.GetVoid(MethodBase.GetCurrentMethod(), dun);
return;
}
string command = "DELETE FROM dunning"
+ " WHERE DunningNum = " + POut.Long(dun.DunningNum);
Db.NonQ(command);
}
///<summary>Will return null if no dunning matches the given criteria.</summary>
public static Dunning GetDunning(Dunning[] dunList,long billingType,int ageAccount,YN insIsPending) {
//No need to check RemotingRole; no call to db.
//loop backwards through Dunning list and find the first dunning that matches criteria.
for(int i=dunList.Length-1;i>=0;i--){
if(dunList[i].BillingType!=0//0 in the list matches all
&& dunList[i].BillingType!=billingType){
continue;
}
if(ageAccount < dunList[i].AgeAccount){//match if age is >= item in list
continue;
}
if(dunList[i].InsIsPending!=YN.Unknown//unknown in the list matches all
&& dunList[i].InsIsPending!=insIsPending){
continue;
}
return dunList[i];
}
return null;
}
///<summary>Gets a list of all dunnings.</summary>
public static Dunning[] Refresh()
{
if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
return Meth.GetObject<Dunning[]>(MethodBase.GetCurrentMethod());
}
string command="SELECT * FROM dunning "
+"ORDER BY BillingType,AgeAccount,InsIsPending";
DataTable table=Db.GetTable(command);
Dunning[] List=new Dunning[table.Rows.Count];
for(int i=0;i<table.Rows.Count;i++) {
List[i]=new Dunning();
List[i].DunningNum = PIn.Long(table.Rows[i][0].ToString());
List[i].DunMessage = PIn.String(table.Rows[i][1].ToString());
List[i].BillingType = PIn.Long(table.Rows[i][2].ToString());
List[i].AgeAccount = PIn.Byte(table.Rows[i][3].ToString());
List[i].InsIsPending = (YN)PIn.Long(table.Rows[i][4].ToString());
List[i].MessageBold = PIn.String(table.Rows[i][5].ToString());
}
return List;
}
///<summary>Gets a list of all dunnings.</summary>
public static Dunning[] Refresh()
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
return(Meth.GetObject <Dunning[]>(MethodBase.GetCurrentMethod()));
}
string command = "SELECT * FROM dunning "
+ "ORDER BY BillingType,AgeAccount,InsIsPending";
DataTable table = Db.GetTable(command);
Dunning[] List = new Dunning[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
List[i] = new Dunning();
List[i].DunningNum = PIn.Long(table.Rows[i][0].ToString());
List[i].DunMessage = PIn.String(table.Rows[i][1].ToString());
List[i].BillingType = PIn.Long(table.Rows[i][2].ToString());
List[i].AgeAccount = PIn.Byte(table.Rows[i][3].ToString());
List[i].InsIsPending = (YN)PIn.Long(table.Rows[i][4].ToString());
List[i].MessageBold = PIn.String(table.Rows[i][5].ToString());
}
return(List);
}
private void butAdd_Click(object sender, System.EventArgs e) {
Dunning dun=new Dunning();
FormDunningEdit FormD=new FormDunningEdit(dun);
FormD.IsNew=true;
FormD.ShowDialog();
if(FormD.DialogResult==DialogResult.Cancel){
return;
}
FillDunning();
}
