///<summary>Updates all claimforms with this unique id including all attached items.</summary>
public static void UpdateByUniqueID(ClaimForm cf)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
Meth.GetVoid(MethodBase.GetCurrentMethod(), cf);
return;
}
//first get a list of the ClaimFormNums with this UniqueId
string command =
"SELECT ClaimFormNum FROM claimform WHERE UniqueID ='" + cf.UniqueID.ToString() + "'";
DataTable table = Db.GetTable(command);
long[] claimFormNums = new long[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
claimFormNums[i] = PIn.Long(table.Rows[i][0].ToString());
}
//loop through each matching claimform
for (int i = 0; i < claimFormNums.Length; i++)
{
cf.ClaimFormNum = claimFormNums[i];
Update(cf);
command = "DELETE FROM claimformitem "
+ "WHERE ClaimFormNum = '" + POut.Long(claimFormNums[i]) + "'";
Db.NonQ(command);
for (int j = 0; j < cf.Items.Length; j++)
{
cf.Items[j].ClaimFormNum = claimFormNums[i];
ClaimFormItems.Insert(cf.Items[j]);
}
}
}
///<summary></summary>
public static void Update(ClaimForm cf)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
Meth.GetVoid(MethodBase.GetCurrentMethod(), cf);
return;
}
//Synch the claim form items associated to this claim form first.
ClaimFormItems.DeleteAllForClaimForm(cf.ClaimFormNum);
foreach (ClaimFormItem item in cf.Items)
{
ClaimFormItems.Insert(item);
}
//Now we can update any information specific to the claim form itself.
Crud.ClaimFormCrud.Update(cf);
}
///<summary>Inserts this claimform into database and retrieves the new primary key.
///Assigns all claimformitems to the claimform and inserts them if the bool is true.</summary>
public static long Insert(ClaimForm cf, bool includeClaimFormItems)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
return(Meth.GetLong(MethodBase.GetCurrentMethod(), cf, includeClaimFormItems));
}
long retVal = Crud.ClaimFormCrud.Insert(cf);
if (includeClaimFormItems)
{
foreach (ClaimFormItem claimFormItemCur in cf.Items)
{
claimFormItemCur.ClaimFormNum = cf.ClaimFormNum; //so even though the ClaimFormNum is wrong, this line fixes it.
ClaimFormItems.Insert(claimFormItemCur);
}
}
return(retVal);
}
