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