public ActionResult Update(int id) { list = inter.Show_Record(); XpayDetails s1 = list.FirstOrDefault(s => s.Id == id); return(View(s1)); }
protected void Button2_Click(object sender, EventArgs e) { XpayDetails xp = new XpayDetails(); xp.Id = Convert.ToInt32(TextBox1.Text); imp.Dlt_Record(xp); Button1_Click(sender, e); }
public void Dlt_Record(XpayDetails xp) { SqlCommand com = new SqlCommand("XpayDeleteData", con); com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue("@Id", xp.Id); con.Open(); com.ExecuteNonQuery(); con.Close(); }
protected void Button1_Click(object sender, EventArgs e) { XpayDetails xp = new XpayDetails(); string Name = Convert.ToString(TextBox1.Text); decimal Amount = Convert.ToDecimal(TextBox2.Text); string Description = Convert.ToString(TextBox3.Text); string TermAndCondition = Convert.ToString(TextBox4.Text); xp.Name = Name; xp.Amount = Amount; xp.Description = Description; xp.TermAndCondition = TermAndCondition; imp.Insert_record(xp); }
public void Update_Record(XpayDetails xp) { try { SqlCommand com = new SqlCommand("XpayUpdateData", con); com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue("@Id", xp.Id); com.Parameters.AddWithValue("@Name", xp.Name); com.Parameters.AddWithValue("@Amount", xp.Amount); com.Parameters.AddWithValue("@Description ", xp.Description); com.Parameters.AddWithValue("@TermAndCondition", xp.TermAndCondition); con.Open(); com.ExecuteNonQuery(); Console.WriteLine("Data Updated"); con.Close(); } catch (Exception e) { Console.Write(e); } }
public ActionResult Update(XpayDetails xp) { inter.Update_Record(xp); return(RedirectToAction("index")); }
public ActionResult Delete(XpayDetails xp) { inter.Dlt_Record(xp); return(RedirectToAction("index")); }
public ActionResult Create(XpayDetails xp) { inter.Insert_record(xp); return(RedirectToAction("index")); }
public static void Main() { InterfaceRepo empinterfece = new Implemantation(); XpayDetails xp = new XpayDetails(); Console.WriteLine("Enter 1:Insert \t 2:Delete \t 3: update\t 4: show:"); int i = Convert.ToInt32(Console.ReadLine()); if (i == 1) { Console.WriteLine("Id\t Name\t Amount\t Description\t TermAndCondition "); // int Id = Convert.ToInt32(Console.ReadLine()); string Name = Console.ReadLine(); decimal Amount = decimal.Parse(Console.ReadLine()); string Description = Console.ReadLine(); string TermAndCondition = Console.ReadLine(); //xp.Id=Id; xp.Name = Name; xp.Amount = Amount; xp.Description = Description; xp.TermAndCondition = TermAndCondition; empinterfece.Insert_record(xp); Main(); } if (i == 2) { Console.WriteLine("Enter id to dlt data"); int id = Convert.ToInt32(Console.ReadLine()); xp.Id = id; empinterfece.Dlt_Record(xp); Console.WriteLine("Datadeleted"); Main(); } if (i == 3) { Console.WriteLine("Id,Name,Amount,Description,TermAndCondition"); Console.WriteLine("Insert Id to be updated"); int Id = Convert.ToInt32(Console.ReadLine()); string Name = Console.ReadLine(); decimal Amount = decimal.Parse(Console.ReadLine()); string Description = Console.ReadLine(); string TermAndCondition = Console.ReadLine(); xp.Id = Id; xp.Name = Name; xp.Amount = Amount; xp.Description = Description; xp.TermAndCondition = TermAndCondition; empinterfece.Update_Record(xp); Main(); } if (i == 4) { List <XpayDetails> lst = new List <XpayDetails>(); lst = empinterfece.Show_Record(); foreach (var obj in lst) { Console.WriteLine("id=" + obj.Id + ",name=" + obj.Name + " and num=" + obj.Amount + "Description= " + obj.Description + "Term and condition= " + obj.TermAndCondition); } Main(); } Console.ReadLine(); }