/// <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); }