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(); }