public List <StocksIn> GetAllStocks(string size, string code, int Id)
{
var _StocksInList = new List <StocksIn>();
string query = ("Select *From StockIn Where Size='" + size + "' And ItemCode='" + code + "' And CategoriesId='" + Id + "' And Date='" + DateTime.Now.ToShortDateString() + "'");
var reader = _MainRepository.Reader(query, _MainRepository.ConnectionString());
if (reader.HasRows)
{
while (reader.Read())
{
var _StocksIn = new StocksIn();
_StocksIn.Id = Convert.ToInt32(reader["Id"].ToString());
_StocksIn.ItemCode = (reader["ItemCode"].ToString());
_StocksIn.Quantity = Convert.ToInt32(reader["Quantity"].ToString());
_StocksIn.UnitCost = Convert.ToDecimal(reader["UnitCost"].ToString());
_StocksIn.Mrp = Convert.ToDecimal(reader["Mrp"].ToString());
_StocksIn.Date = (reader["Date"].ToString());
_StocksInList.Add(_StocksIn);
}
}
reader.Close();
return(_StocksInList);
}
protected void AddButton_Click(object sender, EventArgs e)
{
try
{
if (CategoriesDropDownList.SelectedIndex > 0)
{
StocksIn _StocksIn = new StocksIn();
_StocksIn.Quantity = Convert.ToInt32(txtQty.Text);
_StocksIn.Size = SizeDropDownList.SelectedItem.ToString();
_StocksIn.UnitCost = Convert.ToDecimal(txtCost.Text);
_StocksIn.Mrp = Convert.ToDecimal(txtMrp.Text);
_StocksIn.ItemName = ItemsDropDownList.SelectedItem.ToString();
_StocksIn.ItemCode = (txtCode.Text);
_StocksIn.CategoriesId = Convert.ToInt32(CategoriesDropDownList.SelectedValue);
int SaveSuccess = _StocksInRepository.Add(_StocksIn);
if (SaveSuccess > 0)
{
ShowMessage("Successfully Add Stock....", MessageType.Success);
LoadStocks();
GetAllCategories();
Refresh();
//Response.Redirect(Request.Url.AbsoluteUri);
}
else
{
ShowMessage("Failed Stock Input....", MessageType.Success);
}
}
}
catch (Exception ex)
{
ShowMessage(ex.Message, MessageType.Success);
}
}
private bool Add(StocksIn stocksIn)
{
bool isSucces = false;
try
{
sqlConnection = new SqlConnection(connectionString);
string query = @"INSERT INTO StockIn (ItemId, Quantity) VALUES ( " + stocksIn.ItemId + "," + stocksIn.Quantity + ")";
//5
SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
//6
sqlConnection.Open();
//7
int isExecuted = sqlCommand.ExecuteNonQuery();
if (isExecuted > 0)
{
isSucces = true;
}
else
{
isSucces = false;
}
//8
sqlConnection.Close();
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
return(isSucces);
}
public bool Add(StocksIn stockIn, long availableQuantity)
{
SqlConnection con = new SqlConnection(_conString);
string query = @"insert into Stocks values('" + stockIn.ItemId + "','" + availableQuantity + "')";
SqlCommand com = new SqlCommand(query, con);
con.Open();
bool rowAffect = com.ExecuteNonQuery() > 0;
con.Close();
return(rowAffect);
}
public DataTable LoadCompanyDropDown(StocksIn stocks)
{
SqlConnection con = new SqlConnection(_conString);
string query = "SELECT * FROM Companies";
SqlCommand com = new SqlCommand(query, con);
con.Open();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(com);
da.Fill(dt);
con.Close();
return(dt);
}
public StocksIn GetDataByCode(string code)
{
StocksIn _StocksIn = null;
string query = ("Select top 1 * from StockIn Where ItemCode = '" + code + "' order by Id desc");
var reader = _MainRepository.Reader(query, _MainRepository.ConnectionString());
if (reader.HasRows)
{
reader.Read();
_StocksIn = new StocksIn();
_StocksIn.ItemName = (reader["ItemName"].ToString());
_StocksIn.Mrp = Convert.ToDecimal(reader["Mrp"].ToString());
}
reader.Close();
return(_StocksIn);
}
public StocksIn GetQtyByCode(string code)
{
StocksIn _StocksIn = null;
string query = ("Select top 1 *from StockIn Where ItemCode='" + code + "' And Date='" + DateTime.Now.ToShortDateString() + "' order by Quantity desc");
var reader = _MainRepository.Reader(query, _MainRepository.ConnectionString());
if (reader.HasRows)
{
reader.Read();
_StocksIn = new StocksIn();
_StocksIn.Quantity = Convert.ToInt32(reader["Quantity"].ToString());
}
reader.Close();
return(_StocksIn);
}
public long availableQuantituLabel(long id1)
{
SqlConnection con = new SqlConnection(_conString);
// string query = @"select StockIn from Stocks where Id=( select max (Id) from Stocks) and ItemId='" +id1+ "'";
string query = @"select StockIn from Stocks where ItemId='" + id1 + "' and Id=(select max (Id)from Stocks where ItemId='" + id1 + "');";
SqlCommand com = new SqlCommand(query, con);
con.Open();
SqlDataReader dr = com.ExecuteReader();
if (dr.HasRows)
{
StocksIn stocksIn = new StocksIn();
if (dr.Read())
{
stocksIn.StockIn = Convert.ToInt64(dr["StockIn"].ToString());
}
return(stocksIn.StockIn);
}
con.Close();
return(0);
}
public int Add(StocksIn _StocksIn)
{
string query = "Insert Into StockIn(Quantity,Size,UnitCost,Mrp,ItemName,ItemCode,CategoriesId,Date) Values ('" + _StocksIn.Quantity + "','" + _StocksIn.Size + "','" + _StocksIn.UnitCost + "','" + _StocksIn.Mrp + "','" + _StocksIn.ItemName + "','" + _StocksIn.ItemCode + "','" + _StocksIn.CategoriesId + "','" + DateTime.Now.ToShortDateString() + "')";
return(_MainRepository.ExecuteNonQuery(query, _MainRepository.ConnectionString()));
}
public bool Add(StocksIn stockIn, long availableQuantity)
{
return(_stockInGetway.Add(stockIn, availableQuantity));
}
public DataTable LoadCompanyDropDown(StocksIn stocks)
{
return(_stockInGetway.LoadCompanyDropDown(stocks));
}
