private HejriCommonDate HejriCommonDateHelper(OracleDataReader reader)
{
HejriCommonDate hejriCommonDate = new HejriCommonDate();
hejriCommonDate.GregorianDate = Convert.ToDateTime(reader["GREGORIAN_DATE"]);
hejriCommonDate.HijriDay = Convert.ToInt32(reader["HEJRA_DD"]);
hejriCommonDate.HijriMonth = Convert.ToInt32(reader["HEJRA_MM"]);
hejriCommonDate.HijriYear = Convert.ToInt32(reader["HEJRA_YYYY"]);
return hejriCommonDate;
}
public string FromHijriToGer(string date)
{
GetCommonData();
string[] dateArrr;
string[] timeArray = date.Split(' ');
if (timeArray.Count() == 2)
{
dateArrr = timeArray[0].Split('/');
}
else
{
dateArrr = date.Split('/');
}
if (dateArrr.Count() == 3)
{
var x = from z in list where z.HijriDay >= Convert.ToInt32(dateArrr[0]) && z.HijriMonth >= Convert.ToInt32(dateArrr[1]) && z.HijriYear >= Convert.ToInt32(dateArrr[2]) select z;
List<HejriCommonDate> dtList = x.ToList<HejriCommonDate>();
dtList = x.ToList<HejriCommonDate>();
if (dtList != null)
{
HejriCommonDate hejriCommonDate = new HejriCommonDate();
hejriCommonDate = dtList[dtList.Count - 1];
int result = Convert.ToInt32(dateArrr[0]) - hejriCommonDate.HijriDay;
if (timeArray.Count() == 2)
{
return hejriCommonDate.GregorianDate.AddDays(result).Date.ToString("d/M/yyyy") + " " + timeArray[1];
}
else
{
return hejriCommonDate.GregorianDate.AddDays(result).Date.ToString("d/M/yyyy");
}
}
else
{
return "لاتوجد معلومات بالبحث المطلوب";
}
}
else
{
return "حدث خطأ في تحويل التاريخ الرجاء التأكد من صيغة التاريخ";
}
}
private void GetCommonData()
{
List<HejriCommonDate> hejriCommonDateList = new List<HejriCommonDate>();
OracleConnection conn = new OracleConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
OracleCommand com = new OracleCommand("VW_HEJRA_DATES_FIND_ALL", conn);
try
{
conn.Open();
com.CommandType = System.Data.CommandType.StoredProcedure;
OracleParameter parameter = new OracleParameter();
parameter.Direction = System.Data.ParameterDirection.InputOutput;
parameter.OracleDbType = OracleDbType.RefCursor;
com.Parameters.Add(parameter);
OracleDataReader reader = com.ExecuteReader();
while (reader.Read())
{
HejriCommonDate hejriCommonDate = new HejriCommonDate();
hejriCommonDate = HejriCommonDateHelper(reader);
if (hejriCommonDate != null)
hejriCommonDateList.Add(hejriCommonDate);
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
conn.Clone();
com.Clone();
}
list = hejriCommonDateList;
}