public CalInfo GetCalInfoByTitle(string CalID) { var result = new CalInfo(); var sql = string.Empty; try { sql = string.Format(InitObject.GetScriptServiceInstance().GetCalInfoByTitle, CalID); var dt = DBHelper.MySqlHelper.GetDataSet(BznsBase.GetConnectionString, BznsBase.GetCommandType, sql, null).Tables[0]; if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; result.CalID = dr["school_calendar_id"].ToString(); result.Title = dr["school_calendar_title"].ToString(); result.Type = dr["class_type"].ToString(); } } catch (Exception) { throw; } return(result); }
public bool InsertClass(string AcadYear, string PlanID, int SchoolCalPos, int ClassTypePos, int ClassNamePos, int CapacityPos, int StartTimePos, int EndTimePos, int ClassAliasPos, int GradeTypePos, int AllowOverbookedPos, DataTable Classes, bool IsTry2Import) { var Result = false; var KindergartenId = BznsBase.KindergartenId; var BrandId = BznsBase.BrandID; var UserID = BznsBase.UserID; var Sql = string.Empty; var ClassID = string.Empty; var CreateDate = InitObject.GetSysDate(); using (MySqlConnection conn = new MySqlConnection(BznsBase.GetConnectionString)) { MySqlTransaction trans = null; conn.Open(); trans = conn.BeginTransaction(); try { foreach (DataRow dr in Classes.Rows) { ClassID = InitObject.GetUUID(); var SchoolCal = SchoolCalPos == -1 ? string.Empty : dr[SchoolCalPos].ToString(); var ClassType = ClassTypePos == -1 ? string.Empty : InitObject.GetClassTypeByName(dr[ClassTypePos].ToString()); var ClassName = ClassNamePos == -1 ? string.Empty : dr[ClassNamePos].ToString(); var Capacity = CapacityPos == -1 ? 0:int.Parse(dr[CapacityPos].ToString()); var StartTime = StartTimePos == -1 ? string.Empty : dr[StartTimePos].ToString(); var EndTime = EndTimePos == -1 ? string.Empty : dr[EndTimePos].ToString(); var ClassAlias = ClassAliasPos == -1 ? string.Empty : dr[ClassAliasPos].ToString(); var GradeType = GradeTypePos == -1 ? string.Empty : InitObject.GetGradeTypeByName(dr[GradeTypePos].ToString()); var AllowOverbooked = AllowOverbookedPos == -1 ? string.Empty : dr[AllowOverbookedPos].ToString(); var CalInfo = new CalInfo(); if (!string.IsNullOrEmpty(SchoolCal)) { CalInfo = GetCalInfoByTitle(SchoolCal); } try { Sql = string.Format(InitObject.GetScriptServiceInstance().ClassTempInsert, AcadYear, PlanID, ClassID, GradeType, ClassType, CalInfo.CalID, ClassName, ClassAlias, Capacity, AllowOverbooked, StartTime, EndTime, UserID, CreateDate, KindergartenId); DBHelper.MySqlHelper.ExecuteNonQuery(trans, BznsBase.GetCommandType, Sql, null); Sql = string.Format(InitObject.GetScriptServiceInstance().ClassInsert, AcadYear, PlanID, ClassID, GradeType, ClassType, CalInfo.CalID, ClassName, ClassAlias, Capacity, AllowOverbooked, StartTime, EndTime, UserID, CreateDate, KindergartenId); DBHelper.MySqlHelper.ExecuteNonQuery(trans, BznsBase.GetCommandType, Sql, null); } catch (Exception ex) { SysLog.Insert(new SysLogInfo(string.Concat("Import Class LogID:", dr["LogID"].ToString(), " Error Message:", ex.Message), SysLogType.ERROR, ModuleName)); } finally { } } if (IsTry2Import) { trans.Rollback(); } else { trans.Commit(); } Result = true; } catch (Exception ex) { SysLog.Insert(new SysLogInfo(ex.Message.ToString(), SysLogType.ERROR, string.Concat(ModuleName, " - ", "Import Class Bzns"))); trans.Rollback(); } finally { trans = null; } } return(Result); }