public int insertAuditCalender(AuditCalender calender) { int AuditCalenderID = 0; try { OrganizationHelper organizationhelper = new OrganizationHelper(); foreach (var Year in calender.newyearid) { calender.Year = Year; AuditCalenderID = organizationhelper.insertupdateAuditCalender(calender, 'I'); } } catch { throw; } return(AuditCalenderID); }
public bool updateAuditCalender(AuditCalender calender) { int AuditCalenderID = 0; bool updateResult = false; try { OrganizationHelper organizationhelper = new OrganizationHelper(); AuditCalenderID = organizationhelper.insertupdateAuditCalender(calender, 'U'); if (AuditCalenderID != 0) { updateResult = true; } } catch { throw; } return(updateResult); }
public int insertupdateAuditCalender(AuditCalender calender, char Flag) { int auditcalenderid = 0; try { if (calender != null) { conn.Open(); MySqlTransaction tran = conn.BeginTransaction(); MySqlCommand cmd = new MySqlCommand("sp_insertUpdateAuditCalender", conn, tran); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("p_Flag", Flag); cmd.Parameters.AddWithValue("p_Audit_Calender_ID", calender.AuditCalenderID); cmd.Parameters.AddWithValue("p_Org_Hier_ID", calender.CompanyID); cmd.Parameters.AddWithValue("p_Compliance_Type_ID", calender.ComplainceTypeID); cmd.Parameters.AddWithValue("p_Start_Date", calender.StartDate); cmd.Parameters.AddWithValue("p_End_Date", calender.EndDate); cmd.Parameters.AddWithValue("p_Audit_Year", calender.Year); MySqlDataAdapter adapter = new MySqlDataAdapter(cmd); object calenderid = cmd.ExecuteScalar(); if (Convert.ToInt32(calenderid) != 0) { auditcalenderid = Convert.ToInt32(calenderid); } tran.Commit(); } } catch { throw; } finally { conn.Close(); } return(auditcalenderid); }