public int INSERT_File_DETAILS( FileUpload objlog) { dbAccess db = new dbAccess(); db.AddParameter("@UserId", objlog.UserId); db.AddParameter("@FileName", objlog.FileName); db.AddParameter("@FileSize", objlog.FileSize); db.AddParameter("@ContentType", objlog.FileType); db.AddParameter("@FileExtension", objlog.Extension); db.AddParameter("@FilePath", objlog.FilePath); return db.ExecuteNonQuery("SP_INSERTFILEDETAILS"); }
public int INSERT_File_Excel(FileUpload objlog) { dbAccess db = new dbAccess(); db.AddParameter("@UserId", objlog.UserId); db.AddParameter("@Id", objlog.Id); db.AddParameter("@Name", objlog.Name); db.AddParameter("@City", objlog.City); db.AddParameter("@Address", objlog.Address); db.AddParameter("@Designation", objlog.Designation); return db.ExecuteNonQuery("SP_INSERTEXCELDETAILS"); }
public int Downlaod_File(FileUpload objlog) { dbAccess db = new dbAccess(); db.AddParameter("@UserId", objlog.UserId); db.AddParameter("@FileId", objlog.FileId); return db.ExecuteNonQuery("SP_DOWNLOADFILE"); }