public string Add(Mobiledata obj) { var query = "insert into BancoTeste (MobileName, MobileIMEno, MobileManufactured, Mobileprice)" + "values(@MobileName, @MobileIMEno, @MobileManufactured, @Mobileprice)"; con.Execute(query, new { obj.MobileIMEno, obj.MobileManufactured, obj.MobileName, obj.Mobileprice }); string result = "Enviado com sucesso!"; return(result); }
public string Updatemobile(Mobiledata objMD) { string query = "update BancoTeste SET MobileName=@MobileName,MobileIMEno=@MobileIMEno," + "MobileManufactured=@MobileManufactured,Mobileprice =@Mobileprice " + "where MobileID =@MobileID"; con.Execute(query, new { objMD.MobileIMEno, objMD.MobileManufactured, objMD.MobileName, objMD.Mobileprice, objMD.MobileID }); string result = "updated"; return(result); }