public static bool DeleteInstitution(int institutionID) { try { return(DLLInstitution.DeleteInstitution(institutionID)); } catch (Exception ex) { throw ex; } }
public static int SaveInstitution(ATTInstitution ObjAtt) { try { return(DLLInstitution.SaveInstitution(ObjAtt)); } catch (Exception ex) { throw ex; } }
public static List <ATTInstitution> GetInstitution(int?institutionID, string active) { List <ATTInstitution> LstInstitution = new List <ATTInstitution>(); try { foreach (DataRow row in DLLInstitution.GetInstitution(institutionID, active).Rows) { ATTInstitution ObjAtt = new ATTInstitution ( (row["INSTITUTION_ID"] == System.DBNull.Value) ? 0 : long.Parse(row["INSTITUTION_ID"].ToString()), (row["INSTITUTION_NAME"] == System.DBNull.Value) ? "" : (string)row["INSTITUTION_NAME"], (row["BOARD_NAME"] == System.DBNull.Value) ? "" : (string)row["BOARD_NAME"], (row["LOCATION"] == System.DBNull.Value) ? "" : (string)row["LOCATION"], (row["COUNTRY_ID"] == System.DBNull.Value) ? 0 : int.Parse(row["COUNTRY_ID"].ToString()), (row["ACTIVE"] == System.DBNull.Value) ? "" : (string)row["ACTIVE"], (row["INSTITUTION_TYPE"] == System.DBNull.Value) ? "" : (string)row["INSTITUTION_TYPE"], "" ); ObjAtt.InstitutionNameBoardCountry = (row["INSTITUTION_NAME"] == System.DBNull.Value) ? "" : (string)row["INSTITUTION_NAME"] + "("; ObjAtt.InstitutionNameBoardCountry += (row["BOARD_NAME"] == System.DBNull.Value) ? "" : (string)row["BOARD_NAME"] + ","; ObjAtt.InstitutionNameBoardCountry += (row["LOCATION"] == System.DBNull.Value) ? "" : (string)row["LOCATION"] + ","; ObjAtt.InstitutionNameBoardCountry += (row["COUNTRY_NEP_NAME"] == System.DBNull.Value) ? "" : (string)row["COUNTRY_NEP_NAME"] + ","; if (ObjAtt.InstitutionNameBoardCountry.Substring(ObjAtt.InstitutionNameBoardCountry.Length - 1) != "(") { ObjAtt.InstitutionNameBoardCountry = ObjAtt.InstitutionNameBoardCountry.Substring(0, ObjAtt.InstitutionNameBoardCountry.Length - 1); ObjAtt.InstitutionNameBoardCountry += ")"; } else { ObjAtt.InstitutionNameBoardCountry = ObjAtt.InstitutionNameBoardCountry.Substring(0, ObjAtt.InstitutionNameBoardCountry.Length - 1); } LstInstitution.Add(ObjAtt); } return(LstInstitution); } catch (Exception ex) { throw ex; } }