private CommonWork MakeObject(SqlDataReader oReader) { oReader.Read(); CommonWork oCommonWork = new CommonWork(); oCommonWork = MapObject(oReader); return(oCommonWork); }
public JsonResult ExecCommonWork(CommonWork oCommonWork) { CommonWork objCommonWork = new CommonWork(); CommonWorkService objCommonWorkService = new CommonWorkService(); string sFeedBackMessage = objCommonWorkService.ExecCommonWork(oCommonWork, 1); JavaScriptSerializer serializer = new JavaScriptSerializer(); string sjson = serializer.Serialize(sFeedBackMessage); return(Json(sjson, JsonRequestBehavior.AllowGet)); }
private List <CommonWork> MakeObjects(SqlDataReader oReader) { List <CommonWork> oCommonWorks = new List <CommonWork>(); while (oReader.Read()) { CommonWork oCommonWork = MapObject(oReader); oCommonWorks.Add(oCommonWork); } return(oCommonWorks); }
public ActionResult ViewCommonWork(int nUserID) { SessionObj oSessionobj = new SessionObj(Session); CommonWork oCommonWork = new CommonWork(); List <CommonWork> oCommonWorks = new List <CommonWork>(); CommonWorkService oCommonWorkService = new CommonWorkService(); oCommonWorks = oCommonWorkService.Gets(nUserID); ViewBag.CommonWorks = oCommonWorks; return(View()); }
private CommonWork MapObject(SqlDataReader oReader) { CommonWork oCommonWork = new CommonWork(); oCommonWork.CommonWorkID = (int)oReader["CommonWorkID"]; oCommonWork.CommonWorkName = oReader["CommonWorkName"].ToString(); oCommonWork.WhereCols = oReader["WhereCols"].ToString(); oCommonWork.UpdateCols = oReader["UpdateCols"].ToString(); oCommonWork.Remarks = oReader["Remarks"].ToString(); oCommonWork.TypeID = (int)oReader["TypeID"]; oCommonWork.TypeName = oReader["TypeName"].ToString(); return(oCommonWork); }
public List <CommonWork> Gets(string sSQL, int nUserID) { Connection.Open(); Command.CommandText = CommonWorkDA.Gets(sSQL, nUserID); SqlDataReader reader = Command.ExecuteReader(); CommonWork _oCommonWork = new CommonWork(); List <CommonWork> _oCommonWorks = new List <CommonWork>(); if (reader.HasRows) { _oCommonWorks = MakeObjects(reader); } reader.Close(); Connection.Close(); return(_oCommonWorks); }
public static void ClassInitialize(TestContext context) { expected_s = File.ReadAllText(@"C:\Users\typev\source\repos\Test_IHS\Test_IHS\bin\Debug\1.txt", Encoding.UTF8) .Split(new string[] { ",", "\r\n" }, StringSplitOptions.RemoveEmptyEntries); common = new FileModeOfOperation(); expected = new Dictionary <string, int>(); for (int i = 0; i < expected_s.Length; i += 2) { if (expected.ContainsKey(expected_s[i].Substring(0, 1).ToUpper() + expected_s[i].Substring(1))) { expected[expected_s[i].Substring(0, 1).ToUpper() + expected_s[i].Substring(1)] += Convert.ToInt32(expected_s[i + 1].Trim()); } else { expected.Add(expected_s[i].Substring(0, 1).ToUpper() + expected_s[i].Substring(1), Convert.ToInt32(expected_s[i + 1].Trim())); } } }
public string ExecCommonWork(CommonWork oCommonWork, int nUserID) { string sReturnMessage = ""; Command.CommandText = CommonWorkDA.ExecCommonWork(oCommonWork, nUserID); SqlDataAdapter da = new SqlDataAdapter(Command.CommandText, Command.Connection); da.SelectCommand = Command; DataSet oDataSet = new DataSet(); Connection.Open(); try { da.Fill(oDataSet); } catch (Exception e) { sReturnMessage = e.Message.Split('~')[1]; } Connection.Close(); return(sReturnMessage); }
public static string ExecCommonWork(CommonWork oCommonWork, int nUserID) { return(GlobalHelpers.ExcecuteQurey("EXEC SP_CommonWork", oCommonWork.CommonWorkID, oCommonWork.CommonWorkName, oCommonWork.UpdateCols, nUserID)); }
static void Main(string[] args) { CommonWork.ProcessData(args[0], args[1]); }