public static int UpdateInformation(A2ZALLOWCTRLDTO dto) { int rowEffect = 0; string strQuery = "UPDATE A2ZALLOWCTRL set dependsOn='" + dto.DependsOn + "', Location='" + dto.Location + "', Percentage='" + dto.Percentage + "', ServType='" + dto.ServType + "', Religion='" + dto.Religion + "' where AllowCode='" + dto.AllowCode + "'"; rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZHRMCUS")); if (rowEffect == 0) { return(0); } else { return(1); } }
public static int InsertInformation(A2ZALLOWCTRLDTO dto) { int rowEffect = 0; string strQuery = @"INSERT into A2ZALLOWCTRL(AllowCode,AllowDesc,DependsOn,Location, Percentage,ServType,Religion) values('" + dto.AllowCode + "','" + dto.AllowDesc + "','" + dto.DependsOn + "','" + dto.Location + "','" + dto.Percentage + "','" + dto.ServType + "','" + dto.Religion + "')"; rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZHRMCUS")); if (rowEffect == 0) { return(0); } else { return(1); } }
public static A2ZALLOWCTRLDTO GetInformation(int AllowCode) { DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZALLOWCTRL WHERE AllowCode = '" + AllowCode + "'", "A2ZHRMCUS"); var p = new A2ZALLOWCTRLDTO(); if (dt.Rows.Count > 0) { p.AllowCode = Converter.GetInteger(dt.Rows[0]["AllowCode"]); p.AllowDesc = Converter.GetString(dt.Rows[0]["AllowDesc"]); p.DependsOn = Converter.GetInteger(dt.Rows[0]["DependsOn"]); p.Location = Converter.GetBoolean(dt.Rows[0]["Location"]); p.Percentage = Converter.GetBoolean(dt.Rows[0]["Percentage"]); p.ServType = Converter.GetBoolean(dt.Rows[0]["ServType"]); p.Religion = Converter.GetBoolean(dt.Rows[0]["Religion"]); return(p); } p.AllowCode = 0; return(p); }