public string add_new_song_dtl(cSong s)
{
string sql = "insert into song_detail (" +
" SONG_ID," +
" SONG_CAT_ID," +
" SONG_TYPE_ID," +
" SONG_SUBTYPE_ID," +
" SONG_TEXT_PATH_ID," +
" SONG_GENERAL_NUMBER," +
" SONG_WORSHIP_NUMBER," +
" SONG_KEY," +
" PHONOGRAM," +
" SONG_STATE," +
" SYSTEM_DATE," +
" SYSTEM_TYPE," +
" SYSTEM_CNT)" +
" values (" +
s.song_id + "," +
s.song_cat_id + "," +
s.song_type_id + "," +
s.song_worship_prd_id + "," +
s.song_text_path_id + "," +
"'" + s.song_general_num + "'," +
"'" + s.song_worship_num + "'," +
"'" + s.song_key + "'," +
"'" + s.song_phonogram + "'," +
"'" + s.song_state + "'," +
"#" + s.song_sys_date + "#," +
"'I'," +
"0)";
return(sql);
}
public bool add_new_song(cSong s)
{
bool stat = false;
string sql = sql_lib.add_new_song(s);
if (mdb.Execute(sql) == true)
{
sql = sql_lib.add_new_song_dtl(s);
}
else
{
return(stat);
}
if (mdb.Execute(sql) == true)
{
stat = move_song_home(s.song_name_path, s.song_text_path, s.song_text_path + "\\" + s.song_name + ".docx", false); // docm
if (stat == true)
{
stat = create_preview_file(s.song_text_path + "\\" + s.song_name + ".docx", s.song_text_path + "\\Preview\\" + s.song_name + ".rtf");
}
if (stat == true)
{
stat = create_chords_file(s.song_text_path + "\\" + s.song_name + ".docx");
}
}
return(stat);
}
private string get_song_params()
{
string song_params = "";
cSong s = new cSong();
s.song_cat_id = utl.get_cbo_itm_key(cboSongCat);
s.song_type_id = utl.get_cbo_itm_key(cboSongType);
s.song_worship_prd_id = utl.get_cbo_itm_key(cboWorshipTime);
if (cur_item != null)
{
if (cur_item.Name == "mAscByName")
{
s.sort_by_order = mAscByName.Tag.ToString();
}
else if (cur_item.Name == "mDescByName")
{
s.sort_by_order = mDescByName.Tag.ToString();
}
else if (cur_item.Name == "mAscByDate")
{
s.sort_by_order = mAscByDate.Tag.ToString();
}
else if (cur_item.Name == "mDescByDate")
{
s.sort_by_order = mDescByDate.Tag.ToString();
}
}
song_params = "ПЕСНИ_ПО_КАТЕГОРИЯМ;" + "song_cat_id=;" + s.song_cat_id + ";song_type_id=;" +
s.song_type_id + ";song_worship_prd_id=;" + s.song_worship_prd_id + ";song_sort_by_order=;" + s.sort_by_order;
return(song_params);
}
public bool remove_song(cSong s)
{
bool stat = false;
string sql = sql_lib.remove_song(s);
stat = mdb.Execute(sql);
return(stat);
}
public string remove_song(cSong s)
{
string sql = "UPDATE song_detail " +
" set SONG_STATE = '" + s.song_state + "'," +
" SYSTEM_DATE = #" + s.song_sys_date + "#," +
" SYSTEM_TYPE = 'D'," +
" SYSTEM_CNT = SYSTEM_CNT+1" +
" where song_id = " + s.song_id;
return(sql);
}
public string update_song(cSong s)
{
string sql = "UPDATE song " +
" set SONG_NAME = '" + s.song_name + "'," +
" SONG_NOTE = '" + s.song_note + "'," +
" SYSTEM_DATE = #" + s.song_sys_date + "#," +
" SYSTEM_TYPE = 'U'," +
" SYSTEM_CNT = SYSTEM_CNT+1" +
" where song_id = " + s.song_id;
return(sql);
}
public bool edit_song(cSong s, bool song_location_changed)
{
bool stat = false;
string sql = sql_lib.update_song(s);
if (mdb.Execute(sql) == true)
{
sql = sql_lib.update_song_dtl(s);
}
else
{
return(stat);
}
stat = mdb.Execute(sql);
if (stat == true)
{
if (song_location_changed == true)
{
// move song
stat = move_song_home(s.orig_song_path + "\\" + s.song_name + ".docx", s.song_text_path, s.song_text_path +
"\\" + s.song_name + ".docx", true); // .docm
// move preview
if (stat == true)
{
stat = move_song_home(s.orig_song_path + "\\Preview\\" + s.song_name + ".rtf", s.song_text_path +
"\\Preview", s.song_text_path + "\\Preview\\" + s.song_name + ".rtf", true);
}
// move chords
if (stat == true)
{
s.source_chords_path = get_source_chords_path(s.orig_song_path);
s.dest_chords_path = get_source_chords_path(s.song_text_path);
if (s.source_chords_path.Length > 0)
{
stat = move_song_home(s.source_chords_path + "\\" + s.song_name + ".docx", s.dest_chords_path, s.dest_chords_path +
"\\" + s.song_name + ".docx", true);
}
}
}
}
return(stat);
}
public string add_new_song(cSong s)
{
string sql = "insert into song (" +
" SONG_NAME," +
" SONG_NOTE," +
" SYSTEM_DATE," +
" SYSTEM_TYPE," +
" SYSTEM_CNT)" +
" values (" +
"'" + s.song_name + "'," +
"'" + s.song_note + "'," +
"#" + s.song_sys_date + "#," +
"'I'," +
"0)";
return(sql);
}
public string update_song_dtl(cSong s)
{
string sql = "UPDATE song_detail " +
" set SONG_CAT_ID = " + s.song_cat_id + "," +
" SONG_TYPE_ID = " + s.song_type_id + "," +
" SONG_SUBTYPE_ID = " + s.song_worship_prd_id + "," +
" SONG_TEXT_PATH_ID = " + s.song_text_path_id + "," +
" SONG_GENERAL_NUMBER = '" + s.song_general_num + "'," +
" SONG_WORSHIP_NUMBER = " + s.song_id + "," +
" SONG_KEY = '" + s.song_key + "'," +
" PHONOGRAM = '" + s.song_phonogram + "'," +
" SONG_STATE = '" + s.song_state + "'," +
" SYSTEM_DATE = #" + s.song_sys_date + "#," +
" SYSTEM_TYPE = 'U'," +
" SYSTEM_CNT = SYSTEM_CNT+1" +
" where song_id = " + s.song_id;
return(sql);
}
