public static string Manage(NameValueCollection querystring, NameValueCollection formdata) { string isInsert = querystring.Get("TransType"); int intParser; decimal decParser; UserProfile userProfile = WebCommon.GetUserProfile(); var bprEntryLedgers = new List <GLEntries>(); bprEntryLedgers = (List <GLEntries>)bprEntryLedgers.ToClass(formdata["Data"]); var bpradjustment = new BPRAdjustment { BPRAdjustmentID = int.TryParse(querystring.Get("BPRAdjustmentID"), out intParser) ? intParser : 0, AdjustmentNo = int.TryParse(querystring.Get("AdjustmentNo"), out intParser) ? intParser : 0, AdjustmentDate = querystring.Get("AdjustmentDate"), BranchID = int.TryParse(querystring.Get("BranchID"), out intParser) ? intParser : 0, AdjustmentTypeID = int.TryParse(querystring.Get("AdjustmentTypeID"), out intParser) ? intParser : 0, BPRID = int.TryParse(querystring.Get("BPRID"), out intParser) ? intParser : 0, Total = decimal.TryParse(querystring.Get("Total"), out decParser) ? decParser : 0, Remarks = querystring.Get("Remarks"), Details = bprEntryLedgers, UserID = userProfile.UserId }; string param = WebCommon.ToXML(bpradjustment); return(BPRAdjustmentDAL.Manage(param, isInsert)); }
private void Manage() { string result = BPRAdjustmentBAL.Manage(Request.QueryString, Request.Form); var bpradjustment = new BPRAdjustment { BPRAdjustmentID = Convert.ToInt32(result.Split(',')[0]), AdjustmentNo = Convert.ToInt32(result.Split(',')[1]) }; Response.Write(bpradjustment.ToJSON()); }
public static List <BPRAdjustment> GetBPRAdjustment(int branchid, string criteria) { var dbUtil = new DatabaseManager(); var bpradjustments = new List <BPRAdjustment>(); using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB"))) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spDisSearchBudget"; cmd.CommandTimeout = 180; cmd.Parameters.Clear(); //cmd.Parameters.AddWithValue("@intBranchID", branchid); cmd.Parameters.AddWithValue("@strCriteria", criteria); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { var bpradjustment = new BPRAdjustment { budgetID = ReferenceEquals(reader["intBudgetID"], DBNull.Value) ? 0 : (int)reader["intBudgetID"], BranchName = ReferenceEquals(reader["strBranchName"], DBNull.Value) ? String.Empty : (string)reader["strBranchName"], FiscalYear = ReferenceEquals(reader["intFiscalYear"], DBNull.Value) ? 0 : (int)reader["intFiscalYear"], BranchID = ReferenceEquals(reader["intBranchID"], DBNull.Value) ? 0 : (int)reader["intBranchID"] //BPRAdjustmentID = ReferenceEquals(reader["intBPRAdjustmentID"], DBNull.Value) ? 0 : (int)reader["intBPRAdjustmentID"], //AdjustmentNo = ReferenceEquals(reader["intAdjustmentNo"], DBNull.Value) ? 0 : (int)reader["intAdjustmentNo"], //BranchID = ReferenceEquals(reader["intBranchID"], DBNull.Value) ? 0 : (int)reader["intBranchID"], //AdjustmentTypeID = ReferenceEquals(reader["intAdjustmentTypeID"], DBNull.Value) ? 0 : (int)reader["intAdjustmentTypeID"], //AdjustmentType = ReferenceEquals(reader["strAdjustmentType"], DBNull.Value) ? String.Empty : (string)reader["strAdjustmentType"], //AdjustmentDate = ReferenceEquals(reader["datAdjustmentDate"], DBNull.Value) ? String.Empty : (string)reader["datAdjustmentDate"], //SupplierName = ReferenceEquals(reader["strSupplierName"], DBNull.Value) ? String.Empty : (string)reader["strSupplierName"], //BPRID = ReferenceEquals(reader["intBPRID"], DBNull.Value) ? 0 : (int)reader["intBPRID"], //BPRNo = ReferenceEquals(reader["intBPRNo"], DBNull.Value) ? 0 : (int)reader["intBPRNo"], //SINo = ReferenceEquals(reader["intSINo"], DBNull.Value) ? 0 : (int)reader["intSINo"], //Total = ReferenceEquals(reader["curTotal"], DBNull.Value) ? 0 : (decimal)reader["curTotal"], //Remarks = ReferenceEquals(reader["strRemarks"], DBNull.Value) ? String.Empty : (string)reader["strRemarks"] }; bpradjustments.Add(bpradjustment); } } } } return(bpradjustments); }