private bool StoreinDB(byte[] buffer, ManageUserSVC.ManageUserClient client, ManageUserSVC.ManageUserCoverageData Coverage)
{
bool Valid = true;
List <usp_GetEvedenceResult> DsCus = new List <usp_GetEvedenceResult>();
DsCus = client.GetEvedenceInfoByCusID(Guid.Parse(Session["CustomerIDForAdmin"].ToString()));
if (DsCus != null && DsCus.Count > 0)
{
foreach (usp_GetEvedenceResult item in DsCus)
{
if (item.IsActive.Value)
{
client.Update_Evidence(Guid.Parse(Session["CustomerIDForAdmin"].ToString()), DateTime.Now, false, item.EvidenceID, true);
}
}
}
if (DsCus != null && DsCus.Count > 0)
{
//client.Delete_Evidence(Guid.Parse(Session["CustomerIDForAdmin"].ToString()));
//Insert Newely generated Evedence after renew...
client.InsertEvedence(Guid.NewGuid(), DateTime.Now,
Guid.Parse(Session["CustomerIDForAdmin"].ToString()), DateTime.Now, true, true, buffer);
}
else
{
//Inserted New Evedence.
client.InsertEvedence(Guid.NewGuid(), DateTime.Now,
Guid.Parse(Session["CustomerIDForAdmin"].ToString()), DateTime.Now, true, true, buffer);
}
return(Valid);
}
private bool StoreinDB(byte[] buffer, ManageUserSVC.ManageUserClient client)
{
bool Valid = true;
DataSet DsCus = new DataSet();
//DsCus = client.GetEvedenceInfoByCusID(Guid.Parse(ViewState["ID"].ToString()));
if (DsCus != null && DsCus.Tables[0].Rows.Count > 0)
{
bool ActveEve = false;
Guid EVEID = new Guid();
foreach (DataRow item in DsCus.Tables[0].Rows)
{
if (item["IsActive"].ToString().Equals("True"))
{
EVEID = Guid.Parse(item["EvedenceID"].ToString());
ActveEve = true;
break;
}
}
if (ActveEve)
{
DateTime EvedenceDate = Convert.ToDateTime(DsCus.Tables[0].Rows[0]["EvideDate"].ToString());
if (EvedenceDate < DateTime.Now && DateTime.Now < EvedenceDate.AddMonths(12))
{
//Updated LastUpdated Date and IsActive only...
client.Update_Evidence(Guid.Parse(ViewState["CusID"].ToString()), DateTime.Now, true, EVEID, false);
}
else
{
//Updated IsActive field, Evedence is not valid now, need to renew account.
client.Update_Evidence(Guid.Parse(ViewState["CusID"].ToString()), DateTime.Now, false, EVEID, false);
Valid = false;
}
}
else
{
// If Account get renewd, then again insert new evedence information without affecting older records.
client.InsertEvedence(Guid.Parse(ViewState["EvedenceID"].ToString()), Convert.ToDateTime(ViewState["CoverageDate"].ToString()),
Guid.Parse(ViewState["CusID"].ToString()), DateTime.Now, true, true, buffer);
}
}
else
{
//Inserted New Evedence.
client.InsertEvedence(Guid.Parse(ViewState["EvedenceID"].ToString()), Convert.ToDateTime(ViewState["CoverageDate"].ToString()),
Guid.Parse(ViewState["CusID"].ToString()), DateTime.Now, true, true, buffer);
}
return(Valid);
}