public static INV_IssueMaster GetINV_StoreByStoreID(int StoreID)
{
INV_IssueMaster iNV_IssueMaster = new INV_IssueMaster();
SqlINV_IssueMasterProvider sqlINV_IssueMasterProvider = new SqlINV_IssueMasterProvider();
iNV_IssueMaster = sqlINV_IssueMasterProvider.GetINV_IssueMasterByStoreID(StoreID);
return iNV_IssueMaster;
}
public static INV_IssueMaster GetSTD_CampusByCampusID(int CampusID)
{
INV_IssueMaster iNV_IssueMaster = new INV_IssueMaster();
SqlINV_IssueMasterProvider sqlINV_IssueMasterProvider = new SqlINV_IssueMasterProvider();
iNV_IssueMaster = sqlINV_IssueMasterProvider.GetINV_IssueMasterByCampusID(CampusID);
return iNV_IssueMaster;
}
public static INV_IssueMaster GetINV_IssueMasterByIssueMasterID(int IssueMasterID)
{
INV_IssueMaster iNV_IssueMaster = new INV_IssueMaster();
SqlINV_IssueMasterProvider sqlINV_IssueMasterProvider = new SqlINV_IssueMasterProvider();
iNV_IssueMaster = sqlINV_IssueMasterProvider.GetINV_IssueMasterByIssueMasterID(IssueMasterID);
return iNV_IssueMaster;
}
protected void btnUpdate_OnClick(object sender, EventArgs e)
{
lblMessage.Text = "";
INV_Issue issue = new INV_Issue();
issue.IssueMasterID = Convert.ToInt32(hdnIssueMasterID.Value);
issue.IssueID = Convert.ToInt32(hdnIssueID.Value);
issue.IssueNo = txtIssueNo.Text.Trim();
issue.StoreID = Convert.ToInt32(ddlStoreFromID.SelectedValue);
issue.ItemID = Convert.ToInt32(ddlItemList.SelectedValue);
issue.Quantity = Convert.ToDecimal(txtQty.Text.Trim());
issue.TagID = txtTagID.Text.Trim();
issue.IssueDate = Convert.ToDateTime(txtIssueDate.Text.Trim());
issue.ProductionCode = "0";
//string userID = Profile.card_id;
issue.UpdatedBy = Profile.card_id;
issue.UpdatedDate = DateTime.Now;
INV_IssueMaster issueMaster = new INV_IssueMaster();
if (hdnIssueMasterID.Value != string.Empty)
{
issueMaster = INV_IssueMasterManager.GetINV_IssueMasterByIssueMasterID(Convert.ToInt32(hdnIssueMasterID.Value));
if (issueMaster != null)
{
issueMaster.Quantity = issueMaster.Quantity - ((Convert.ToDecimal(hdnTotalQnty.Value)) - Convert.ToDecimal(txtQty.Text.Trim()));
issueMaster.UpdatedBy = Profile.card_id;
issueMaster.UpdatedDate = DateTime.Now;
INV_IssueMasterManager.UpdateINV_IssueMaster(issueMaster);
}
}
bool result = INV_IssueManager.UpdateINV_Issue(issue);
if (result == true)
{
lblFinalMessage.Text = "Updated Successfully";
}
else
{
lblFinalMessage.Text = "Updating Failed";
}
Response.Redirect("AdminDisplayINV_Issue.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
INV_IssueMaster iNV_IssueMaster = new INV_IssueMaster();
iNV_IssueMaster.IssueMasterID = int.Parse(Request.QueryString["ID"].ToString());
iNV_IssueMaster.IssueMasterName = txtIssueMasterName.Text;
iNV_IssueMaster.CampusID = int.Parse(ddlCampusID.SelectedValue);
iNV_IssueMaster.StoreID = int.Parse(ddlStoreID.SelectedValue);
iNV_IssueMaster.ProductionCode = txtProductionCode.Text;
iNV_IssueMaster.Quantity = decimal.Parse(txtQuantity.Text);
iNV_IssueMaster.IssueDate = DateTime.Parse(txtIssueDate.Text);
iNV_IssueMaster.AddedBy = Profile.card_id;
iNV_IssueMaster.AddedDate = DateTime.Now;
iNV_IssueMaster.UpdatedBy = Profile.card_id;
iNV_IssueMaster.UpdatedDate = DateTime.Now;
bool resutl = INV_IssueMasterManager.UpdateINV_IssueMaster(iNV_IssueMaster);
}
catch (Exception ex) { } Response.Redirect("AdminDisplayINV_IssueMaster.aspx");
}
public bool UpdateINV_IssueMaster(INV_IssueMaster iNV_IssueMaster)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateINV_IssueMaster", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@IssueMasterID", SqlDbType.Int).Value = iNV_IssueMaster.IssueMasterID;
cmd.Parameters.Add("@IssueMasterName", SqlDbType.NVarChar).Value = iNV_IssueMaster.IssueMasterName;
cmd.Parameters.Add("@CampusID", SqlDbType.Int).Value = iNV_IssueMaster.CampusID;
cmd.Parameters.Add("@StoreID", SqlDbType.Int).Value = iNV_IssueMaster.StoreID;
cmd.Parameters.Add("@ProductionCode", SqlDbType.NVarChar).Value = iNV_IssueMaster.ProductionCode;
cmd.Parameters.Add("@Quantity", SqlDbType.Decimal).Value = iNV_IssueMaster.Quantity;
cmd.Parameters.Add("@IssueDate", SqlDbType.DateTime).Value = iNV_IssueMaster.IssueDate;
//cmd.Parameters.Add("@IssueDate", SqlDbType.DateTime).Value = iNV_IssueMaster.IssueDate;
//cmd.Parameters.Add("@IssueDate", SqlDbType.DateTime).Value = iNV_IssueMaster.IssueDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = iNV_IssueMaster.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = iNV_IssueMaster.UpdatedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public INV_IssueMaster GetINV_IssueMasterFromReader(IDataReader reader)
{
try
{
INV_IssueMaster iNV_IssueMaster = new INV_IssueMaster
(
DataAccessObject.IsNULL<int>(reader["IssueMasterID"]),
DataAccessObject.IsNULL<string>(reader["IssueMasterName"]),
DataAccessObject.IsNULL<int>(reader["CampusID"]),
DataAccessObject.IsNULL<int>(reader["StoreID"]),
DataAccessObject.IsNULL<string>(reader["ProductionCode"]),
DataAccessObject.IsNULL<decimal>(reader["Quantity"]),
DataAccessObject.IsNULL<DateTime>(reader["IssueDate"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["UpdatedDate"])
);
return iNV_IssueMaster;
}
catch (Exception ex)
{
return null;
}
}
public static int InsertINV_IssueMaster(INV_IssueMaster iNV_IssueMaster)
{
SqlINV_IssueMasterProvider sqlINV_IssueMasterProvider = new SqlINV_IssueMasterProvider();
return sqlINV_IssueMasterProvider.InsertINV_IssueMaster(iNV_IssueMaster);
}
public static bool UpdateINV_IssueMaster(INV_IssueMaster iNV_IssueMaster)
{
SqlINV_IssueMasterProvider sqlINV_IssueMasterProvider = new SqlINV_IssueMasterProvider();
return sqlINV_IssueMasterProvider.UpdateINV_IssueMaster(iNV_IssueMaster);
}
private void showINV_IssueMasterData()
{
INV_IssueMaster iNV_IssueMaster = new INV_IssueMaster();
iNV_IssueMaster = INV_IssueMasterManager.GetINV_IssueMasterByIssueMasterID(Int32.Parse(Request.QueryString["ID"]));
txtIssueMasterName.Text = iNV_IssueMaster.IssueMasterName.ToString();
ddlCampusID.SelectedValue = iNV_IssueMaster.CampusID.ToString();
ddlStoreID.SelectedValue = iNV_IssueMaster.StoreID.ToString();
txtProductionCode.Text = iNV_IssueMaster.ProductionCode.ToString();
txtQuantity.Text = iNV_IssueMaster.Quantity.ToString();
txtIssueDate.Text = iNV_IssueMaster.IssueDate.ToString();
string txtUpdatedBy_Text = iNV_IssueMaster.UpdatedBy.ToString();
string txtUpdatedDate_Text = iNV_IssueMaster.UpdatedDate.ToString();
}
