public ZA2010LD DoSubscribe(ZA2010D FilterData, String Mode)
{
ZA2010LD UsageD = new ZA2010LD();
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("as_mode", Mode),
new XElement("as_sessionid", FilterData.ZaBase.SessionId),
new XElement("as_EmailID", FilterData.ZaBase.UserName),
new XElement("ai_Otp", FilterData.ZaBase.PKID),
new XElement("as_Pkg", FilterData.ZaBase.Fld)
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA2010_IU", XString, PLABSM.DbProvider.MSSql);
System.Data.DataTable SilDt = PLWM.Utils.GetDataTable(ds, 0);
if (SilDt.Rows.Count > 0)
{
String Otp = PLWM.Utils.CnvToStr(SilDt.Rows[0]["OTP"]);
String UserName = PLWM.Utils.CnvToStr(SilDt.Rows[0]["UserEmail"]);
String Message = GetSmsEmailFormats.GetSubscriptionEmail(Otp, UserName);
Utils.SendEmail(Message, "*****@*****.**", "Please find the otp in this email for activation of Subscription", "Zeroori", "Zeroori Active");
UsageD.Otp = Otp;
UsageD.UserAccount = Otp;
}
else
{
UsageD.UserData = new ZA3000D()
{
ZaBase = new BaseD()
{
ErrorMsg = "Invalid Operation"
},
};
}
}
catch (Exception e)
{
UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(UsageD);
}
public ZA2010LD DoLoad(ZA2010D FilterData, String Mode)
{
ZA2010LD UsageD = new ZA2010LD();
try
{
XDocument doc = new XDocument(new XElement("Root",
new XElement("as_mode", Mode),
new XElement("as_sessionid", FilterData.ZaBase.SessionId)
));
String XString = doc.ToString();
PLABSM.DAL dbObj = new PLABSM.DAL();
dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
DataSet ds = dbObj.SelectSP("ZA2010_sel", XString, PLABSM.DbProvider.MSSql);
System.Data.DataTable SilDt = PLWM.Utils.GetDataTable(ds, 0);
System.Data.DataTable GoldDt = PLWM.Utils.GetDataTable(ds, 1);
System.Data.DataTable PlatDt = PLWM.Utils.GetDataTable(ds, 2);
System.Data.DataTable UserDt = PLWM.Utils.GetDataTable(ds, 3);
foreach (DataRow dr in SilDt.Rows)
{
UsageD.SilverMast = new ZA2010D()
{
PlanMastId = PLWM.Utils.CnvToNullableInt(dr["plan_mast_id"]),
PlaName = PLWM.Utils.CnvToStr(dr["plan_name"]),
Amount = PLWM.Utils.CnvToStr(dr["amount"]),
Curncy = PLWM.Utils.CnvToStr(dr["curncy"]),
Duration = PLWM.Utils.CnvToStr(dr["duration"]),
};
}
foreach (DataRow dr in GoldDt.Rows)
{
UsageD.GoldMast = new ZA2010D()
{
PlanMastId = PLWM.Utils.CnvToNullableInt(dr["plan_mast_id"]),
PlaName = PLWM.Utils.CnvToStr(dr["plan_name"]),
Amount = PLWM.Utils.CnvToStr(dr["amount"]),
Curncy = PLWM.Utils.CnvToStr(dr["curncy"]),
Duration = PLWM.Utils.CnvToStr(dr["duration"]),
};
}
foreach (DataRow dr in PlatDt.Rows)
{
UsageD.PlatinumMast = new ZA2010D()
{
PlanMastId = PLWM.Utils.CnvToNullableInt(dr["plan_mast_id"]),
PlaName = PLWM.Utils.CnvToStr(dr["plan_name"]),
Amount = PLWM.Utils.CnvToStr(dr["amount"]),
Curncy = PLWM.Utils.CnvToStr(dr["curncy"]),
Duration = PLWM.Utils.CnvToStr(dr["duration"]),
};
}
UsageD.UserData = new ZA3000D();
foreach (DataRow Dr in UserDt.Rows)
{
UsageD.UserData = new ZA3000D()
{
UsrMastID = PLWM.Utils.CnvToInt(UserDt.Rows[0]["usr_mast_id"]),
FistNam = PLWM.Utils.CnvToStr(UserDt.Rows[0]["FirstName"]),
ZaBase = new BaseD()
{
SessionId = PLWM.Utils.CnvToStr(UserDt.Rows[0]["SESSIONID"]),
},
};
}
}
catch (Exception e)
{
UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
}
return(UsageD);
}
