public List<Contact> GetListContact() { List<Contact> list = new List<Contact>(); Contact ins; //...Database Connection... DataBaseConnection dbConn = new DataBaseConnection(); SqlConnection con = dbConn.SqlConn(); SqlCommand cmdI; //...SQL Commands... cmdI = new SqlCommand("SELECT * FROM Contact", con); cmdI.Connection.Open(); SqlDataReader drI = cmdI.ExecuteReader(); //...Retrieve Data... if (drI.HasRows) { while (drI.Read()) { ins = new Contact(); ins.ContactId = Convert.ToInt32(drI["ContactId"]); ins.Number = drI["Title"].ToString(); ins.Body = drI["Body"].ToString(); ins.Surname = drI["Surname"].ToString(); ins.Name = drI["Name"].ToString(); list.Add(ins); } } drI.Close(); con.Close(); return list; }
public Contact GetContact(int ContactId) { Contact ins = new Contact(); //...Database Connection... DataBaseConnection dbConn = new DataBaseConnection(); SqlConnection con = dbConn.SqlConn(); SqlCommand cmdI; //...SQL Commands... cmdI = new SqlCommand("SELECT * FROM Contacts WHERE ContactsId =" + ContactId, con); cmdI.Connection.Open(); SqlDataReader drI = cmdI.ExecuteReader(); //...Retrieve Data... if (drI.HasRows) { while (drI.Read()) { ins.ContactId = Convert.ToInt32(drI["ContactsId"]); ins.ClientId = Convert.ToInt32(drI["ClientId"]); ins.Name = drI["Name"].ToString(); ins.Surname = drI["Surname"].ToString(); ins.Number = drI["Number"].ToString(); ins.Body = drI["Body"].ToString(); ins.Email = drI["Email"].ToString(); } } drI.Close(); con.Close(); return ins; }
public Contact UpdateContact(Contact ins) { //...Database Connection... DataBaseConnection dbConn = new DataBaseConnection(); SqlConnection con = dbConn.SqlConn(); con.Open(); SqlCommand cmdI = con.CreateCommand(); cmdI.Connection = con; //...Update Record... cmdI.Parameters.Clear(); cmdI.CommandText = "f_Admin_Update_Contact"; cmdI.CommandType = System.Data.CommandType.StoredProcedure; cmdI.Parameters.AddWithValue("@ContactId", ins.ContactId); // int cmdI.Parameters.AddWithValue("@Name", ins.Name); // varchar(50) cmdI.Parameters.AddWithValue("@Surname", ins.Surname); // varchar(max) cmdI.Parameters.AddWithValue("@Number", ins.Number); //varchar(20) cmdI.Parameters.AddWithValue("@Body", ins.Body); //Varchar(max) cmdI.Parameters.AddWithValue("@Email", ins.Email); //Varchar(100) cmdI.Parameters.AddWithValue("@ClientId", ins.ClientId); //int cmdI.ExecuteNonQuery(); cmdI.Connection.Close(); return ins; }
public Contact InsertContact(Contact ins) { //...Get User and Date Data... string strTrx = "Insert_Contact"; //...Database Connection... DataBaseConnection dbConn = new DataBaseConnection(); SqlConnection con = dbConn.SqlConn(); con.Open(); //...Command Interface... SqlCommand cmdI = con.CreateCommand(); SqlTransaction trx; trx = con.BeginTransaction(strTrx); cmdI.Connection = con; cmdI.Transaction = trx; try { //...Insert Record... cmdI.Parameters.Clear(); cmdI.CommandText = "f_Admin_Insert_Contact"; //cmdI.Connection.Open(); cmdI.CommandType = System.Data.CommandType.StoredProcedure; cmdI.Parameters.AddWithValue("@Name", ins.Name); // varchar(50) cmdI.Parameters.AddWithValue("@Surname", ins.Surname); // varchar(50) cmdI.Parameters.AddWithValue("@Number", ins.Number); //Varrchar(20) cmdI.Parameters.AddWithValue("@Body", ins.Body); //Varchar(max) cmdI.Parameters.AddWithValue("@Email", ins.Email); //varchar(100) cmdI.Parameters.AddWithValue("@ClientId", ins.ClientId); //int //...Return new ID... ins.ContactId = (int)cmdI.ExecuteScalar(); //...Commit Transaction... trx.Commit(); cmdI.Connection.Close(); } catch (SqlException ex) { if (trx != null) trx.Rollback(); //...Save Error to Log... Functions func = new Functions(); func.LogError(ex.ToString()); } finally { //...Check for close and respond accordingly.. if (con.State != ConnectionState.Closed) { con.Close(); } //...Clean up... con.Dispose(); cmdI.Dispose(); trx.Dispose(); } return ins; }
public ActionResult _UpdateContact(Contact ins) { ContactRepository conRep = new ContactRepository(); ins.ClientId = Convert.ToInt32(HttpContext.Session["ClientId"]); Contact ins2 = conRep.UpdateContact(ins); //...Notify... string regIds = AppRep.GetAllRegIds(ins.ClientId); if (!regIds.Equals("")) { comrep.NewUpdateData(regIds, "CMD_EDITCONTACT", ins2.ContactId.ToString()); } //...Repopulate Grid... List<Contact> lst = new List<Contact>(); lst = conRep.GetListContact(Convert.ToInt32(HttpContext.Session["ClientId"])); return View(new GridModel(lst)); }
public ActionResult _InsertContact(Contact ins) { //...Fix... ins.ClientId = Convert.ToInt32(HttpContext.Session["ClientId"]); //...Insert into Database... Contact ins2 = conRep.InsertContact(ins); //...Notify... string regIds = AppRep.GetAllRegIds(ins.ClientId); List<string> reg = AppRep.GetAllRegIdsList(ins.ClientId); if (!regIds.Equals("")) { comrep.NewsyncData(regIds, "CMD_NEWCONTACT", reg, ins.ClientId); } //...Repopulate Grid... List<Contact> lst = new List<Contact>(); lst = conRep.GetListContact(Convert.ToInt32(HttpContext.Session["ClientId"])); return View(new GridModel(lst)); }