/// <summary>
/// Update personal profile from app screens.
/// </summary>
/// <param name="sessionKey">string</param>
/// <param name="firstName">string</param>
/// <param name="lastName">string</param>
/// <param name="displayName">string</param>
/// <param name="isUser">string</param>
/// <param name="isExpert">string</param>
/// <param name="catsubcat">string</param>
/// <param name="description">string</param>
/// <param name="countrycode">string</param>
/// <param name="mobileNumber">string</param>
/// <returns>SessionResponseObject</returns>
public SessionResponseObject UpdatePersonalInfoByUserId(string sessionKey, string firstName, string lastName, string displayName, string isUser, string isExpert, string catsubcat,
string description, string mobileNumber)
{
AuthenticationEngine authEngine = new AuthenticationEngine();
User user = new User();
bool isValid = authEngine.IsValidSession(sessionKey);
SessionResponseObject responseObject = new SessionResponseObject();
ResponseObjectForAnything obj = new ResponseObjectForAnything();
if (isValid)
{
if (!string.IsNullOrEmpty(sessionKey))
{
obj = authEngine.GetUserFromSession(sessionKey);
user = (User)Serializer.JSONStringToObject<User>(obj.ResultObjectJSON);
}
if(user != null)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_UpdateProfileByUserID");
db.AddInParameter(dbCommand, "UserID", DbType.Int32, user.UserID);
db.AddInParameter(dbCommand, "FirstName", DbType.String, firstName);
db.AddInParameter(dbCommand, "LastName", DbType.String, lastName);
db.AddInParameter(dbCommand, "DisplayName", DbType.String, displayName);
db.AddInParameter(dbCommand, "IsUser", DbType.Boolean, Convert.ToBoolean(isUser));
db.AddInParameter(dbCommand, "IsExpert", DbType.Boolean, Convert.ToBoolean(isExpert));
string[] lstcatsubcat = catsubcat.Split(";".ToCharArray());
DataSet dataSet = new DataSet();
DataTable dataTable = dataSet.Tables.Add();
dataTable.Columns.Add("CategoryID");
dataTable.Columns.Add("SubCategoryID");
for (int count = 0; count < lstcatsubcat.Length - 1; count++)
{
string category = lstcatsubcat[count].Split(",".ToCharArray())[0];
string subcategory = lstcatsubcat[count].Split(",".ToCharArray())[1];
dataTable.Rows.Add(new object[] { category, subcategory });
}
db.AddInParameter(dbCommand, "CatSubCat", DbType.String, dataSet.GetXml());
db.AddInParameter(dbCommand, "BriefDescription", DbType.String, description);
db.AddInParameter(dbCommand, "MobileNumber", DbType.String, mobileNumber);
dbCommand.ExecuteNonQuery();
responseObject.ResultCode = "SUCCESS";
responseObject.ResultMessage = "Profile information updated successfully.";
}
catch(Exception ex)
{
responseObject.ResultCode = "ERROR";
responseObject.ResultMessage = ex.Message;
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "UpdatePersonalInfoByUserId", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
}
return (responseObject);
}
/// <summary>
/// Update contact info for a user ID.
/// </summary>
/// <param name="sessionKey">string</param>
/// <param name="address1">string</param>
/// <param name="address2">string</param>
/// <param name="address3">string</param>
/// <param name="state">string</param>
/// <param name="city">string</param>
/// <param name="pincode">string</param>
/// <returns>SessionResponseObject</returns>
public ResponseObjectForAnything UpdateCardDetailsByUserId(string sessionKey, string cardtype, string cardnumber)
{
AuthenticationEngine authEngine = new AuthenticationEngine();
User user = new User();
bool isValid = authEngine.IsValidSession(sessionKey);
ResponseObjectForAnything obj = new ResponseObjectForAnything();
if (isValid)
{
if (!string.IsNullOrEmpty(sessionKey))
{
obj = authEngine.GetUserFromSession(sessionKey);
user = (User)Serializer.JSONStringToObject<User>(obj.ResultObjectJSON);
}
if (user != null)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_UpdateCardsByUserID");
db.AddInParameter(dbCommand, "UserID", DbType.Int32, user.UserID);
db.AddInParameter(dbCommand, "CardType", DbType.Xml, cardtype);
db.AddInParameter(dbCommand, "CardNumber", DbType.Xml, cardnumber);
dbCommand.ExecuteNonQuery();
obj.ResultCode = "SUCCESS";
obj.ResultMessage = "Card details information updated successfully.";
}
catch (Exception ex)
{
obj.ResultCode = "ERROR";
obj.ResultMessage = ex.Message;
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "UpdateContactInfoByUserId", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
}
return (obj);
}
/// <summary>
/// Update contact info for a user ID.
/// </summary>
/// <param name="sessionKey">string</param>
/// <param name="address1">string</param>
/// <param name="address2">string</param>
/// <param name="address3">string</param>
/// <param name="state">string</param>
/// <param name="city">string</param>
/// <param name="pincode">string</param>
/// <returns>SessionResponseObject</returns>
public ResponseObjectForAnything UpdateContactInfoByUserId(string sessionKey, string address1, string address2, string address3, string stateID, string countryID, string city, string pincode)
{
AuthenticationEngine authEngine = new AuthenticationEngine();
ResponseObjectForAnything responseObject = new ResponseObjectForAnything();
User user = new User();
bool isValid = authEngine.IsValidSession(sessionKey);
if (isValid)
{
if (!string.IsNullOrEmpty(sessionKey))
{
responseObject = authEngine.GetUserFromSession(sessionKey);
user = (User)Serializer.JSONStringToObject<User>(responseObject.ResultObjectJSON);
}
if (user != null)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_UpdateContactByUserID");
db.AddInParameter(dbCommand, "UserID", DbType.Int32, user.UserID);
db.AddInParameter(dbCommand, "Address1", DbType.String, address1);
db.AddInParameter(dbCommand, "Address2", DbType.String, address2);
db.AddInParameter(dbCommand, "Address3", DbType.String, address3);
db.AddInParameter(dbCommand, "State", DbType.String, stateID);
db.AddInParameter(dbCommand, "City", DbType.String, city);
db.AddInParameter(dbCommand, "PinCode", DbType.String, pincode);
dbCommand.ExecuteNonQuery();
responseObject.ResultCode = "SUCCESS";
responseObject.ResultMessage = "Contact information updated successfully.";
}
catch (Exception ex)
{
responseObject.ResultCode = "ERROR";
responseObject.ResultMessage = ex.Message;
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "UpdateContactInfoByUserId", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
}
return (responseObject);
}
/// <summary>
/// This method creates/updates a problem into the system.
/// </summary>
/// <param name="sessionKey">string</param>
/// <param name="problemId">string</param>
/// <param name="companyRelated">string</param>
/// <param name="companyId">string</param>
/// <param name="problemHeading">string</param>
/// <param name="hastags">string</param>
/// <param name="categoryId">string</param>
/// <param name="subcategoryId">string</param>
/// <param name="productId">string</param>
/// <param name="modelNo">string</param>
/// <param name="description">string</param>
/// <param name="purchaseMonth">string</param>
/// <param name="purchaseYear">string</param>
/// <param name="productStatus">string</param>
/// <param name="resolutionneededby">string</param>
/// <param name="thumbnailmedia">string</param>
/// <param name="hashtags">string</param>
/// <param name="imagesupload">string</param>
/// <param name="videosupload">string</param>
/// <param name="isVirtual">string</param>
/// <param name="isRegisteredAddress">string</param>
/// <param name="address1">string</param>
/// <param name="address2">string</param>
/// <param name="address3">string</param>
/// <param name="city">string</param>
/// <param name="stateId">string</param>
/// <param name="countryId">string</param>
/// <param name="pinCode">string</param>
/// <param name="isEdit">string</param>
/// <returns>string</returns>
public string SaveProblem(string sessionKey, string problemId, string companyRelated, string companyId, string problemHeading, string categoryId, string subcategoryId, string productId, string modelNo,
string description, string purchaseMonth, string purchaseYear, string productStatus, string resolutionneededby, string hashtags, string isVirtual,
string isRegisteredAddress, string address1, string address2, string address3, string city, string stateId, string countryId, string pinCode)
{
string retVal = string.Empty;
Int32 probId = -1;
AuthenticationEngine authEngine = new AuthenticationEngine();
MyProfileObject user = new MyProfileObject();
bool isValid = authEngine.IsValidSession(sessionKey);
ResponseObjectForAnything responseobject = new ResponseObjectForAnything();
if(isValid)
{
responseobject = authEngine.GetUserFromSession(sessionKey);
user = (MyProfileObject)Serializer.JSONStringToObject<MyProfileObject>(responseobject.ResultObjectJSON);
if (user != null)
{
try
{
if (!string.IsNullOrEmpty(problemId)) { probId = Int32.Parse(problemId); }
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("usp_UpsertProblem");
if (!string.IsNullOrEmpty(problemId)) { db.AddInParameter(dbCommand, "ProblemId", DbType.Int32, Int32.Parse(problemId)); }
else { db.AddInParameter(dbCommand, "ProblemId", DbType.Int32, null); }
db.AddInParameter(dbCommand, "UserId", DbType.Int32, user.UserObject.UserID);
db.AddInParameter(dbCommand, "CompanyRelated", DbType.Boolean, Convert.ToBoolean(companyRelated));
if (!string.IsNullOrEmpty(companyId)) { db.AddInParameter(dbCommand, "CompanyID", DbType.Int32, Int32.Parse(companyId)); }
db.AddInParameter(dbCommand, "ProblemHeading", DbType.String, problemHeading);
db.AddInParameter(dbCommand, "CategoryID", DbType.Int32, Int32.Parse(categoryId));
db.AddInParameter(dbCommand, "SubCategoryID", DbType.Int32, Int32.Parse(subcategoryId));
if (!string.IsNullOrEmpty(productId)) { db.AddInParameter(dbCommand, "ProductID", DbType.Int32, Int32.Parse(productId)); }
db.AddInParameter(dbCommand, "ModelNo", DbType.String, modelNo);
db.AddInParameter(dbCommand, "Description", DbType.String, description);
db.AddInParameter(dbCommand, "PurchaseMonth", DbType.String, purchaseMonth);
db.AddInParameter(dbCommand, "PurchaseYear", DbType.String, purchaseYear);
db.AddInParameter(dbCommand, "ProductStatusID", DbType.String, Int32.Parse(productStatus));
if (!string.IsNullOrEmpty(resolutionneededby)) { db.AddInParameter(dbCommand, "ResolutionNeededBy", DbType.DateTime, Convert.ToDateTime(resolutionneededby)); }
else { db.AddInParameter(dbCommand, "ResolutionNeededBy", DbType.DateTime, null); }
string[] problemhashtags = hashtags.Split(",".ToCharArray());
DataSet dsHashTags = ToDataSet(problemhashtags, "Name");
db.AddInParameter(dbCommand, "ProblemHashTags", DbType.Xml, dsHashTags.GetXml());
db.AddInParameter(dbCommand, "IsVirtual", DbType.Boolean, Convert.ToBoolean(isVirtual));
db.AddInParameter(dbCommand, "IsRegisteredAddress", DbType.Boolean, Convert.ToBoolean(isRegisteredAddress));
db.AddInParameter(dbCommand, "Address1", DbType.String, address1);
db.AddInParameter(dbCommand, "Address2", DbType.String, address2);
db.AddInParameter(dbCommand, "Address3", DbType.String, address3);
db.AddInParameter(dbCommand, "City", DbType.String, city);
if (!string.IsNullOrEmpty(stateId)) { db.AddInParameter(dbCommand, "StateID", DbType.Int32, Convert.ToInt32(stateId)); }
else { db.AddInParameter(dbCommand, "StateID", DbType.Int32, null); }
if (!string.IsNullOrEmpty(countryId)) { db.AddInParameter(dbCommand, "CountryID", DbType.Int32, countryId); }
{ db.AddInParameter(dbCommand, "CountryID", DbType.Int32, null); }
db.AddInParameter(dbCommand, "PinCode", DbType.String, pinCode);
float latitude, longitude;
GeoHelper geoHelper = new GeoHelper();
geoHelper.GetGeoLocationByPinCode(pinCode, out latitude, out longitude);
db.AddInParameter(dbCommand, "Latitude", DbType.Decimal, latitude);
db.AddInParameter(dbCommand, "Longitude", DbType.Decimal, longitude);
if (string.IsNullOrEmpty(problemId))
{
probId = Int32.Parse(db.ExecuteScalar(dbCommand).ToString());
if(probId > 0)
responseobject.ResultCode = "SUCCESS";
else
responseobject.ResultCode = "ERROR";
responseobject.ResultMessage = "Problem created successfully.";
responseobject.ResultObjectID = probId;
}
else
{
db.ExecuteNonQuery(dbCommand);
responseobject.ResultCode = "SUCCESS";
responseobject.ResultMessage = "Problem saved successfully.";
}
}
catch (Exception ex)
{
responseobject.ResultCode = "ERROR";
responseobject.ResultMessage = ex.Message;
CustomException exc = new CustomException(ex.ToString(), this.ToString(), "SaveProblem", System.DateTime.Now);
ExceptionManager.PublishException(exc);
}
}
}
retVal = Serializer.ObjectToJSON(responseobject);
return retVal;
}
