public ResponseInfo <string> PostTruckVisualPictures(ReqPostTruckVisualPictures data)
{
ResponseInfo <string> res = new ResponseInfo <string>();
try
{
EPODDAL.PostTruckVisualPictures(data);
res.ResponseData = "Success";
}
catch (Exception ex)
{
throw ex;
}
return(res);
}
public void PostTruckVisualPictures(ReqPostTruckVisualPictures data)
{
using (IDbConnection connection = GetOpenConnection())
{
try
{
string sql = @" update TruckVisualPictures
set PictureImage = @PictureImage,
ModifiedBy = @UserID,
ModifiedOn = getdate()
Where TVPictureID = @TVPictureID
and PictureApprovedStatus = 0
";
connection.ExecuteScalar(sql, new { PictureImage = Convert.FromBase64String(data.PictureImage), UserID = data.UserID, TVPictureID = data.TVPictureID }, commandType: CommandType.Text);
}
catch (Exception ex)
{
throw ex;
}
}
}
