public bool SaveFile(FlileModel CIM) { try { var query = "INSERT INTO tbl_File (Name, Image, ClientId) VALUES('" + CIM.Name + "','" + CIM.Image + "','" + CIM.ClientId + "')"; var rowAffected = _databaseCDb.ExecuteNonQuery(query, _connectionString); return(rowAffected > 0); } catch (Exception e) { throw new Exception(e.Message); } }
protected void ClientListGridView_SelectedIndexChanged(object sender, EventArgs e) { var sql = DatabaseCDb.ConnectionString(); using (SqlConnection Sqlcon = new SqlConnection(sql)) { FlileModel _ClientFile = new FlileModel(); Sqlcon.Open(); string query = "Select Name, Image From tbl_File Where ClientId=''" + _ClientFile.ClientId + ""; using (SqlCommand cmd = new SqlCommand(query, Sqlcon)) { } } }
public void Refresh() { var sql = databaseCDb.ConnectionStrings(); using (SqlConnection Sqlcon = new SqlConnection(sql)) { Sqlcon.Open(); try { //get Id SqlCommand command2 = new SqlCommand("Select top 1 Id from tbl_ClientInfo order by Id desc", Sqlcon); command2.CommandType = CommandType.Text; var Id = command2.ExecuteScalar(); //end //File Save Start DataTable data = (DataTable)ViewState["Details"]; foreach (DataRow dr in data.Rows) { FlileModel _ClientFile = new FlileModel(); _ClientFile.Name = dr["Name"].ToString(); _ClientFile.Image = (byte[])dr["Image"]; _ClientFile.ClientId = Convert.ToInt32(Id); string query = "INSERT INTO tbl_File VALUES(@Name, @Image, @ClientId)"; using (SqlCommand cmd = new SqlCommand(query, Sqlcon)) { cmd.Parameters.AddWithValue("@Name", _ClientFile.Name); cmd.Parameters.AddWithValue("@Image", _ClientFile.Image); cmd.Parameters.AddWithValue("@ClientId", _ClientFile.ClientId); cmd.ExecuteNonQuery(); } } Response.Redirect(Request.Url.AbsoluteUri); } catch { //transaction.Rollback(); } finally { Sqlcon.Close(); } } }