public static CI_ManageResult manage(int intIDSecUser, CI_MasCI ci) { var manageResult = new CI_ManageResult(); try { var dbUtil = new DatabaseManager(); using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB"))) { string result = string.Empty; conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spMasterfileCI_manageCI"; cmd.CommandTimeout = 180; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@intIDMasCI", ci.intIDMasCI); cmd.Parameters.AddWithValue("@intIDMasEmployee", ci.intIDMasEmployee); cmd.Parameters.AddWithValue("@intIDMasBranchZone", ci.intIDMasBranchZone); cmd.Parameters.AddWithValue("@intIsActive", ci.intIsActive); cmd.Parameters.AddWithValue("@intIDSecUser", intIDSecUser); result = (string)cmd.ExecuteScalar(); } if (result.Contains("Success121")) { string[] separators = { "," }; string[] words = result.Split(separators, StringSplitOptions.RemoveEmptyEntries); manageResult.Message = "Success"; manageResult.ID = int.Parse(words[1].ToString()); } else { manageResult.Message = result; manageResult.ID = 0; } } } catch (Exception ex) { manageResult.Message = "Error: " + ex.ToString(); manageResult.ID = 0; } return(manageResult); }
public static CI_ManageResult manage(NameValueCollection querystring) { UserProfile userProfile = WebCommon.GetUserProfile(); int intParser; var mst = new CI_MasCI { intIDMasCI = int.TryParse(querystring.Get("intIDMasCI"), out intParser) ? intParser : 0, intIDMasEmployee = int.TryParse(querystring.Get("intIDMasEmployee"), out intParser) ? intParser : 0, intIDMasBranchZone = int.TryParse(querystring.Get("intIDMasBranchZone"), out intParser) ? intParser : 0, intIsActive = int.TryParse(querystring.Get("intIsActive"), out intParser) ? intParser : 0 }; int intIDSecUser = int.Parse(userProfile.UserId.ToString()); return(CreditInvestigatorDal.manage(intIDSecUser, mst)); }
public static List <CI_MasCI> geCI(int intIDSecUser, int intIDMasLocation, string strCriteria) { var dbUtil = new DatabaseManager(); var ltoList = new List <CI_MasCI>(); using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB"))) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spMasterfileCI_getCI"; cmd.CommandTimeout = 180; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@intIDSecUser", intIDSecUser); cmd.Parameters.AddWithValue("@strCriteria", strCriteria); cmd.Parameters.AddWithValue("@intIDMasLocation", intIDMasLocation); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { var item = new CI_MasCI { intIDMasCI = int.Parse(reader["intIDMasCI"].ToString()), intIDMasEmployee = int.Parse(reader["intIDMasEmployee"].ToString()), EmployeeName = reader["EmployeeName"].ToString(), intIDMasLocation = int.Parse(reader["intIDMasLocation"].ToString()), LocationName = reader["LocationName"].ToString(), intIDMasBranchZone = int.Parse(reader["intIDMasBranchZone"].ToString()), ZoneName = reader["ZoneName"].ToString(), intIsActive = int.Parse(reader["intIsActive"].ToString()), }; ltoList.Add(item); } return(ltoList); } } } }