public void UpdateBhikkuAsapuwa(int bhikkuChangeListID, BhikkuPost Post, BhikkuChangeType changeType)
{
ClearParameters();
AddParameter("@p_ID", bhikkuChangeListID);
AddParameter("@p_Post", (int)Post);
AddParameter("@p_ChangeType", (int)changeType);
ExecuteNonQueryOutput("ChangeListBhikku_Upd");
}
public BhikkuAsapuHistry(int id, int asapuID, DateTime fromDate, DateTime toDate, string asapuName, BhikkuPost post, string note)
{
ID = id;
AsapuID = asapuID;
FromDate = fromDate;
ToDate = toDate;
AsapuName = asapuName;
Post = post;
Note = note;
}
public void UpdatePost(int bhikkuID, BhikkuPost _post, DateTime fromDate, DateTime toDate)
{
if (DateTime.Now < toDate)
{
AddParameter("@p_ID", bhikkuID);
AddParameter("@p_Post", (int)_post);
ExecuteNonQuery("Bikku_UpdPost");
}
}
//Asapu histry
public void AddAsapuHistry(int asapuID, DateTime fromDate, DateTime toDate, BhikkuPost _post, string note)
{
//string SQL = "INSERT INTO BhikkuAsapu(BhikkuID,AsapuID,FromDate,ToDate,Deleted) VALUES(@BhikkuID,p_AsapuID,p_FromDate,p_ToDate,0)";
AddParameter("@p_BhikkuID", ID);
AddParameter("@p_AsapuID", asapuID);
AddParameter("@p_FromDate", fromDate);
AddParameter("@p_ToDate", toDate);
AddParameter("@p_Post", (int)_post);
AddParameter("@p_Note", note);
ExecuteNonQuery("AsapuHistry_Add");
UpdatePost(ID, _post, fromDate, toDate);
}
public int AddBhikkuAsapuwa(int ChangeListID, int asapuwaID, int bhikkuID, BhikkuPost Post, BhikkuChangeType changeType)
{
ClearParameters();
AddParameter("@p_ChangeListID", ChangeListID);
AddParameter("@p_BhikkuID", bhikkuID);
AddParameter("@p_AsapuwaID", asapuwaID);
AddParameter("@p_Post", (int)Post);
AddParameter("@p_ChangeType", (int)changeType);
AddParameter("@p_ID", MySqlDbType.Int32);
ExecuteNonQueryOutput("ChangeListBhikku_Add");
return((int)GetOutputValue("@p_ID"));
}
public AsapuwaHistryCurrentBhikku(string name, string dur, BhikkuPost pst)
{
BhikkuName = name;
Duration = dur;
Post = pst;
}
private void SetFields(MySqlDataReader reader)
{
NIC = reader.GetString(0);
SamaneraNumber = reader.GetString(1);
PassportNumber = reader.GetString(2);
PlaceOfBirth = reader.GetString(3);
LayNameInFull = reader.GetString(4);
DateOfBirth = reader.GetDateTime(5);
NameOfFatherInFull = reader.GetString(6);
DateOfRobing = reader.GetDateTime(7);
NameAssumedAtRobing = reader.GetString(8);
NameOfRobingTutor = reader.GetInt32(9);
TempleRobing = reader.GetInt32(10);
TempleOfResidence = reader.GetInt32(11);
NameOfViharadhipathi = reader.GetInt32(12);
IsUpasampanna = reader.GetBoolean(13);
PlaceOfHigherOrdination = reader.GetInt32(14);
DateOfHigherOrdination = reader.GetDateTime(15);
NameOfUpadyaAtHigherOrdination = reader.GetInt32(16);
IsUpadyaThero = reader.GetBoolean(17);
Post = (BhikkuPost)reader.GetInt32(18);
District = reader.GetInt32(19);
DateOfCame = reader.GetDateTime(20);
ImageData = reader.IsDBNull(21) ? null : reader.GetString(21);
BloodGroup = reader.GetString(22);
Dharmadeshanaa = reader.GetBoolean(23);
Vandanaa = reader.GetBoolean(24);
Sajjayana = reader.GetBoolean(25);
Sinhala = reader.GetBoolean(26);
Tamil = reader.GetBoolean(27);
English = reader.GetBoolean(28);
Hindhi = reader.GetBoolean(29);
OtheLanguage = reader.GetString(30);;
UpasampadaNumber = reader.GetString(31);;
UpasampadaRegDate = reader.GetDateTime(32);
KarmacharyaHimi1 = reader.GetInt32(33);
KarmacharyaHimi2 = reader.GetInt32(34);
KarmacharyaHimi3 = reader.GetInt32(35);
MahaNayakaHimidetails = reader.GetInt32(36);
AcharyaHimiDetails = reader.GetInt32(37);
UpadyaTheroName = reader.GetInt32(38);
Nikaya = reader.GetInt32(39);
HomeTP = reader.GetString(40);
HomeAddress = reader.GetString(41);
UpasampadaMahaNayakaHimidetails = reader.GetInt32(42);
UpasampadaAcharyaHimiDetails = reader.GetInt32(43);
UpasampadaNikaya = reader.GetInt32(44);
Country = reader.GetInt32(45);
OrderNumber = reader.GetInt32(46);
Number = reader.GetInt32(47);
CurrentStatus = (CurrenStatus)reader.GetInt32(48);
CurrentStatusComment = reader.GetString(49);
HomeTP2 = reader.GetString(50);
using (UtilityData ud = new UtilityData(true))
{
OtherLanguages = ud.SelectByIds(OtheLanguage);
}
}