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