public static string Manage(NameValueCollection formdata) { string isInsert = formdata.Get("TransType"); int intParser; decimal curAmt; UserProfile userProfile = WebCommon.GetUserProfile(); var panquota = new BranchUIIRate { ID = int.TryParse(formdata.Get("ID"), out intParser) ? intParser : 0, intYear = int.TryParse(formdata.Get("intYear"), out intParser) ? intParser : 0, intMonth = int.TryParse(formdata.Get("intMonth"), out intParser) ? intParser : 0, curRate = decimal.TryParse(formdata.Get("curRate"), out curAmt) ? curAmt : 0 }; string param = WebCommon.ToXML(panquota); return(BranchUIIMasterDAL.Manage(param, isInsert)); }
public static List <BranchUIIRate> GetBranchUII() { var dbUtil = new DatabaseManager(); var brDetail = new List <BranchUIIRate>(); using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB"))) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spBranchUIIGetMaster"; cmd.CommandTimeout = 180; cmd.Parameters.Clear(); //cmd.Parameters.AddWithValue("@intIDMasLocation", branchID); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { var brdtl = new BranchUIIRate { ID = ReferenceEquals(reader["ID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["ID"]), intYear = ReferenceEquals(reader["intYear"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intYear"]), intMonth = ReferenceEquals(reader["intMonth"], String.Empty) ? 0 : Convert.ToInt32(reader["intMonth"]), curRate = ReferenceEquals(reader["curRate"], DBNull.Value) ? 0 : Convert.ToDecimal(reader["curRate"]) }; brDetail.Add(brdtl); } return(brDetail); } } } }