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