public bool AddInvoice(DataLayer dt)
{
int rep = 0;
try
{
object[,] Params = new object[2, 4];
Params[0, 0] = "@InvoiceID";
Params[1, 0] = this.ID;
Params[0, 1] = "@InvoiceDate";
Params[1, 1] = Transform.DateToString(this.InvoiceDate);
Params[0, 2] = "@IsPayed";
Params[1, 2] = 0;
Params[0, 3] = "@SupplierID";
Params[1, 3] = this.Supplier;
rep = dt.ExecuteActionCommand_StoredProcedure("AddInvoice", Params);
if (rep > 0)
{
return(true);
}
else
{
return(false);
}
}
catch { return(false); }
}
} //function
#region functions
public bool AddInvoiceDetails(DataLayer dt)
{
int rep = 0;
try
{
object[,] Params = new object[2, 7];
Params[0, 0] = "@InvoiceID";
Params[1, 0] = this.InvoiceID;
Params[0, 1] = "@MedecineID";
Params[1, 1] = this.MedecineID;
Params[0, 2] = "@Quantity";
Params[1, 2] = this.Quantity;
Params[0, 3] = "@UnitPrice";
Params[1, 3] = this.UnitPrice;
Params[0, 4] = "@Discount";
Params[1, 4] = this.Discount;
Params[0, 5] = "@VAT";
Params[1, 5] = this.VAT;
Params[0, 6] = "@ExpiryDate";
Params[1, 6] = Transform.DateToString(this.ExpiryDate);
rep = dt.ExecuteActionCommand_StoredProcedure("AddInvoiceDetails", Params);
if (rep > 0)
{
return(true);
}
else
{
return(false);
}
}
catch { return(false); }
}
public static bool AddInvoiceDetails(DataLayer dt, object[,] Params)
{
int rep = 0;
try
{
rep = dt.ExecuteActionCommand_StoredProcedure("AddInvoiceDetails", Params);
if (rep > 0)
{
return(true);
}
else
{
return(false);
}
}
catch { return(false); }
}
public static bool UpdateStocks(DataLayer dt, int M_ID, int AddedQuantity)
{
int rep = 0;
try
{
object[,] Params = new object[2, 2];
Params[0, 0] = "@M_ID";
Params[1, 0] = M_ID;
Params[0, 1] = "@Qty";
Params[1, 1] = AddedQuantity;
rep = dt.ExecuteActionCommand_StoredProcedure("UpdateStocks", Params);
if (rep > 0)
{
return(true);
}
else
{
return(false);
}
}
catch { return(false); }
}