public void Update()
{
string querry = "update InvoiceType set InvoiceType=@type where InvoiceTypeId=" + id;
SqlParm s1 = new SqlParm();
s1.Add("type", type);
database.ExecuteQuerry(querry, s1.GetParmList());
}
public void Create()
{
string querry = "insert into InvoiceType (InvoiceType)values(@type)";
SqlParm s1 = new SqlParm();
s1.Add("type", type);
database.ExecuteQuerry(querry, s1.GetParmList());
}
public void Update()
{
SqlParm s1 = new SqlParm();
s1.Add("name", name);
s1.Add("ven", IsVendor);
database.ExecuteQuerry("update party set Name=@name ,IsVendor=@ven where PartyId=" + id, s1.GetParmList());
}
public void Update()
{
string querry = "update Location set Name=@name,IsShop=@ish where LocationId=" + id;
SqlParm s1 = new SqlParm();
s1.Add("name", name);
s1.Add("ish", IsShop);
database.ExecuteQuerry(querry, s1.GetParmList());
}
public void create()
{
string querry = "insert into Location (Name,IsShop)values(@name,@ish)";
SqlParm s1 = new SqlParm();
s1.Add("name", name);
s1.Add("ish", IsShop);
database.ExecuteQuerry(querry, s1.GetParmList());
}
public void Create()
{
string querry = "insert into Party(Name,IsVendor)values(@name,@ven)";
var x = new SqlParm();
x.Add("name", name);
x.Add("ven", IsVendor);
database.ExecuteQuerry(querry, x.GetParmList());
}
public void Register()
{
db d1 = new db();
SqlParm s1 = new SqlParm();
s1.Add("name", Name);
s1.Add("email", Email);
s1.Add("pass", Password);
d1.ExecuteQuerry(@"
INSERT INTO [dbo].[users]
(
[Name]
,[email]
,[password])
VALUES
(@name,@email,@pass);
", s1.GetParmList());
}
