internal DataSet GetAll(ProductOpeningProvider provider)
{
DataSet ds = new DataSet();
try
{
string sql = "EXEC [dbo].[spOpeningStock] @Option = 'Select'";
if (!provider.ProductId.Equals(0))
{
sql += ",@ProductID = " + provider.ProductId;
}
SqlCommand command = new SqlCommand();
this.ConnectionOpen();
command.Connection = Connection;
this.BeginTransaction(true);
command.Transaction = this.Transaction;
command.CommandType = CommandType.Text;
command.CommandText = sql;
new SqlDataAdapter(command).Fill(ds);
this.CommitTransaction();
this.ConnectionClosed();
}
catch (Exception exp)
{
this.RollbackTransaction();
throw new Exception(exp.Message);
}
finally
{
this.ConnectionClosed();
}
return(ds);
}
internal bool Delete(ProductOpeningProvider provider)
{
string query = "EXEC [dbo].[spOpeningStock]"
+ "@Option = 'Delete',"
+ "@ID = '" + provider.ID + "'";
return(ExecuteTextQuery(query));
}
private void Clear()
{
lblMsg.InnerText = string.Empty;
holdID.Value = string.Empty;
tbOpeningQty.Text = "0";
//tbOpeningAmount.Text = "0";
txtLocation.Text = string.Empty;
ddlDivision.SelectedIndex = 0;
provider = new ProductOpeningProvider();
LoadData();
}
//private SqlDataAdapter sqlDataAdapter = null;
public bool Save(ProductOpeningProvider provider)
{
string query = "EXEC [dbo].[spOpeningStock]"
+ "@Option = 'Save',"
+ "@ProductID = '" + provider.ProductId + "',"
+ "@OpeningQuantity = '" + provider.OpeningQty + "',"
+ "@OpeningAmount = '" + provider.OpeningAmount + "',"
+ "@Location = '" + provider.Locatioin + "',"
+ "@UserId = '" + provider.EntryUserID + "'";
return(ExecuteTextQuery(query));
}
protected void btnSave_Click(object sender, EventArgs e)
{
this.AlertNone(lblMsg);
try
{
Save();
provider = new ProductOpeningProvider();
LoadData();
}
catch (Exception ex)
{
MessageHelper.ShowAlertMessage(ex.Message);
}
}
