public JObject UserBalance(string sConnString, int userId)
{
JObject jObj = new JObject();
string retMsg = "";
int retVal = 0;
double balance;
DataSet ds = new DataSet();
try
{
DataAccessLayer.V_1_2.Profile_V120 profileObj = new DataAccessLayer.V_1_2.Profile_V120(sConnString);
ds = profileObj.UserBalance(userId, out retMsg, out retVal, out balance);
if (retVal == 1)
{
jObj = new JObject(new JProperty("Success", true),
new JProperty("Message", retMsg),
new JProperty("UserBalance", balance));
}
else
{
jObj = new JObject(new JProperty("Success", false),
new JProperty("Message", retMsg));
}
}
catch (Exception ex)
{
Logger.ExceptionLog("Exception in ProfileBusiness.UserBalance is ==>" + ex.ToString());
jObj = new JObject(new JProperty("Success", false),
new JProperty("Message", "Something Went Wrong"));
//new JProperty("Message", ex.ToString()));
}
return(jObj);
}
public JObject GetCountries(string sConnString)
{
JObject countriesJObj = new JObject();
JObject TempJobj = new JObject();
JArray CountriesJarr = new JArray();
DataSet Ds = new DataSet();
DataAccessLayer.V_1_2.Profile_V120 profileObj = new DataAccessLayer.V_1_2.Profile_V120(sConnString);
String retMsg = "";
Ds = profileObj.GetCountries(out retMsg);
if (Ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow _row in Ds.Tables[0].Rows)
{
TempJobj = new JObject();
foreach (DataColumn _column in Ds.Tables[0].Columns)
{
TempJobj.Add(new JProperty(_column.ColumnName, _row[_column.ColumnName]));
}
CountriesJarr.Add(TempJobj);
}
countriesJObj = new JObject(new JProperty("Success", true),
new JProperty("Message", retMsg),
new JProperty("Countries", CountriesJarr));
}
return(countriesJObj);
}
public JObject UpdateProfile(string sConnString, int userID, string nickName, string emailID, string workNumber, string webSiteURL, string company)
{
JObject resultJobj = new JObject();
JObject tempObj = new JObject();
int retVal = 0;
string retMsg = "";
DataSet ds = new DataSet();
try
{
DataAccessLayer.V_1_2.Profile_V120 profileObj = new DataAccessLayer.V_1_2.Profile_V120(sConnString);
ds = profileObj.UpdateProfile(userID, nickName, emailID, workNumber, webSiteURL, company, out retVal, out retMsg);
if (retVal == 1)
{
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
resultJobj = new JObject(new JProperty("Success", true),
new JProperty("Message", "Success"),
new JProperty("userid", ds.Tables[0].Rows[0]["UserID"]),
new JProperty("Nickname", ds.Tables[0].Rows[0]["Nickname"]),
new JProperty("EmailID", ds.Tables[0].Rows[0]["EmailID"]),
new JProperty("WebsiteURL", ds.Tables[0].Rows[0]["WebsiteURL"]),
new JProperty("WorkNumber", ds.Tables[0].Rows[0]["WorkNumber"]),
new JProperty("Company", ds.Tables[0].Rows[0]["Company"]),
new JProperty("imagepath", ds.Tables[0].Rows[0]["DisplayPicPath"]),
new JProperty("Currency", ds.Tables[0].Rows[0]["CurrencyName"]),
new JProperty("RequestedAmount", ds.Tables[0].Rows[0]["PaidAmount"]),
new JProperty("RequestedMinutes", ds.Tables[0].Rows[0]["AddedAmount"]),
new JProperty("InAppPurchase", true),
new JProperty("SupportEmailID", "*****@*****.**"));
}
}
else
{
resultJobj = new JObject(new JProperty("Success", false),
new JProperty("Message", "User Not Available"));
}
}
catch (Exception ex)
{
Logger.ExceptionLog("Error :" + ex.ToString());
resultJobj = new JObject(new JProperty("Success", false),
new JProperty("Message", "Something Went Wrong"),
//new JProperty("Message", ex.ToString()),
new JProperty("ErrorCode", "E0002"));
}
return(resultJobj);
}
public JObject ProfileImage(string profileImg, string tempStoragePath, string tempFileName, string sConnString, int userId)
{
JObject jObj = new JObject();
Image _image = null;
MemoryStream mStream = new MemoryStream();
byte[] byteArr, data;
DataAccessLayer.V_1_2.Profile_V120 profileObj = new DataAccessLayer.V_1_2.Profile_V120(sConnString);
int result;
try
{
byteArr = Convert.FromBase64String(profileImg.Replace(" ", "+"));
mStream = new MemoryStream(byteArr);
_image = Image.FromStream(mStream);
_image.Save(tempStoragePath + tempFileName);
data = ReadFile(tempStoragePath + tempFileName);
result = profileObj.ProfileImage(userId, tempFileName, data);
if (result > 0)
{
jObj = new JObject(new JProperty("Status", true),
new JProperty("Message", "Success"),
new JProperty("imagepath", "https://new.grptalk.com/TempImages/" + tempFileName.ToString() + ""));
}
else
{
jObj = new JObject(new JProperty("Status", false),
new JProperty("Message", "Failed"));
}
}
catch (Exception ex)
{
jObj = new JObject(new JProperty("Status", false),
new JProperty("Message", "Something Went Wrong"));
//new JProperty("Message", ex.ToString()));
Logger.ExceptionLog("Exception in ProfileBusiness.ProfileImage is ==>" + ex.ToString());
}
return(jObj);
}