/// <summary>
/// This will update the user profile pic path into DB after upload.
/// </summary>
/// <param name="UserID"></param>
/// <param name="filePath"></param>
/// <returns></returns>
public MDTTransactionInfo UploadProfilePic(int UserID, string filePath)
{
MDTTransactionInfo mdt = null;
List <SqlParameter> prm = new List <SqlParameter>();
SqlParameter userid = new SqlParameter("@UserID", UserID);
prm.Add(userid);
SqlParameter filepath = new SqlParameter("@ProfilePic", filePath);
prm.Add(filepath);
SqlParameter status = new SqlParameter("@Status", 0);
status.Direction = ParameterDirection.Output;
prm.Add(status);
int StatusValue = 0;
DataSet ds = DatabaseSettings.GetDataSet(APIHelper.UploadProfilePic, out StatusValue, prm);
UploadProfilePics uploadProfilePics = new UploadProfilePics();
if (StatusValue == 1)
{
mdt = new MDTTransactionInfo();
uploadProfilePics.ProfilePicPath = filePath;
mdt.transactionObject = uploadProfilePics;
mdt.status = HttpStatusCode.OK;
mdt.msgCode = MessageCode.Success;
mdt.message = "File uploaded successfully";
}
else if (StatusValue == 5 || StatusValue == 6)
{
mdt = DatabaseSettings.GetTransObject(null, StatusValue, "", ds);
}
//if (dt.Rows.Count == 1)
//{
// ErrorInfoFromSQL eInfo = DatabaseSettings.GetError(dt);
// mdt.transactionObject = eInfo;
// mdt.message = eInfo.ErrorMessage;
// mdt.msgCode = (eInfo.Status == 1) ? MessageCode.Success : (eInfo.Status == 6) ? MessageCode.TechnicalError : MessageCode.Failed;
// mdt.LineNumber = eInfo.ErrorLineNo;
// mdt.ProcedureName = eInfo.Procedure;
//}
return(mdt);
}
/// <summary>
/// This will update the user profile pic path into DB after upload.
/// </summary>
/// <param name="UserID"></param>
/// <param name="filePath"></param>
/// <returns></returns>
public MDTTransactionInfo UploadProfilePic(int userID, string filePath)
{
MDTTransactionInfo mdt = null;
try
{
List <SqlParameter> prm = new List <SqlParameter>();
//SqlParameter userid = new SqlParameter("@UserID", userID);
//prm.Add(userid);
//SqlParameter filepath = new SqlParameter("@ProfilePic", filePath);
//prm.Add(filepath);
//SqlParameter status = new SqlParameter("@Status", 0);
//status.Direction = ParameterDirection.Output;
//prm.Add(status);
prm = DatabaseSettings.BindParamers(APIHelper.uploadProfilePicParameters, userID.ToString() + "~||~" + filePath.ToString());
int StatusValue = 0;
DataSet ds = DatabaseSettings.GetDataSet(APIHelper.uploadProfilePic, out StatusValue, prm);
UploadProfilePics uploadProfilePics = new UploadProfilePics();
if (StatusValue == 1)
{
mdt = new MDTTransactionInfo();
uploadProfilePics.ProfilePicPath = filePath;
mdt.transactionObject = uploadProfilePics;
mdt.status = HttpStatusCode.OK;
mdt.msgCode = MessageCode.Success;
mdt.message = "File uploaded successfully";
}
else if (StatusValue == 5 || StatusValue == 6)
{
mdt = DatabaseSettings.GetTransObject(null, StatusValue, "", ds);
}
}
catch (Exception ex)
{
mdt.status = HttpStatusCode.ExpectationFailed;
mdt.msgCode = MessageCode.TechnicalError;
mdt.message = "Technical Error in the system, please contact to administrator";
}
return(mdt);
}
