public static List <InternalRegionBO> GetInternalRegion()
{
var dbUtil = new DatabaseManager();
var ir = new List <InternalRegionBO>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spGetMasInternalRegion";
cmd.CommandTimeout = 180;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var irs = new InternalRegionBO
{
ID = ReferenceEquals(reader["ID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["ID"]),
strName = ReferenceEquals(reader["strName"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strName"]),
intIDAM = ReferenceEquals(reader["intIDAM"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDAM"]),
strAMName = ReferenceEquals(reader["strAMName"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strAMName"]),
intIDOM = ReferenceEquals(reader["intIDOM"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDOM"]),
strOMName = ReferenceEquals(reader["strOMName"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strOMName"]),
intIDMasMajorRegion = ReferenceEquals(reader["intIDMasMajorRegion"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDMasMajorRegion"]),
strMasMajorRegion = ReferenceEquals(reader["strMasMajorRegion"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strMasMajorRegion"]),
intStatus = ReferenceEquals(reader["intStatus"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intStatus"]),
strStatus = ReferenceEquals(reader["strStatus"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strStatus"]),
strRightCode = ReferenceEquals(reader["strRightCode"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strRightCode"])
};
ir.Add(irs);
}
return(ir);
}
}
}
}
public static string ManageInternalRegion(NameValueCollection querystring)
{
var ir = new InternalRegionBO();
UserProfile objUserProfile = WebCommon.GetUserProfile();
int ID;
string strMode;
ir.ID = int.TryParse(querystring.Get("intIRID"), out ID) ? ID : 0;
ir.strName = querystring.Get("strName");
ir.intIDAM = int.TryParse(querystring.Get("intIDAM"), out ID) ? ID : 0;
ir.intIDOM = int.TryParse(querystring.Get("intIDOM"), out ID) ? ID : 0;
ir.intIDMasMajorRegion = int.TryParse(querystring.Get("intIDMasMajorRegion"), out ID) ? ID : 0;
ir.intStatus = int.TryParse(querystring.Get("intStatus"), out ID) ? ID : 0;
ir.strRightCode = querystring.Get("strRightCode");
ir.intIDSecUser = objUserProfile.UserId;
strMode = querystring.Get("strMode");
string param = WebCommon.ToXML(ir);
return(InternalRegionDAL.ManageInternalRegion(param, strMode));
}